eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_SUM_PSI dependencies on PJI_PJP_PROJ_EXTR_STATUS

Line 2890: from PJI_PJP_PROJ_EXTR_STATUS pjp);

2886: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
2887: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
2888: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
2889: tmp6.PROJECT_ID in (select pjp.PROJECT_ID
2890: from PJI_PJP_PROJ_EXTR_STATUS pjp);
2891:
2892: end if;
2893:
2894: -- OLAP

Line 3140: from PJI_PJP_PROJ_EXTR_STATUS pjp);

3136: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
3137: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3138: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3139: tmp6.PROJECT_ID in (select pjp.PROJECT_ID
3140: from PJI_PJP_PROJ_EXTR_STATUS pjp);
3141:
3142:
3143: end if;
3144:

Line 3326: from PJI_PJP_PROJ_EXTR_STATUS pjp)

3322: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
3323: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3324: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3325: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3326: from PJI_PJP_PROJ_EXTR_STATUS pjp)
3327: group by
3328: hdr.TXN_ACCUM_HEADER_ID,
3329: hdr.RESOURCE_CLASS_ID,
3330: tmp6.PROJECT_ID,

Line 3393: from PJI_PJP_PROJ_EXTR_STATUS pjp) and

3389: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
3390: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3391: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3392: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3393: from PJI_PJP_PROJ_EXTR_STATUS pjp) and
3394: tmp6.project_id = prj.project_id and
3395: prj.pjt_rollup_enabled_flag = 'Y' and
3396: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3397: from PA_STAGE1_BATCH_OLAP pjp);

Line 3815: from PJI_PJP_PROJ_EXTR_STATUS pjp)

3811: tmp6.NAMED_ROLE = hdr.NAMED_ROLE and
3812: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3813: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3814: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3815: from PJI_PJP_PROJ_EXTR_STATUS pjp)
3816: group by
3817: hdr.TXN_ACCUM_HEADER_ID,
3818: tmp6.PROJECT_ID,
3819: tmp6.PROJECT_ORG_ID,

Line 3876: from PJI_PJP_PROJ_EXTR_STATUS pjp) and

3872: tmp6.NAMED_ROLE = hdr.NAMED_ROLE and
3873: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3874: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3875: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3876: from PJI_PJP_PROJ_EXTR_STATUS pjp) and
3877: tmp6.project_id = prj.project_id and
3878: prj.pjt_rollup_enabled_flag = 'Y' and
3879: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3880: from PA_STAGE1_BATCH_OLAP pjp);