DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 54: FROM pay_assignment_actions paa

50: --
51: /*
52: CURSOR c_body IS
53: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
54: FROM pay_assignment_actions paa
55: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
56: ('TRANSFER_PAYROLL_ACTION_ID'))
57: ORDER BY paa.assignment_action_id;
58: */

Line 62: FROM pay_assignment_actions paa,

58: */
59:
60: CURSOR c_body IS
61: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
62: FROM pay_assignment_actions paa,
63: pay_action_information pai
64: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value
65: ('TRANSFER_PAYROLL_ACTION_ID'))
66: and paa.assignment_action_id=pai.action_context_id