DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_MAGTAPE_GENERIC

Line 67: WHERE paa.payroll_action_id = to_number (pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID'))

63: CURSOR c_body IS
64: SELECT 'TRANSFER_ACT_ID=P'
65: ,paa.assignment_action_id
66: FROM pay_assignment_actions paa
67: WHERE paa.payroll_action_id = to_number (pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID'))
68: ORDER BY paa.assignment_action_id;
69: /**************************************************************************/
70: CURSOR c_hdr IS
71: SELECT 'PAYROLL_ACTION_ID=P'

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

68: ORDER BY paa.assignment_action_id;
69: /**************************************************************************/
70: CURSOR c_hdr IS
71: SELECT 'PAYROLL_ACTION_ID=P'
72: ,pay_magtape_generic.get_parameter_value ('TRANSFER_PAYROLL_ACTION_ID')
73: FROM dual;
74: /**************************************************************************/
75: CURSOR c_asg_actions IS
76: SELECT 'TRANSFER_ACT_ID=P'

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

73: FROM dual;
74: /**************************************************************************/
75: CURSOR c_asg_actions IS
76: SELECT 'TRANSFER_ACT_ID=P'
77: ,pay_magtape_generic.get_parameter_value ('TRANSFER_ACT_ID')
78: FROM dual;
79:
80: END PER_NL_DSR_ARCHIVE;
81: