DBA Data[Home] [Help]

APPS.PAY_AE_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 446: per_all_assignments_f as1

442: pay_payroll_actions appa2,
443: pay_assignment_actions act,
444: pay_assignment_actions act1,
445: pay_action_interlocks pai,
446: per_all_assignments_f as1
447: WHERE ppa.payroll_action_id = p_payroll_action_id
448: AND appa.consolidation_set_id = p_consolidation_id
449: AND appa.effective_date BETWEEN l_canonical_start_date
450: AND l_canonical_end_date

Line 897: ,per_all_assignments_f paa

893: ,hla.address_line_3 AL3
894: ,hla.postal_code postal_code
895: FROM hr_locations_all hla
896: ,hr_organization_units hou
897: ,per_all_assignments_f paa
898: ,hr_soft_coding_keyflex hscl
899: WHERE hscl.segment1 = hou.organization_id
900: AND hscl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
901: AND hou.location_id = hla.location_id