DBA Data[Home] [Help]

APPS.PAY_SA_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 437: per_all_assignments_f as1

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

Line 879: ,per_all_assignments_f paa

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