APPS.PA_RESOURCE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 473: FROM HR_ORGANIZATION_INFORMATION PLE,

469: select
470: 'Y'
471: into
472: X_CC_OK
473: FROM HR_ORGANIZATION_INFORMATION PLE,
474: HR_ORGANIZATION_INFORMATION RLE,
475: pa_project_types_all PT,
476: pa_projects_all P,
477: pa_implementations_all iprv,

Line 474: HR_ORGANIZATION_INFORMATION RLE,

470: 'Y'
471: into
472: X_CC_OK
473: FROM HR_ORGANIZATION_INFORMATION PLE,
474: HR_ORGANIZATION_INFORMATION RLE,
475: pa_project_types_all PT,
476: pa_projects_all P,
477: pa_implementations_all iprv,
478: pa_implementations_all irecv

Line 2601: FROM hr_organization_information ou

2597:
2598: BEGIN
2599: SELECT to_number(ou.org_information1)
2600: INTO x_default_ou
2601: FROM hr_organization_information ou
2602: WHERE ou.org_information_context = 'Exp Organization Defaults'
2603: AND ou.organization_id = p_organization_id
2604: AND rownum = 1;
2605:

Line 2613: FROM hr_organization_information cal-- R12 HR Org Info change

2609:
2610: BEGIN
2611: SELECT to_number(cal.org_information1)
2612: INTO x_default_cal_id
2613: FROM hr_organization_information cal-- R12 HR Org Info change
2614: WHERE cal.organization_id = p_organization_id
2615: AND cal.org_information_context = 'Resource Defaults'
2616: AND rownum = 1;
2617: