APPS.PA_RESOURCE_UTILS dependencies on PA_ALL_ORGANIZATIONS

Line 587: pa_all_organizations org

583: select 'X'
584: from dual
585: where exists (select res.resource_id
586: from pa_resources_denorm res,
587: pa_all_organizations org
588: where org.pa_org_use_type = 'EXPENDITURES'
589: and org.inactive_date IS NULL
590: and org.organization_id = res.resource_organization_id
591: and res.resource_id = p_resource_id

Line 672: pa_all_organizations org

668: select 'X'
669: from dual
670: where exists (select res.resource_id
671: from pa_resources_denorm res,
672: pa_all_organizations org
673: where org.pa_org_use_type = 'EXPENDITURES'
674: and org.inactive_date IS NULL
675: and org.organization_id = res.resource_organization_id
676: and res.resource_id = p_resource_id

Line 2797: FROM pa_all_organizations o,

2793: -- Commented out for bug 2876296
2794: /*
2795: SELECT 'Y'
2796: INTO x_valid
2797: FROM pa_all_organizations o,
2798: pa_implementations i -- Added for bug 2673140
2799: WHERE o.pa_org_use_type = 'EXPENDITURES'
2800: AND o.inactive_date is null
2801: AND o.organization_id = p_organization_id

Line 2808: FROM pa_all_organizations

2804: */
2805:
2806: SELECT 'Y'
2807: INTO x_valid
2808: FROM pa_all_organizations
2809: WHERE pa_org_use_type = 'EXPENDITURES'
2810: AND inactive_date is null
2811: AND organization_id = p_organization_id
2812: AND rownum = 1;