Can I access CD table values within an Apply's SQL stmt (or calledSP)

Hello. I've read that the Apply within Data Propagator can perform additional SQL, or call a Stored Procedure, when processing a subscription set. However, all the information that I have read show examples of broad functions being performed, and I have not seen any that utilize values from the CD table.

I'd like to perform some SQL, or call an SP, prior to a row being processed from the CD table but it needs to be specific to data on that row. I do not think something like this is available within the DProp functionality, as it seems to be only available to pre-set or post-set processing. The only way I think I can accomplish this is by utilizing triggers on the target.

Does anyone know if SQL within the Apply can utilize values from the CD table?

- Bill -