DBA Data[Home] [Help]

APPS.PAY_NO_ARC_HOLIDAY_ENTITLEMENT dependencies on HR_ORGANIZATION_INFORMATION

Line 186: hr_organization_information hoi

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)
189: AND paaf.assignment_status_type_id = past.assignment_status_type_id
190: AND papf.business_group_id = csr_v_business_group_id

Line 327: hr_organization_information hoi

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
329: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)
330: AND paaf.person_id = papf.person_id
331: AND paaf.assignment_status_type_id = past.assignment_status_type_id