APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_MERGE_HELPER

Line 13608: select /*+ parallel(pji_merge_helper) */

13604: x_row_id row_id_tab_type;
13605: xf_row_id row_id_tab_type;
13606:
13607: cursor c1(x_batch_id number) is
13608: select /*+ parallel(pji_merge_helper) */
13609: pjp_row_id,
13610: fact_row_id
13611: from pji_merge_helper
13612: where batch_id = x_batch_id;

Line 13611: from pji_merge_helper

13607: cursor c1(x_batch_id number) is
13608: select /*+ parallel(pji_merge_helper) */
13609: pjp_row_id,
13610: fact_row_id
13611: from pji_merge_helper
13612: where batch_id = x_batch_id;
13613:
13614: BEGIN
13615:

Line 13757: FROM pji_merge_helper tmp

13753: , tmp.CUSTOM14
13754: , tmp.CUSTOM15
13755: , tmp.PLAN_TYPE_CODE
13756: , tmp.fact_row_id
13757: FROM pji_merge_helper tmp
13758: , pji_pjp_wbs_header ver3
13759: WHERE 1 = 1
13760: AND tmp.worker_id = g_worker_id
13761: AND tmp.project_id = ver3.project_id

Line 13991: FROM pji_merge_helper pmh

13987:
13988: delete /*+ parallel(pjp1_d) */
13989: from pji_fp_aggr_pjp1 pjp1_d
13990: where EXISTS (SELECT /*+ parallel(pmh) */ NULL
13991: FROM pji_merge_helper pmh
13992: WHERE pmh.batch_id = p_batch_id
13993: AND pmh.worker_id = g_worker_id
13994: AND pmh.pjp_row_id = pjp1_d.rowid );
13995:

Line 14001: delete /*+ parallel(pji_merge_helper) */

13997:
13998: x_row_id.delete;
13999: xf_row_id.delete;
14000:
14001: delete /*+ parallel(pji_merge_helper) */
14002: from pji_merge_helper
14003: where batch_id = p_batch_id;
14004:
14005: update pji_merge_batch_status

Line 14002: from pji_merge_helper

13998: x_row_id.delete;
13999: xf_row_id.delete;
14000:
14001: delete /*+ parallel(pji_merge_helper) */
14002: from pji_merge_helper
14003: where batch_id = p_batch_id;
14004:
14005: update pji_merge_batch_status
14006: set request_status = 'COMPLETED'