APPS.PJI_FM_EXTR dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 579: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)

575: and drv.pa_date is not null
576: and agr.agreement_id = drv.agreement_id
577: union all
578: SELECT /*+ ordered
579: index(log, PA_PJI_PROJ_EVENTS_LOG_N1)
580: full(imp) use_hash(imp)
581: full(paprd) use_hash(paprd)
582: full(glprd) use_hash(glprd)
583: full(sob) use_hash(sob)

Line 605: pa_pji_proj_events_log log

601: , null pji_summarized_flag
602: , agr.customer_id customer_id
603: , ceil(ROWNUM / PJI_FM_SUM_MAIN.g_commit_threshold) batch_id
604: FROM
605: pa_pji_proj_events_log log
606: , pji_fm_proj_batch_map bat
607: , pa_agreements_all agr
608: /* Note:
609: * The tables below are not needed if Billing Team

Line 757: DELETE pa_pji_proj_events_log

753: and drvn.batch_id = l_helper_batch_id);
754:
755: -- Clean up log table
756:
757: DELETE pa_pji_proj_events_log
758: WHERE rowid in (select row_id
759: from PJI_FM_EXTR_DREVN
760: where line_source_type = 'L'
761: and batch_id = l_helper_batch_id);

Line 889: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */

885: 'N') = 'N' and
886: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
887: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
888: 'N') = 'N') then
889: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
890: from PA_PJI_PROJ_EVENTS_LOG log
891: where EVENT_TYPE = 'DRAFT_REVENUES';
892: end if;
893:

Line 890: from PA_PJI_PROJ_EVENTS_LOG log

886: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
887: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
888: 'N') = 'N') then
889: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
890: from PA_PJI_PROJ_EVENTS_LOG log
891: where EVENT_TYPE = 'DRAFT_REVENUES';
892: end if;
893:
894: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,

Line 1900: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */

1896: 'N') = 'N' and
1897: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1898: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
1899: 'N') = 'N') then
1900: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
1901: from PA_PJI_PROJ_EVENTS_LOG log
1902: where EVENT_TYPE = 'DRAFT_REVENUES';
1903: end if;
1904:

Line 1901: from PA_PJI_PROJ_EVENTS_LOG log

1897: nvl(PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER
1898: (PJI_FM_SUM_MAIN.g_process, 'CONFIG_PROFIT_FLAG'),
1899: 'N') = 'N') then
1900: delete /*+ index (log, PA_PJI_PROJ_EVENTS_LOG_N1) */
1901: from PA_PJI_PROJ_EVENTS_LOG log
1902: where EVENT_TYPE = 'DRAFT_REVENUES';
1903: end if;
1904:
1905: -- delete Non-Util --> Util resources that are getting extracted anyway