DBA Data[Home] [Help]

APPS.PAY_IE_CESS_REPORT dependencies on PAY_ACTION_INFORMATION

Line 63: pay_action_information pai

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
67: and pai.ACTION_INFORMATION_CATEGORY='IE CESS INFORMATION'