DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on PJM_ORG_PARAMETERS

Line 402: from pjm_org_parameters

398: if (X_Project_ID is not null) then
399: L_PO_Project := X_Project_ID;
400: else
401: select common_project_id into L_PO_Project
402: from pjm_org_parameters
403: where organization_id = X_Org_ID;
404: end if;
405:
406: RETURN ( L_PO_Project );

Line 548: FROM pjm_org_parameters pp;

544:
545: CURSOR c IS
546: SELECT nvl(max(pp.project_reference_enabled) , 'N')
547: , decode(max(pp.common_project_id) , NULL , 'N' , 'Y')
548: FROM pjm_org_parameters pp;
549:
550: CURSOR c2 IS
551: SELECT ou.Oracle_Username
552: FROM fnd_product_installations pi