DBA Data[Home] [Help]

APPS.PAY_NO_SC_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 181: hr_organization_information hoi

177: FROM per_all_people_f papf,
178: per_all_assignments_f paaf,
179: per_assignment_status_types past,
180: hr_soft_coding_keyflex hsc,
181: hr_organization_information hoi
182: WHERE paaf.person_id = papf.person_id
183: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)
184: AND paaf.assignment_status_type_id = past.assignment_status_type_id
185: AND papf.business_group_id = csr_v_business_group_id

Line 300: hr_organization_information hoi

296: per_assignment_status_types past,
297: pay_assignment_actions paas,
298: per_all_people_f papf,
299: hr_soft_coding_keyflex hsc,
300: hr_organization_information hoi
301: where paas.assignment_action_id = p_assignment_action_id
302: and paa.person_id = papf.person_id
303: AND papf.person_id = nvl(csr_v_person_id,papf.person_id)
304: and paa.absence_attendance_type_id = paat.absence_attendance_type_id