APPS.HR_PERSON_INTERNAL dependencies on HR_ORGANIZATION_INFORMATION

Line 501: from hr_organization_information org_info

497: org_info.attribute17,
498: org_info.attribute18,
499: org_info.attribute19,
500: org_info.attribute20
501: from hr_organization_information org_info
502: where org_info.organization_id = p_organization_id
503: and org_info.org_information_context = 'Organization Name Alias'
504: and org_info.org_information2 = to_char(p_person_id);
505: --

Line 515: from hr_organization_information org_info

511: from hr_all_organization_units org,
512: hr_all_organization_units_tl org_tl
513: where org.organization_id = org_tl.organization_id
514: and exists (select null
515: from hr_organization_information org_info
516: where org_info.organization_id = org.organization_id
517: and org_info.org_information_context = 'Organization Name Alias'
518: and org_info.org_information2 = to_char(p_person_id));
519: --