DBA Data[Home] [Help]

APPS.PAY_FI_PAYLIST_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 379: per_all_assignments_f paaf

375: pay_payroll_actions appa2,
376: pay_assignment_actions act,
377: pay_assignment_actions act1,
378: pay_action_interlocks pai,
379: per_all_assignments_f paaf
380: WHERE appa.payroll_action_id=p_run_payroll_action_id
381: AND appa.action_type IN ('R', 'Q')
382: AND act.payroll_action_id = appa.payroll_action_id
383: AND act.source_action_id IS NULL -- Master Action

Line 648: per_all_assignments_f paa,

644: PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER,
645: -- pap.national_identifier national_identifier,
646: paa.assignment_id assignment_id
647: FROM per_all_people_f pap,
648: per_all_assignments_f paa,
649: pay_assignment_actions pasa
650: WHERE paa.person_id = pap.person_id
651: AND pasa.assignment_id = paa.assignment_id
652: AND pap.business_group_id = csr_v_business_group_id