APPS.PAY_CA_RL2_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 102: pay_assignment_actions paa,

98: FROM pay_action_information pin,
99: per_all_people_f ppf,
100: per_all_assignments_f paf,
101: pay_action_interlocks pai,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_assignment_actions paa_arch
105: WHERE ppa.payroll_action_id =
106: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))

Line 104: pay_assignment_actions paa_arch

100: per_all_assignments_f paf,
101: pay_action_interlocks pai,
102: pay_assignment_actions paa,
103: pay_payroll_actions ppa,
104: pay_assignment_actions paa_arch
105: WHERE ppa.payroll_action_id =
106: to_number( pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'))
107: AND paa.payroll_action_id = ppa.payroll_action_id
108: AND pai.locking_action_id = paa.assignment_action_id

Line 188: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

184: PROCEDURE archive_ca_deinit(p_pactid IN NUMBER);
185:
186: PROCEDURE xml_employee_record;
187:
188: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
189: p_taxation_year in varchar2,
190: p_rep_type in varchar2)
191: RETURN BLOB;
192:

Line 193: PROCEDURE fetch_rl2_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

189: p_taxation_year in varchar2,
190: p_rep_type in varchar2)
191: RETURN BLOB;
192:
193: PROCEDURE fetch_rl2_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
194: p_asg_id in per_assignments_f.assignment_id%TYPE,
195: p_rep_type in varchar2,
196: p_taxation_year in varchar2,
197: p_print_instruction in varchar2,

Line 225: from pay_assignment_actions

221:
222: /* commented by sneelapa for bug 7563384 and redefined below.
223: cursor transfer_block is
224: select 'TRANSFER_ACT_ID=P', assignment_action_id
225: from pay_assignment_actions
226: where payroll_action_id =
227: pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
228: */
229:

Line 237: pay_assignment_actions paa1,

233: hr_all_organization_units hou,
234: hr_locations_all loc,
235: per_all_people_f ppf,
236: per_all_assignments_f paf,
237: pay_assignment_actions paa1,
238: pay_payroll_actions ppa1
239: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
240: and paa1.payroll_action_id = ppa1.payroll_action_id
241: and paa1.assignment_id = paf.assignment_id