APPS.PAY_DIRECT_DEPOSIT_XML dependencies on PAY_PRE_PAYMENTS

Line 31: pay_pre_payments table also.

27: vpandya 10-Feb-2006 115.4 5032348 Changed cursor c_get_details
28: added alias payroll_action_id
29: column as this column has newly
30: been created for
31: pay_pre_payments table also.
32: ========================================================================*/
33:
34: CURSOR main_block IS
35: SELECT 'ROOT_XML_TAG=P',

Line 67: ,pay_pre_payments ppp

63: 'TRANSFER_PRE_PAY_ID=P',ppp.pre_payment_id,
64: 'TRANSFER_PREPAY_ASG_ACT=P',ppp.assignment_action_id,
65: 'DEPOSIT_AMOUNT=P', ppp.value
66: FROM pay_assignment_actions paa
67: ,pay_pre_payments ppp
68: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value(
69: 'PAYROLL_ACTION_ID')
70: and paa.pre_payment_id = ppp.pre_payment_id;
71: