DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_MAGTAPE_GENERIC

Line 124: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')

120: per_all_people_f ppf,
121: per_all_assignments_f paf,
122: pay_assignment_actions paa1,
123: pay_payroll_actions ppa1
124: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
125: and paa1.payroll_action_id = ppa1.payroll_action_id
126: and paa1.assignment_id = paf.assignment_id
127: and paf.effective_start_date =
128: (select max(paf2.effective_start_date)

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

159: 'LOCATION',loc.location_code,null),
160: ppf.last_name,first_name;
161:
162: cursor assignment_block is
163: select 'TRANSFER_ACT_ID=P',pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID')
164: from sys.dual;
165:
166: level_cnt NUMBER :=0;
167: g_temp_dir VARCHAR2(512);