APPS.PAY_IE_CESS_REPORT dependencies on PAY_MAGTAPE_GENERIC

Line 55: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value

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: */
59:

Line 64: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value

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'
68: and pai.ACTION_CONTEXT_TYPE='AAP'

Line 74: ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

70: --
71:
72: CURSOR c_hdr IS
73: SELECT 'PAYROLL_ACTION_ID=P'
74: ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
75: FROM dual;
76:
77: CURSOR c_asg_actions IS
78: SELECT 'TRANSFER_ACT_ID=P'

Line 79: ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

75: FROM dual;
76:
77: CURSOR c_asg_actions IS
78: SELECT 'TRANSFER_ACT_ID=P'
79: ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
80: FROM dual;
81:
82:
83: END PAY_IE_CESS_REPORT;