DBA Data[Home] [Help]

APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on PJM_ORG_PARAMETERS

Line 40: SELECT 'X' FROM pjm_org_parameters

36: L_Result BOOLEAN;
37: L_Msg VARCHAR2(2000);
38:
39: CURSOR Org_C IS
40: SELECT 'X' FROM pjm_org_parameters
41: WHERE Organization_ID = L_ID
42: AND PROJECT_REFERENCE_ENABLED = 'Y';
43:
44: CURSOR Prj_C IS

Line 495: from pjm_org_parameters

491: select 'OKE_TASK_REQUIRED'
492: from dual
493: where not exists (
494: select 'Task Reference OK'
495: from pjm_org_parameters
496: where organization_id = l_org_id
497: and not ( project_control_level = 2
498: and l_task_id is null )
499: );