DBA Data[Home] [Help]

APPS.HR_ORD_BUS dependencies on HR_ORGANIZATION_INFORMATION

Line 202: from hr_organization_information

198: --
199: cursor c_valid_hr_org
200: (p_organization_id in number) is
201: select organization_id
202: from hr_organization_information
203: where organization_id = p_organization_id
204: and org_information_context = 'CLASS'
205: and org_information1 = 'HR_ORG'
206: and org_information2 = 'Y';

Line 307: from hr_organization_information inf

303: cursor c_valid_org_class
304: (p_organization_id in number
305: ,p_org_link_type in varchar2) is
306: select organization_id
307: from hr_organization_information inf
308: ,hr_de_org_link_types_mapping map
309: where inf.organization_id = p_organization_id
310: and inf.org_information_context = 'CLASS'
311: and inf.org_information2 = 'Y'