APPS.PJI_PMV_ENGINE dependencies on PA_PROJECT_TYPES_ALL

Line 437: , PA_PROJECT_TYPES_ALL PJT

433: END IF;
434: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
435: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
436: FROM PJI_CLASS_CODES CLS
437: , PA_PROJECT_TYPES_ALL PJT
438: , PJI_PMV_ORG_DIM_TMP ORG
439: WHERE PJT.ORG_ID = ORG.ID
440: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
441: AND CLS.RECORD_TYPE = 'T';

Line 449: , PA_PROJECT_TYPES_ALL PJT

445: END IF;
446: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
447: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
448: FROM PJI_CLASS_CODES CLS
449: , PA_PROJECT_TYPES_ALL PJT
450: , PJI_PMV_ORG_DIM_TMP ORG
451: WHERE PJT.ORG_ID = ORG.ID
452: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
453: AND CLS.CLASS_CATEGORY = p_Classification_ID;

Line 477: , PA_PROJECT_TYPES_ALL PJT

473: FORALL i IN 1..l_Dimension_List_Tab.Last
474: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
475: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
476: FROM PJI_CLASS_CODES CLS
477: , PA_PROJECT_TYPES_ALL PJT
478: , PJI_PMV_ORG_DIM_TMP ORG
479: WHERE PJT.ORG_ID = ORG.ID
480: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
481: AND CLS.RECORD_TYPE = 'T'

Line 488: , PA_PROJECT_TYPES_ALL PJT

484: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
485: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
486: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
487: FROM PJI_CLASS_CODES CLS
488: , PA_PROJECT_TYPES_ALL PJT
489: , PJI_PMV_ORG_DIM_TMP ORG
490: WHERE PJT.ORG_ID = ORG.ID
491: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
492: AND CLS.RECORD_TYPE = 'T'

Line 505: , PA_PROJECT_TYPES_ALL PJT

501: FORALL i IN 1..l_Dimension_List_Tab.Last
502: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
503: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
504: FROM PJI_CLASS_CODES CLS
505: , PA_PROJECT_TYPES_ALL PJT
506: , PJI_PMV_ORG_DIM_TMP ORG
507: WHERE PJT.ORG_ID = ORG.ID
508: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
509: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);

Line 515: , PA_PROJECT_TYPES_ALL PJT

511: FOR i IN 1..l_Dimension_List_Tab.Last LOOP
512: INSERT INTO PJI_PMV_CLS_DIM_TMP (ID, NAME)
513: SELECT DISTINCT CLS.CLASS_ID, DECODE(p_View_BY,'CC',CLS.CLASS_CODE,'-1')
514: FROM PJI_CLASS_CODES CLS
515: , PA_PROJECT_TYPES_ALL PJT
516: , PJI_PMV_ORG_DIM_TMP ORG
517: WHERE PJT.ORG_ID = ORG.ID
518: AND CLS.CLASS_CODE = PJT.PROJECT_TYPE
519: AND CLS.CLASS_ID = l_Dimension_List_Tab(i);