DBA Data[Home] [Help]

APPS.PER_NL_LTSRR_ARCHIVE dependencies on PAY_MAGTAPE_GENERIC

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

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

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

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

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

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