APPS.PER_NL_DSRR_ARCHIVE dependencies on PAY_MAGTAPE_GENERIC

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

55: /**************************************************************************/
56: CURSOR c_body IS
57: SELECT 'TRANSFER_ACT_ID=P', paa.assignment_action_id
58: FROM pay_assignment_actions paa
59: WHERE paa.payroll_action_id = to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
60: ORDER BY paa.assignment_action_id;
61: /**************************************************************************/
62: CURSOR c_hdr IS
63: SELECT 'PAYROLL_ACTION_ID=P'

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

60: ORDER BY paa.assignment_action_id;
61: /**************************************************************************/
62: CURSOR c_hdr IS
63: SELECT 'PAYROLL_ACTION_ID=P'
64: ,pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
65: FROM dual;
66: /**************************************************************************/
67: CURSOR c_asg_actions IS
68: SELECT 'TRANSFER_ACT_ID=P'

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

65: FROM dual;
66: /**************************************************************************/
67: CURSOR c_asg_actions IS
68: SELECT 'TRANSFER_ACT_ID=P'
69: ,pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
70: FROM dual;
71:
72: END PER_NL_DSRR_ARCHIVE;
73: