DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on PJI_PJP_PROJ_EXTR_STATUS

Line 2855: from PJI_PJP_PROJ_EXTR_STATUS pjp);

2851: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
2852: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
2853: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
2854: tmp6.PROJECT_ID in (select pjp.PROJECT_ID
2855: from PJI_PJP_PROJ_EXTR_STATUS pjp);
2856:
2857: end if;
2858:
2859: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT(p_worker_id);');

Line 3037: from PJI_PJP_PROJ_EXTR_STATUS pjp)

3033: tmp6.PROJECT_ROLE_ID = hdr.PROJECT_ROLE_ID and
3034: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3035: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3036: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3037: from PJI_PJP_PROJ_EXTR_STATUS pjp)
3038: group by
3039: hdr.TXN_ACCUM_HEADER_ID,
3040: hdr.RESOURCE_CLASS_ID,
3041: tmp6.PROJECT_ID,

Line 3394: from PJI_PJP_PROJ_EXTR_STATUS pjp)

3390: tmp6.NAMED_ROLE = hdr.NAMED_ROLE and
3391: tmp6.PERSON_TYPE = hdr.PERSON_TYPE and
3392: tmp6.SYSTEM_LINKAGE_FUNCTION = hdr.SYSTEM_LINKAGE_FUNCTION and
3393: tmp6.PROJECT_ID not in (select pjp.PROJECT_ID
3394: from PJI_PJP_PROJ_EXTR_STATUS pjp)
3395: group by
3396: hdr.TXN_ACCUM_HEADER_ID,
3397: tmp6.PROJECT_ID,
3398: tmp6.PROJECT_ORG_ID,