DBA Data[Home] [Help]

APPS.PAY_KW_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 444: per_all_assignments_f as1

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

Line 894: ,per_all_assignments_f paa

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