DBA Data[Home] [Help]

APPS.PAY_GB_RTI_OUTPUT dependencies on PAY_MAGTAPE_GENERIC

Line 26: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

22: --
23: CURSOR eas_header IS
24:
25: select 'PAYROLL_ACTION_ID=P',
26: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
27: from dual;
28:
29: CURSOR eas_employee IS
30: select

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

34: paa.assignment_id,
35: 'TRANSFER_ACT_ID=P',
36: paa.assignment_action_id
37: from pay_assignment_actions paa
38: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
39:
40: CURSOR eas_asg_actions IS
41: select
42: 'TRANSFER_ACT_ID=P',

Line 43: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

39:
40: CURSOR eas_asg_actions IS
41: select
42: 'TRANSFER_ACT_ID=P',
43: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
44: from dual;
45: --
46: CURSOR nino_header IS
47:

Line 49: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

45: --
46: CURSOR nino_header IS
47:
48: select 'PAYROLL_ACTION_ID=P',
49: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
50: from dual;
51:
52: CURSOR nino_employee IS
53: select

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

57: paa.assignment_id,
58: 'TRANSFER_ACT_ID=P',
59: paa.assignment_action_id
60: from pay_assignment_actions paa
61: where paa.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
62:
63: CURSOR nino_asg_actions IS
64: select
65: 'TRANSFER_ACT_ID=P',

Line 66: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

62:
63: CURSOR nino_asg_actions IS
64: select
65: 'TRANSFER_ACT_ID=P',
66: pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
67: from dual;
68: --
69: level_cnt number;
70: --