DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 438: per_all_assignments_f as1

434: pay_payroll_actions appa2,
435: pay_assignment_actions act,
436: pay_assignment_actions act1,
437: pay_action_interlocks pai,
438: per_all_assignments_f as1
439: WHERE ppa.payroll_action_id = p_payroll_action_id
440: AND appa.consolidation_set_id = p_consolidation_id
441: AND appa.effective_date BETWEEN l_canonical_start_date
442: AND l_canonical_end_date

Line 880: ,per_all_assignments_f paa

876: ,hla.address_line_3 AL3
877: ,hla.postal_code postal_code
878: FROM hr_locations_all hla
879: ,hr_organization_units hou
880: ,per_all_assignments_f paa
881: ,hr_soft_coding_keyflex hscl
882: WHERE hscl.segment1 = hou.organization_id
883: AND hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
884: AND hou.location_id = hla.location_id