APPS.PAY_KR_SEP_ARCHIVE_PKG dependencies on PAY_RUN_TYPES_F

Line 266: pay_run_types_f prt,

262: pay_input_values_f piv3,
263: pay_input_values_f piv4,
264: per_people_f pap,
265: per_assignments_f paaf,
266: pay_run_types_f prt,
267: fnd_territories ft
268: where ppa.payroll_action_id = p_payroll_action_id
269: and ppa.business_group_id = p_business_group_id
270: and paa.assignment_id = p_assignment_id

Line 330: pay_run_types_f prt

326: pay_input_values_f piv1,
327: pay_input_values_f piv2,
328: pay_input_values_f piv3,
329: pay_input_values_f piv4,
330: pay_run_types_f prt
331: where ppa.payroll_action_id = p_payroll_action_id
332: and ppa.business_group_id = p_business_group_id
333: and paa.assignment_id = p_assignment_id
334: and ppa.payroll_action_id = paa.payroll_action_id

Line 475: pay_run_types_f prt,

471: pay_element_links_f pel,
472: pay_element_types_f pet,
473: pay_payroll_actions ppa,
474: pay_assignment_actions paa,
475: pay_run_types_f prt,
476: pay_input_values_f piv1,
477: pay_element_entry_values_f peev1
478: where pet.element_name = 'PREV_ER_INFO'
479: and pel.element_link_id = pee.element_link_id

Line 696: from pay_run_types_f prt,

692: select paa.assignment_id,
693: paa.assignment_action_id,
694: paa.source_action_id,
695: paa.tax_unit_id
696: from pay_run_types_f prt,
697: pay_payroll_actions ppa,
698: pay_assignment_actions paa,
699: per_assignments_f pa,
700: pay_payroll_actions bppa

Line 733: pay_run_types_f prt2,

729: and trunc(appa.effective_date,'YYYY') = trunc(bppa.effective_date,'YYYY')
730: union all -- 4660184
731: select 'x'
732: from pay_payroll_actions ppa2,
733: pay_run_types_f prt2,
734: pay_assignment_actions paa2
735: where paa2.assignment_id = paa.assignment_id
736: and prt2.run_type_id = paa2.run_type_id
737: and prt2.run_type_id = ppa2.run_type_id