DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on PAY_MAGTAPE_GENERIC

Line 23: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

19: --
20: CURSOR fps_header IS
21:
22: select 'PAYROLL_ACTION_ID=P',
23: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
24: from dual;
25:
26: CURSOR fps_employee IS
27: select

Line 35: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');

31: paa.assignment_id,
32: 'TRANSFER_ACT_ID=P',
33: paa.assignment_action_id
34: from pay_assignment_actions paa
35: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
36:
37: CURSOR fps_asg_actions IS
38: select
39: 'TRANSFER_ACT_ID=P',

Line 40: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

36:
37: CURSOR fps_asg_actions IS
38: select
39: 'TRANSFER_ACT_ID=P',
40: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
41: from dual;
42: --
43:
44: level_cnt number;