DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 184: per_assignment_status_types past,

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
188: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)

Line 324: per_assignment_status_types past,

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
328: WHERE paas.assignment_action_id = p_assignment_action_id