APPS.HR_PERSON dependencies on HR_ORGANIZATION_INFORMATION

Line 80: ,hr_organization_information o3

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
84: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));

Line 128: ,hr_organization_information o3

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
132: AND nvl (o3.org_information16,hr_api.g_varchar2) = 'E'))));

Line 1432: FROM hr_organization_information

1428: hr_utility.set_location('hr_person.validate_national_identifier',1);
1429: end if;
1430: SELECT org_information9
1431: INTO l_legislation_code
1432: FROM hr_organization_information
1433: WHERE org_information_context = 'Business Group Information'
1434: AND organization_id = p_business_group_id;
1435: --
1436: --

Line 1508: FROM hr_organization_information

1504: hr_utility.set_location('hr_person.validate_national_identifier',1);
1505: end if;
1506: SELECT org_information9
1507: INTO l_legislation_code
1508: FROM hr_organization_information
1509: WHERE org_information_context = 'Business Group Information'
1510: AND organization_id = p_business_group_id;
1511: --
1512: --