DBA Data[Home] [Help]

APPS.HR_PERSON dependencies on HR_ALL_ORGANIZATION_UNITS

Line 79: FROM hr_all_organization_units o

75: AND (pp.employee_number = p_person_number
76: OR (pp.npw_number = p_person_number
77: AND EXISTS
78: (SELECT NULL
79: FROM hr_all_organization_units o
80: ,hr_organization_information o3
81: WHERE o.organization_id = o3.organization_id
82: AND o3.org_information_context = 'Business Group Information'
83: AND o.organization_id = p_business_group_id

Line 127: FROM hr_all_organization_units o

123: AND (pp.npw_number = p_person_number
124: OR (pp.employee_number = p_person_number
125: AND EXISTS
126: (SELECT NULL
127: FROM hr_all_organization_units o
128: ,hr_organization_information o3
129: WHERE o.organization_id = o3.organization_id
130: AND o3.org_information_context = 'Business Group Information'
131: AND o.organization_id = p_business_group_id