APPS.IRC_PARTY_API dependencies on HR_ORGANIZATION_INFORMATION

Line 140: from hr_organization_information

136: -- corresponding to the recruiting flexfield on the business group
137: --
138: cursor csr_get_person_type_id(p_business_group_id number) is
139: select org_information8
140: from hr_organization_information
141: where organization_id=p_business_group_id
142: and ORG_INFORMATION_CONTEXT='BG Recruitment';
143: --
144: l_notification_preference_id number;

Line 893: from hr_organization_information

889: -- corresponding to the recruiting flexfield on the business group
890: --
891: cursor csr_get_person_type_id(p_business_group_id number) is
892: select org_information8
893: from hr_organization_information
894: where organization_id=p_business_group_id
895: and ORG_INFORMATION_CONTEXT='BG Recruitment';
896: --
897: l_notification_preference_id number;

Line 2199: FROM HR_ORGANIZATION_INFORMATION org

2195: SELECT org.org_information1
2196: , org.org_information2
2197: , fnd_number.canonical_to_number(org.org_information3) normal_hours
2198: , org.org_information4
2199: FROM HR_ORGANIZATION_INFORMATION org
2200: WHERE org.organization_id = p_organization_id
2201: AND org.org_information_context(+) = 'Work Day Information';
2202: --
2203: CURSOR csr_get_bg_default_details(p_business_group_id number) IS

Line 6307: FROM HR_ORGANIZATION_INFORMATION org

6303: SELECT org.org_information1
6304: , org.org_information2
6305: , fnd_number.canonical_to_number(org.org_information3) normal_hours
6306: , org.org_information4
6307: FROM HR_ORGANIZATION_INFORMATION org
6308: WHERE org.organization_id = p_organization_id
6309: AND org.org_information_context(+) = 'Work Day Information';
6310: --
6311: CURSOR csr_get_bg_default_details(p_business_group_id number) IS