DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PER_ALL_ASSIGNMENTS_F

Line 183: per_all_assignments_f paaf,

179: csr_v_assignment_set_id NUMBER)
180: IS
181: SELECT paaf.assignment_id
182: FROM per_all_people_f papf,
183: per_all_assignments_f paaf,
184: per_assignment_status_types past,
185: hr_soft_coding_keyflex hsc,
186: hr_organization_information hoi
187: WHERE paaf.person_id = papf.person_id

Line 323: per_all_assignments_f paaf,

319: paaf.assignment_id,
320: paaf.assignment_number,
321: past.per_system_status
322: FROM per_all_people_f papf,
323: per_all_assignments_f paaf,
324: per_assignment_status_types past,
325: pay_assignment_actions paas,
326: hr_soft_coding_keyflex hsc,
327: hr_organization_information hoi