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_PLAN_MAINT_PVT dependencies on PA_BUDGET_VERSIONS

Line 335: pa_budget_versions bv,

331: ) lp_flag
332: FROM
333: pji_pjp_proj_batch_map map,
334: pji_pjp_rbs_header rhd,
335: pa_budget_versions bv,
336: pa_proj_fp_options fpo,
337: pji_pa_proj_events_log pel,
338: pa_projects_all ppa,
339: pa_rbs_versions_b rvb --Added for bug#5728852

Line 397: PA_BUDGET_VERSIONS bv,

393: ) lp_flag
394: FROM
395: PJI_PJP_PROJ_BATCH_MAP map,
396: PJI_PJP_RBS_HEADER rhd,
397: PA_BUDGET_VERSIONS bv,
398: PA_PROJ_FP_OPTIONS fpo,
399: PJI_PA_PROJ_EVENTS_LOG pel,
400: PA_RBS_PRJ_ASSIGNMENTS rpa,
401: PA_PROJECTS_ALL ppa,

Line 459: PA_BUDGET_VERSIONS bv,

455: , 'Y' lp_flag
456: FROM
457: PJI_PJP_PROJ_BATCH_MAP map,
458: PJI_PJP_RBS_HEADER rhd,
459: PA_BUDGET_VERSIONS bv,
460: PA_PROJ_FP_OPTIONS fpo,
461: PJI_PA_PROJ_EVENTS_LOG pel,
462: PA_RBS_PRJ_ASSIGNMENTS rpa,
463: PA_PROJECTS_ALL ppa,

Line 597: , pa_budget_versions bv

593: ) lp_flag
594: FROM
595: pji_pjp_proj_batch_map map
596: , pa_projects_all ppa
597: , pa_budget_versions bv
598: , pa_proj_fp_options fpo
599: WHERE 1=1
600: AND ppa.project_id = bv.project_id
601: AND bv.version_type is not NULL -- COST, REVENUE, etc. Should not be null.

Line 681: , pa_budget_versions bv -- @pjdev115 bv

677: ) lp_flag
678: FROM
679: pji_pjp_proj_batch_map map
680: , pa_projects_all ppa -- @pjdev115 ppa
681: , pa_budget_versions bv -- @pjdev115 bv
682: , pa_proj_fp_options fpo -- @pjdev115 fpo
683: , PA_RBS_PRJ_ASSIGNMENTS rpa
684: WHERE 1=1
685: AND ppa.project_id = bv.project_id

Line 791: PA_BUDGET_VERSIONS pbv,

787: , 'Y' lp_flag
788: FROM
789: pji_pjp_proj_batch_map map,
790: PA_PROJECTS_ALL ppa,
791: PA_BUDGET_VERSIONS pbv,
792: pji_pjp_wbs_header head,
793: PA_PROJ_ELEM_VER_STRUCTURE ppevs,
794: PA_PROJ_FP_OPTIONS fpo
795: WHERE

Line 1088: select /+ ordered index(bv PA_BUDGET_VERSIONS_U2) /

1084: WHERE 1=1
1085: AND worker_id = g_worker_id;
1086:
1087: BEGIN
1088: select /*+ ordered index(bv PA_BUDGET_VERSIONS_U2) */
1089: 'Y'
1090: into
1091: l_dangl_exists
1092: from

Line 1094: PA_BUDGET_VERSIONS bv

1090: into
1091: l_dangl_exists
1092: from
1093: PJI_PJP_PROJ_BATCH_MAP map,
1094: PA_BUDGET_VERSIONS bv
1095: where
1096: map.WORKER_ID = g_worker_id and
1097: bv.PROJECT_ID = map.PROJECT_ID and
1098: nvl(bv.WP_VERSION_FLAG, 'N') = 'N' and

Line 1381: , PA_BUDGET_VERSIONS bv

1377: (project_id, plan_version_id, plan_type_id)
1378: SELECT
1379: DISTINCT bv.project_id, bv.budget_version_id, bv.fin_plan_type_id
1380: FROM pji_pjp_proj_batch_map map
1381: , PA_BUDGET_VERSIONS bv
1382: WHERE
1383: map.worker_id = g_worker_id
1384: AND bv.project_id = map.project_id
1385: AND NVL(bv.wp_version_flag, 'N') = 'N'

Line 1529: -- , PA_BUDGET_VERSIONS bv

1525: SELECT /*+ ordered */
1526: DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1527: FROM pji_pjp_proj_batch_map map
1528: , pji_pa_proj_events_log ev
1529: -- , PA_BUDGET_VERSIONS bv
1530: , pji_xbs_denorm den
1531: , pji_pjp_wbs_header wh1 -- sup
1532: , pji_pjp_wbs_header hd9 -- SUb!!
1533: WHERE

Line 1594: , PA_BUDGET_VERSIONS bv

1590: INSERT INTO pji_fm_extr_plnver3_t
1591: (project_id, plan_version_id, plan_type_id)
1592: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1593: FROM pji_pjp_proj_batch_map map
1594: , PA_BUDGET_VERSIONS bv
1595: , pji_pjp_wbs_header hd9 -- SUP
1596: WHERE
1597: map.worker_id = g_worker_id
1598: AND hd9.project_id = map.project_id

Line 1619: , pa_budget_versions bv

1615: SELECT DISTINCT hd9.project_id, hd9.plan_version_id, hd9.plan_type_id
1616: FROM pji_xbs_denorm den
1617: , pji_pjp_wbs_header hd1 -- SUB
1618: , pji_pjp_proj_batch_map map
1619: , pa_budget_versions bv
1620: , pji_pjp_wbs_header hd9 -- SUP
1621: WHERE
1622: den.struct_version_id IS NULL
1623: AND map.project_id = bv.project_id

Line 1901: pa_budget_versions bv -- @pjdev115 bv

1897: , 'N')
1898: , 'N'
1899: ) lp_flag
1900: FROM
1901: pa_budget_versions bv -- @pjdev115 bv
1902: , pa_proj_fp_options fpo -- @pjdev115 fpo
1903: , pa_projects_all ppa -- @pjdev115 ppa
1904: WHERE 1=1
1905: AND ppa.project_id = bv.project_id

Line 1951: pa_budget_versions bv -- @pjdev115 bv

1947: , 'N')
1948: , 'N'
1949: ) lp_flag
1950: FROM
1951: pa_budget_versions bv -- @pjdev115 bv
1952: , pa_proj_fp_options fpo -- @pjdev115 fpo
1953: , pa_projects_all ppa -- @pjdev115 ppa
1954: WHERE 1=1
1955: AND ppa.project_id = bv.project_id

Line 1998: pa_budget_versions bv -- @pjdev115 bv

1994: , 'N')
1995: , 'N'
1996: ) lp_flag
1997: FROM
1998: pa_budget_versions bv -- @pjdev115 bv
1999: , pa_proj_fp_options fpo -- @pjdev115 fpo
2000: , pa_projects_all ppa -- @pjdev115 ppa
2001: WHERE 1=1
2002: AND ppa.project_id = bv.project_id

Line 2073: pa_budget_versions bv -- @pjdev115 bv

2069: , 'N')
2070: , 'N'
2071: ) lp_flag
2072: FROM
2073: pa_budget_versions bv -- @pjdev115 bv
2074: , pa_proj_fp_options fpo -- @pjdev115 fpo
2075: , pa_projects_all ppa -- @pjdev115 ppa
2076: WHERE 1=1
2077: AND ppa.project_id = bv.project_id

Line 2262: pa_budget_versions bv -- @pjdev115 bv

2258: , 'N')
2259: , 'N'
2260: ) lp_flag
2261: FROM
2262: pa_budget_versions bv -- @pjdev115 bv
2263: , pa_proj_fp_options fpo -- @pjdev115 fpo
2264: , pa_projects_all ppa -- @pjdev115 ppa
2265: WHERE 1=1
2266: AND ppa.project_id = bv.project_id

Line 2339: pa_budget_versions bv -- @pjdev115 bv

2335: , 'N')
2336: , 'N'
2337: ) lp_flag
2338: FROM
2339: pa_budget_versions bv -- @pjdev115 bv
2340: , pa_proj_fp_options fpo -- @pjdev115 fpo
2341: , pa_projects_all ppa -- @pjdev115 ppa
2342: , PA_RBS_PRJ_ASSIGNMENTS rpa
2343: WHERE 1=1

Line 2426: , pa_budget_versions bv -- @pjdev115 bv

2422: , 'N'
2423: ) lp_flag
2424: FROM
2425: pji_pjp_proj_batch_map map
2426: , pa_budget_versions bv -- @pjdev115 bv
2427: , pa_projects_all ppa -- @pjdev115 ppa
2428: , pa_proj_fp_options fpo -- @pjdev115 fpo
2429: WHERE 1=1
2430: AND ppa.project_id = bv.project_id

Line 2478: , pa_budget_versions bv -- @pjdev115 bv

2474: , 'N'
2475: ) lp_flag
2476: FROM
2477: pji_pjp_proj_batch_map map
2478: , pa_budget_versions bv -- @pjdev115 bv
2479: , pa_projects_all ppa -- @pjdev115 ppa
2480: , pa_proj_fp_options fpo -- @pjdev115 fpo
2481: WHERE 1=1
2482: AND ppa.project_id = bv.project_id

Line 2534: , pa_budget_versions bv

2530: , 'N'
2531: ) lp_flag
2532: FROM
2533: pji_pjp_proj_batch_map map
2534: , pa_budget_versions bv
2535: , pa_proj_fp_options fpo
2536: , ( SELECT -3 plan_version_id FROM dual
2537: UNION ALL
2538: SELECT -4 plan_version_id FROM dual ) cbco

Line 2613: , pa_budget_versions bv -- @pjdev115 bv

2609: , 'N'
2610: ) lp_flag
2611: FROM
2612: pji_pjp_proj_batch_map map
2613: , pa_budget_versions bv -- @pjdev115 bv
2614: , pa_projects_all ppa -- @pjdev115 ppa
2615: , pa_proj_fp_options fpo -- @pjdev115 fpo
2616: WHERE 1=1
2617: AND ppa.project_id = bv.project_id

Line 2668: , pa_budget_versions bv

2664: , 'N'
2665: ) lp_flag
2666: FROM
2667: pji_pjp_proj_batch_map map
2668: , pa_budget_versions bv
2669: , pa_proj_fp_options fpo
2670: , ( SELECT -3 plan_version_id FROM dual
2671: UNION ALL
2672: SELECT -4 plan_version_id FROM dual ) cbco

Line 2771: , pa_budget_versions bv

2767: , 'N'
2768: ) lp_flag
2769: FROM
2770: pji_pjp_proj_batch_map map
2771: , pa_budget_versions bv
2772: /* Commented for bug 13030627 , pa_projects_all ppa -- @pjdev115 ppa */
2773: , pa_proj_fp_options fpo
2774: , PA_RBS_PRJ_ASSIGNMENTS rpa
2775: WHERE map.project_id = bv.project_id /* Added for bug 13030627 */

Line 2826: , pa_budget_versions bv -- @pjdev115 bv

2822: , 'N'
2823: ) lp_flag
2824: FROM
2825: pji_pjp_proj_batch_map map
2826: , pa_budget_versions bv -- @pjdev115 bv
2827: , pa_projects_all ppa -- @pjdev115 ppa
2828: , pa_proj_fp_options fpo -- @pjdev115 fpo
2829: , PA_RBS_PRJ_ASSIGNMENTS rpa
2830: WHERE ppa.project_id = bv.project_id

Line 2883: , pa_budget_versions bv -- @pjdev115 bv

2879: ) lp_flag
2880: FROM
2881: pji_pjp_proj_batch_map map
2882: , pji_pa_proj_events_log ev
2883: , pa_budget_versions bv -- @pjdev115 bv
2884: , pa_proj_fp_options fpo -- @pjdev115 fpo
2885: -- , pa_projects_all ppa -- @pjdev115 ppa
2886: , PA_RBS_PRJ_ASSIGNMENTS rpa
2887: , ( SELECT -3 plan_version_id FROM dual

Line 2944: , pa_budget_versions bv -- @pjdev115 bv

2940: ) lp_flag
2941: FROM
2942: pji_pa_proj_events_log ev
2943: , PA_RBS_PRJ_ASSIGNMENTS rpa
2944: , pa_budget_versions bv -- @pjdev115 bv
2945: , pa_proj_fp_options fpo -- @pjdev115 fpo
2946: , pa_projects_all ppa -- @pjdev115 ppa
2947: , pji_pjp_proj_batch_map map
2948: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */

Line 3007: , pa_budget_versions bv

3003: , 'N'
3004: ) lp_flag
3005: FROM
3006: PJI_PA_PROJ_EVENTS_LOG ev
3007: , pa_budget_versions bv
3008: , pa_proj_fp_options fpo
3009: , (SELECT -3 plan_version_id FROM DUAL
3010: UNION ALL
3011: SELECT -4 plan_version_id FROM DUAL

Line 3074: , pa_budget_versions bv

3070: pji_pa_proj_events_log ev
3071: , pji_pjp_wbs_header hd1 -- sup
3072: , pji_xbs_denorm den
3073: , pji_pjp_wbs_header hd2 -- sub
3074: , pa_budget_versions bv
3075: , pa_proj_fp_options fpo
3076: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */
3077: AND bv.version_type IS NOT NULL
3078: AND bv.fin_plan_type_id IS NOT NULL

Line 3146: , pa_budget_versions bv

3142: PJI_PA_PROJ_EVENTS_LOG ev
3143: , pji_pjp_wbs_header hd1 -- sup
3144: , pji_xbs_denorm den
3145: , pji_pjp_wbs_header hd2 -- sub
3146: , pa_budget_versions bv
3147: , pa_proj_fp_options fpo
3148: , (SELECT -3 plan_version_id FROM DUAL
3149: UNION ALL
3150: SELECT -4 plan_version_id FROM DUAL

Line 3231: , pa_budget_versions bv

3227: || fpo.cost_time_phased_code
3228: || fpo.revenue_time_phased_code
3229: , 'G') tptc
3230: FROM pji_pjp_proj_batch_map map
3231: , pa_budget_versions bv
3232: , pa_rbs_prj_assignments rpa
3233: , pa_proj_fp_options fpo
3234: WHERE 1=1
3235: AND fpo.project_id (+)= rpa.project_id

Line 3349: , pa_budget_versions bv -- @pjdev115 bv

3345: , 'N'
3346: ) lp_flag
3347: FROM
3348: pji_pjp_proj_batch_map map -- CHANGE_01 Sridhar Carlson 6919766 changed order of the tables
3349: , pa_budget_versions bv -- @pjdev115 bv
3350: , pa_projects_all ppa -- @pjdev115 ppa
3351: , pa_proj_fp_options fpo -- @pjdev115 fpo
3352: , PA_RBS_PRJ_ASSIGNMENTS rpa
3353: WHERE ppa.project_id = bv.project_id

Line 3406: , pa_budget_versions bv -- @pjdev115 bv

3402: , 'N'
3403: ) lp_flag
3404: FROM
3405: pji_pjp_proj_batch_map map
3406: , pa_budget_versions bv -- @pjdev115 bv
3407: , pa_proj_fp_options fpo -- @pjdev115 fpo
3408: -- , pa_projects_all ppa -- @pjdev115 ppa
3409: , PA_RBS_PRJ_ASSIGNMENTS rpa
3410: , ( SELECT -3 plan_version_id FROM dual

Line 3467: , pa_budget_versions bv -- @pjdev115 bv

3463: ) lp_flag
3464: FROM
3465: pji_pa_proj_events_log ev
3466: , PA_RBS_PRJ_ASSIGNMENTS rpa
3467: , pa_budget_versions bv -- @pjdev115 bv
3468: , pa_proj_fp_options fpo -- @pjdev115 fpo
3469: , pa_projects_all ppa -- @pjdev115 ppa
3470: , pji_pjp_proj_batch_map map
3471: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */

Line 3530: , pa_budget_versions bv

3526: , 'N'
3527: ) lp_flag
3528: FROM
3529: PJI_PA_PROJ_EVENTS_LOG ev
3530: , pa_budget_versions bv
3531: , pa_proj_fp_options fpo
3532: , (SELECT -3 plan_version_id FROM DUAL
3533: UNION ALL
3534: SELECT -4 plan_version_id FROM DUAL

Line 3597: , pa_budget_versions bv

3593: pji_pa_proj_events_log ev
3594: , pji_pjp_wbs_header hd1 -- sup
3595: , pji_xbs_denorm den
3596: , pji_pjp_wbs_header hd2 -- sub
3597: , pa_budget_versions bv
3598: , pa_proj_fp_options fpo
3599: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */
3600: AND bv.version_type IS NOT NULL
3601: AND bv.fin_plan_type_id IS NOT NULL

Line 3669: , pa_budget_versions bv

3665: PJI_PA_PROJ_EVENTS_LOG ev
3666: , pji_pjp_wbs_header hd1 -- sup
3667: , pji_xbs_denorm den
3668: , pji_pjp_wbs_header hd2 -- sub
3669: , pa_budget_versions bv
3670: , pa_proj_fp_options fpo
3671: , (SELECT -3 plan_version_id FROM DUAL
3672: UNION ALL
3673: SELECT -4 plan_version_id FROM DUAL

Line 3754: , pa_budget_versions bv

3750: || fpo.cost_time_phased_code
3751: || fpo.revenue_time_phased_code
3752: , 'G') tptc
3753: FROM pji_pjp_proj_batch_map map
3754: , pa_budget_versions bv
3755: , pa_rbs_prj_assignments rpa
3756: , pa_proj_fp_options fpo
3757: WHERE 1=1
3758: AND fpo.project_id (+)= rpa.project_id

Line 4035: pa_budget_versions bv -- @pjdev115 bv

4031: , 'N')
4032: , 'N'
4033: ) lp_flag
4034: FROM
4035: pa_budget_versions bv -- @pjdev115 bv
4036: , pa_proj_fp_options fpo -- @pjdev115 fpo
4037: , pa_projects_all ppa -- @pjdev115 ppa
4038: WHERE 1=1
4039: AND ppa.project_id = bv.project_id

Line 4114: pa_budget_versions bv -- @pjdev115 bv

4110: , 'N')
4111: , 'N'
4112: ) lp_flag
4113: FROM
4114: pa_budget_versions bv -- @pjdev115 bv
4115: , pa_proj_fp_options fpo -- @pjdev115 fpo
4116: , pa_projects_all ppa -- @pjdev115 ppa
4117: WHERE 1=1
4118: AND ppa.project_id = bv.project_id

Line 4195: pa_budget_versions bv -- @pjdev115 bv

4191: , 'N')
4192: , 'N'
4193: ) lp_flag
4194: FROM
4195: pa_budget_versions bv -- @pjdev115 bv
4196: , pa_proj_fp_options fpo -- @pjdev115 fpo
4197: , pa_projects_all ppa -- @pjdev115 ppa
4198: , PA_RBS_PRJ_ASSIGNMENTS rpa
4199: WHERE 1=1

Line 5926: , pa_budget_versions bv -- @pjdev115 bv

5922: , g_default_prg_level
5923: , rl.PLAN_TYPE_CODE
5924: FROM
5925: pji_fp_xbs_accum_f rl
5926: , pa_budget_versions bv -- @pjdev115 bv
5927: , pa_proj_fp_options fpo -- @pjdev115 fpo
5928: WHERE
5929: rl.project_id = bv.project_id
5930: AND bv.version_type IS NOT NULL

Line 6006: , pa_budget_versions bv

6002: , bv.original_flag original_flag
6003: , bv.current_original_flag current_original_flag
6004: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
6005: FROM PJI_FM_EXTR_PLAN_LINES epl
6006: , pa_budget_versions bv
6007: , pa_proj_fp_options fpo
6008: WHERE
6009: epl.plan_version_id = bv.budget_version_id
6010: AND fpo.project_id = bv.project_id

Line 7723: UPDATE pa_budget_versions bv

7719:
7720: PROCEDURE MARK_DANGLING_PLAN_VERSIONS IS
7721: BEGIN
7722:
7723: UPDATE pa_budget_versions bv
7724: SET pji_summarized_flag = 'P',
7725: record_version_number = nvl(record_version_number,0)+1
7726: WHERE budget_version_id IN (
7727: SELECT plan_version_id

Line 7741: UPDATE pa_budget_versions bv

7737: ) b
7738: WHERE dangling > 2
7739: );
7740:
7741: UPDATE pa_budget_versions bv
7742: SET pji_summarized_flag = 'Y',
7743: record_version_number = nvl(record_version_number,0)+1
7744: WHERE budget_version_id IN (
7745: SELECT plan_version_id

Line 8633: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:

8629:
8630: -- Added for bug 9108728
8631: l_up_process_flag := PJI_UTILS.GET_SETUP_PARAMETER('UP_PROCESS_FLAG');
8632: --
8633: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:
8634: -- 'N' the plan version has not been summarized
8635: -- 'P' the plan version has been partially summarized due to dangling currency or calendar records
8636: -- 'Y' the plan version has been fully summarized in Project Performance and
8637: -- NULL the plan version has been fully summarized in both PJI and Project Performance.

Line 8641: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process

8637: -- NULL the plan version has been fully summarized in both PJI and Project Performance.
8638: --
8639: -- Note that, in PJI data extraction, data that existed before PJI was installed
8640: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
8641: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
8642: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
8643: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
8644: --
8645:

Line 8642: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'

8638: --
8639: -- Note that, in PJI data extraction, data that existed before PJI was installed
8640: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
8641: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
8642: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
8643: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
8644: --
8645:
8646: IF (p_slice_type = 'PRI') THEN

Line 8650: UPDATE /+ index(bv,pa_budget_versions_u1) /

8646: IF (p_slice_type = 'PRI') THEN
8647: -- Added for bug 9108728
8648: if l_up_process_flag = 'Y' then
8649:
8650: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8651: pa_budget_versions bv
8652: SET pji_summarized_flag = 'P',
8653: record_version_number=nvl(record_version_number,0)+1
8654: WHERE budget_version_id IN

Line 8651: pa_budget_versions bv

8647: -- Added for bug 9108728
8648: if l_up_process_flag = 'Y' then
8649:
8650: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8651: pa_budget_versions bv
8652: SET pji_summarized_flag = 'P',
8653: record_version_number=nvl(record_version_number,0)+1
8654: WHERE budget_version_id IN
8655: ( SELECT DISTINCT plan_version_id

Line 8661: UPDATE /+ index(bv,pa_budget_versions_u1) /

8657: WHERE worker_id = g_worker_id )
8658: AND (bv.current_flag = 'Y' or bv.current_original_flag = 'Y')
8659: AND nvl(bv.wp_version_flag,'Y') = 'N';
8660:
8661: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8662: pa_budget_versions bv
8663: SET pji_summarized_flag = 'Y',
8664: record_version_number=nvl(record_version_number,0)+1
8665: WHERE budget_version_id IN

Line 8662: pa_budget_versions bv

8658: AND (bv.current_flag = 'Y' or bv.current_original_flag = 'Y')
8659: AND nvl(bv.wp_version_flag,'Y') = 'N';
8660:
8661: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8662: pa_budget_versions bv
8663: SET pji_summarized_flag = 'Y',
8664: record_version_number=nvl(record_version_number,0)+1
8665: WHERE budget_version_id IN
8666: ( SELECT DISTINCT plan_version_id

Line 8675: UPDATE /+ index(bv,pa_budget_versions_u1) /

8671:
8672: else
8673: -- Added for bug 9108728 ends
8674:
8675: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8676: pa_budget_versions bv
8677: SET pji_summarized_flag =
8678: DECODE(wp_version_flag
8679: , 'Y', 'Y'

Line 8676: pa_budget_versions bv

8672: else
8673: -- Added for bug 9108728 ends
8674:
8675: UPDATE /*+ index(bv,pa_budget_versions_u1) */
8676: pa_budget_versions bv
8677: SET pji_summarized_flag =
8678: DECODE(wp_version_flag
8679: , 'Y', 'Y'
8680: , DECODE(budget_status_code

Line 8708: UPDATE /+ index( bv , pa_budget_versions_u1 ) /

8704: OR pjp1.rate_dangling_flag IS NOT NULL )
8705: );
8706: /* Added for bug 13897252 ends */
8707:
8708: UPDATE /*+ index( bv , pa_budget_versions_u1 ) */
8709: pa_budget_versions bv
8710: SET pji_summarized_flag = 'Y',
8711: record_version_number=nvl(record_version_number,0)+1
8712: WHERE budget_version_id IN (SELECT plan_version_id

Line 8709: pa_budget_versions bv

8705: );
8706: /* Added for bug 13897252 ends */
8707:
8708: UPDATE /*+ index( bv , pa_budget_versions_u1 ) */
8709: pa_budget_versions bv
8710: SET pji_summarized_flag = 'Y',
8711: record_version_number=nvl(record_version_number,0)+1
8712: WHERE budget_version_id IN (SELECT plan_version_id
8713: FROM PJI_FM_EXTR_PLNVER4 ver3

Line 8717: UPDATE /+ index( bv , pa_budget_versions_u1 ) /

8713: FROM PJI_FM_EXTR_PLNVER4 ver3
8714: WHERE ver3.worker_id=g_worker_id
8715: AND ver3.time_dangling_flag IS NULL);
8716:
8717: UPDATE /*+ index( bv , pa_budget_versions_u1 ) */
8718: pa_budget_versions bv
8719: SET pji_summarized_flag = 'P',
8720: record_version_number=nvl(record_version_number,0)+1
8721: WHERE budget_version_id IN (SELECT plan_version_id

Line 8718: pa_budget_versions bv

8714: WHERE ver3.worker_id=g_worker_id
8715: AND ver3.time_dangling_flag IS NULL);
8716:
8717: UPDATE /*+ index( bv , pa_budget_versions_u1 ) */
8718: pa_budget_versions bv
8719: SET pji_summarized_flag = 'P',
8720: record_version_number=nvl(record_version_number,0)+1
8721: WHERE budget_version_id IN (SELECT plan_version_id
8722: FROM PJI_FM_EXTR_PLNVER4 ver3