APPS.PAY_CA_RL1_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 101: pay_assignment_actions paa,

97: FROM
98: per_all_people_f ppf,
99: per_all_assignments_f paf,
100: pay_action_interlocks pai,
101: pay_assignment_actions paa,
102: pay_payroll_actions ppa,
103: pay_assignment_actions paa_arch
104: WHERE
105: ppa.payroll_action_id =

Line 103: pay_assignment_actions paa_arch

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

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

192: PROCEDURE xml_transmitter_record;
193:
194: PROCEDURE end_of_file;
195:
196: FUNCTION get_final_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
197: p_taxation_year in varchar2,
198: p_rep_type in varchar2)
199: RETURN BLOB;
200:

Line 201: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,

197: p_taxation_year in varchar2,
198: p_rep_type in varchar2)
199: RETURN BLOB;
200:
201: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
202: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,
203: p_asg_id in per_assignments_f.assignment_id%TYPE,
204: p_rep_type in varchar2,
205: p_province in varchar2,

Line 202: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,

198: p_rep_type in varchar2)
199: RETURN BLOB;
200:
201: PROCEDURE fetch_rl1_xml(p_arch_action_id in pay_assignment_actions.assignment_action_id%TYPE,
202: p_arch_pay_actid in pay_assignment_actions.payroll_action_id%TYPE,
203: p_asg_id in per_assignments_f.assignment_id%TYPE,
204: p_rep_type in varchar2,
205: p_province in varchar2,
206: p_taxation_year in varchar2,

Line 243: pay_assignment_actions paa1,

239: hr_all_organization_units hou,
240: hr_locations_all loc,
241: per_all_people_f ppf,
242: per_all_assignments_f paf,
243: pay_assignment_actions paa1,
244: pay_payroll_actions ppa1
245: where ppa1.payroll_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID')
246: and paa1.payroll_action_id = ppa1.payroll_action_id
247: and paa1.assignment_id = paf.assignment_id