DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on PJM_ORG_PARAMETERS

Line 396: from pjm_org_parameters

392: if (X_Project_ID is not null) then
393: L_PO_Project := X_Project_ID;
394: else
395: select common_project_id into L_PO_Project
396: from pjm_org_parameters
397: where organization_id = X_Org_ID;
398: end if;
399:
400: RETURN ( L_PO_Project );

Line 520: FROM pjm_org_parameters pp;

516:
517: CURSOR c IS
518: SELECT nvl(max(pp.project_reference_enabled) , 'N')
519: , decode(max(pp.common_project_id) , NULL , 'N' , 'Y')
520: FROM pjm_org_parameters pp;
521:
522: CURSOR c2 IS
523: SELECT ou.Oracle_Username
524: FROM fnd_product_installations pi