APPS.PAY_CA_T4A_XML dependencies on PAY_MAGTAPE_GENERIC

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

60: cursor transfer_block is
61: select 'TRANSFER_ACT_ID=P', assignment_action_id
62: from pay_assignment_actions
63: where payroll_action_id =
64: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
65: */
66:
67: -- cursor transfer_block modified by rgottipa for bug 10136689
68:

Line 79: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

75: per_all_assignments_f paf,
76: pay_assignment_actions paa1,
77: pay_payroll_actions ppa1
78: where paa1.payroll_action_id =
79: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
80: and paa1.payroll_action_id = ppa1.payroll_action_id
81: and paa1.assignment_id = paf.assignment_id
82: and paf.effective_start_date =
83: (select max(paf2.effective_start_date)

Line 122: select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

118: ppf.last_name,ppf.first_name;
119:
120:
121: cursor assignment_block is
122: select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
123: from pay_assignment_actions
124: where assignment_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
125: and substr(serial_number,29,1)='N';
126:

Line 124: where assignment_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')

120:
121: cursor assignment_block is
122: select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
123: from pay_assignment_actions
124: where assignment_action_id=pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
125: and substr(serial_number,29,1)='N';
126:
127: level_cnt NUMBER :=0;
128: g_err_emp varchar2(1);