APPS.PA_RESOURCE_UTILS dependencies on HR_ORGANIZATION_INFORMATION

Line 474: FROM HR_ORGANIZATION_INFORMATION PLE,

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

Line 475: HR_ORGANIZATION_INFORMATION RLE,

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

Line 2718: FROM hr_organization_information ou

2714:
2715: BEGIN
2716: SELECT to_number(ou.org_information1)
2717: INTO x_default_ou
2718: FROM hr_organization_information ou
2719: WHERE ou.org_information_context = 'Exp Organization Defaults'
2720: AND ou.organization_id = p_organization_id
2721: AND rownum = 1;
2722:

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

2726:
2727: BEGIN
2728: SELECT to_number(cal.org_information1)
2729: INTO x_default_cal_id
2730: FROM hr_organization_information cal-- R12 HR Org Info change
2731: WHERE cal.organization_id = p_organization_id
2732: AND cal.org_information_context = 'Resource Defaults'
2733: AND rownum = 1;
2734: