DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_AMEND dependencies on PER_ASSIGNMENTS_F

Line 196: FROM per_assignments_f paf

192: ,c_financial_year IN VARCHAR2
193: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
194: IS
195: SELECT DISTINCT paf.assignment_id
196: FROM per_assignments_f paf
197: ,per_people_f ppf
198: ,pay_payroll_actions ppa
199: WHERE ppa.payroll_action_id = c_payroll_action_id
200: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id

Line 242: FROM per_assignments_f paf

238: ,c_financial_year IN VARCHAR2
239: ,c_tax_unit_id IN pay_assignment_actions.tax_unit_iD%TYPE)
240: IS
241: SELECT DISTINCT paf.assignment_id
242: FROM per_assignments_f paf
243: ,per_people_f ppf
244: ,pay_payroll_actions ppa
245: ,hr_assignment_set_amendments has
246: WHERE ppa.payroll_action_id = c_payroll_action_id