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 DUAL

Line 466: SELECT -3 pvi FROM dual UNION ALL

462: PA_RBS_PRJ_ASSIGNMENTS rpa,
463: PA_PROJECTS_ALL ppa,
464: PA_RBS_VERSIONS_B rvb,
465: (
466: SELECT -3 pvi FROM dual UNION ALL
467: SELECT -4 pvi FROM dual
468: ) pln_ver
469: WHERE 1=1
470: AND ppa.project_id = bv.project_id

Line 467: SELECT -4 pvi FROM dual

463: PA_PROJECTS_ALL ppa,
464: PA_RBS_VERSIONS_B rvb,
465: (
466: SELECT -3 pvi FROM dual UNION ALL
467: SELECT -4 pvi FROM dual
468: ) pln_ver
469: WHERE 1=1
470: AND ppa.project_id = bv.project_id
471: AND bv.version_type IS NOT NULL -- COST, REVENUE, etc. Should not be null.

Line 617: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual

613: (
614: Select decode(
615: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
616: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
617: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
618: UNION ALL
619: Select decode(
620: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
621: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

Line 621: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

617: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
618: UNION ALL
619: Select decode(
620: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
621: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
622: )
623: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
624: (
625: bv.BUDGET_STATUS_CODE in ('W','S') and

Line 707: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual

703: (
704: Select decode(
705: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
706: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
707: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
708: UNION ALL
709: Select decode(
710: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
711: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

Line 711: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

707: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
708: UNION ALL
709: Select decode(
710: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
711: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
712: )
713: )
714: ) ;
715:

Line 832: into l_actual_ver,l_cb_ver,l_co_ver from dual;

828: IF p_context = 'PLANTYPE' then
829: select decode(l_plan_type_id,NULL,decode(bitand (l_refresh_code,1),1,-1,-999),-999),
830: decode (bitand (l_refresh_code,2),2,-3,-999) ,
831: decode (bitand (l_refresh_code,4),4,-4,-999)
832: into l_actual_ver,l_cb_ver,l_co_ver from dual;
833: ELSE
834: l_actual_ver := -1;
835: l_cb_ver := -3;
836: l_co_ver := -4;

Line 1753: from dual

1749: begin
1750:
1751: select 'Y'
1752: into l_RBS_ASSOC_exists
1753: from dual
1754: where exists
1755: ( select 'x'
1756: from pji_pa_proj_events_log
1757: where worker_id = g_worker_id

Line 1774: from dual

1770: begin
1771:
1772: select 'Y'
1773: into l_RBS_PRG_exists
1774: from dual
1775: where exists
1776: ( select 'x'
1777: from pji_pa_proj_events_log
1778: where worker_id = g_worker_id

Line 1794: from dual

1790: begin
1791:
1792: select 'Y'
1793: into l_PRG_CHANGE_exists
1794: from dual
1795: where exists
1796: ( select 'x'
1797: from pji_pa_proj_events_log
1798: where worker_id = g_worker_id

Line 1825: from dual

1821: --#bug 5356051
1822: begin
1823: select 'Y'
1824: into l_prg_exists
1825: from dual
1826: where exists (
1827: select null
1828: from
1829: pa_proj_element_versions proj

Line 2135: , ( SELECT -3 plan_version_id FROM dual

2131: , 'Y' lp_flag
2132: FROM
2133: pji_fm_extr_plnver4 hd2 -- sub
2134: , pji_xbs_denorm den
2135: , ( SELECT -3 plan_version_id FROM dual
2136: UNION ALL
2137: SELECT -4 plan_version_id FROM dual ) cbco
2138: WHERE
2139: hd2.baselined_flag = 'Y'

Line 2137: SELECT -4 plan_version_id FROM dual ) cbco

2133: pji_fm_extr_plnver4 hd2 -- sub
2134: , pji_xbs_denorm den
2135: , ( SELECT -3 plan_version_id FROM dual
2136: UNION ALL
2137: SELECT -4 plan_version_id FROM dual ) cbco
2138: WHERE
2139: hd2.baselined_flag = 'Y'
2140: AND hd2.wp_flag = 'N'
2141: AND hd2.worker_id = g_worker_id

Line 2191: , ( SELECT -3 plan_version_id FROM dual

2187: , 'Y' SECONDARY_RBS_FLAG
2188: , 'Y' lp_flag
2189: FROM
2190: pji_fm_extr_plnver4 hd2 -- sub
2191: , ( SELECT -3 plan_version_id FROM dual
2192: UNION ALL
2193: SELECT -4 plan_version_id FROM dual ) cbco
2194: WHERE
2195: hd2.baselined_flag = 'Y'

Line 2193: SELECT -4 plan_version_id FROM dual ) cbco

2189: FROM
2190: pji_fm_extr_plnver4 hd2 -- sub
2191: , ( SELECT -3 plan_version_id FROM dual
2192: UNION ALL
2193: SELECT -4 plan_version_id FROM dual ) cbco
2194: WHERE
2195: hd2.baselined_flag = 'Y'
2196: AND hd2.wp_flag = 'N'
2197: AND hd2.worker_id = g_worker_id;

Line 2536: , ( SELECT -3 plan_version_id FROM dual

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
2539: WHERE 1=1
2540: AND bv.project_id = map.project_id

Line 2538: SELECT -4 plan_version_id FROM dual ) cbco

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
2539: WHERE 1=1
2540: AND bv.project_id = map.project_id
2541: AND map.worker_id = g_worker_id
2542: AND bv.version_type IS NOT NULL -- COST, REVENUE, etc. Should not be null.

Line 2670: , ( SELECT -3 plan_version_id FROM dual

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
2673: WHERE 1=1
2674: AND bv.project_id = map.project_id

Line 2672: SELECT -4 plan_version_id FROM dual ) cbco

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
2673: WHERE 1=1
2674: AND bv.project_id = map.project_id
2675: AND map.worker_id = g_worker_id
2676: AND bv.version_type IS NOT NULL -- COST, REVENUE, etc. Should not be null.

Line 2887: , ( SELECT -3 plan_version_id FROM dual

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
2888: UNION ALL
2889: SELECT -4 plan_version_id FROM dual ) cbco
2890: WHERE map.project_id = bv.project_id
2891: AND bv.version_type IS NOT NULL

Line 2889: SELECT -4 plan_version_id FROM dual ) cbco

2885: -- , pa_projects_all ppa -- @pjdev115 ppa
2886: , PA_RBS_PRJ_ASSIGNMENTS rpa
2887: , ( SELECT -3 plan_version_id FROM dual
2888: UNION ALL
2889: SELECT -4 plan_version_id FROM dual ) cbco
2890: WHERE map.project_id = bv.project_id
2891: AND bv.version_type IS NOT NULL
2892: AND bv.fin_plan_type_id IS NOT NULL
2893: AND fpo.project_id = bv.project_id

Line 3009: , (SELECT -3 plan_version_id FROM DUAL

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
3012: ) cbcov
3013: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */ /*1=1*/

Line 3011: SELECT -4 plan_version_id FROM DUAL

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
3012: ) cbcov
3013: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */ /*1=1*/
3014: AND bv.version_type IS NOT NULL
3015: AND bv.fin_plan_type_id IS NOT NULL

Line 3148: , (SELECT -3 plan_version_id FROM DUAL

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
3151: ) cbcov
3152: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */

Line 3150: SELECT -4 plan_version_id FROM DUAL

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
3151: ) cbcov
3152: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */
3153: AND bv.version_type IS NOT NULL
3154: AND bv.fin_plan_type_id IS NOT NULL

Line 3246: , ( SELECT -3 plan_version_id FROM dual

3242: ) fpo
3243: , pji_pjp_proj_batch_map map
3244: , pji_pjp_wbs_header whsub
3245: , pa_xbs_denorm den
3246: , ( SELECT -3 plan_version_id FROM dual
3247: UNION ALL
3248: SELECT -4 plan_version_id FROM dual ) cbco
3249: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */
3250: AND map.worker_id = g_worker_id

Line 3248: SELECT -4 plan_version_id FROM dual ) cbco

3244: , pji_pjp_wbs_header whsub
3245: , pa_xbs_denorm den
3246: , ( SELECT -3 plan_version_id FROM dual
3247: UNION ALL
3248: SELECT -4 plan_version_id FROM dual ) cbco
3249: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */
3250: AND map.worker_id = g_worker_id
3251: AND fpo.rpi = map.project_id
3252: AND NVL(fpolc, 'PLAN_VERSION') = 'PLAN_VERSION'

Line 3410: , ( SELECT -3 plan_version_id FROM dual

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
3411: UNION ALL
3412: SELECT -4 plan_version_id FROM dual ) cbco
3413: WHERE map.project_id = bv.project_id
3414: AND bv.version_type IS NOT NULL

Line 3412: SELECT -4 plan_version_id FROM dual ) cbco

3408: -- , pa_projects_all ppa -- @pjdev115 ppa
3409: , PA_RBS_PRJ_ASSIGNMENTS rpa
3410: , ( SELECT -3 plan_version_id FROM dual
3411: UNION ALL
3412: SELECT -4 plan_version_id FROM dual ) cbco
3413: WHERE map.project_id = bv.project_id
3414: AND bv.version_type IS NOT NULL
3415: AND bv.fin_plan_type_id IS NOT NULL
3416: AND fpo.project_id = bv.project_id

Line 3532: , (SELECT -3 plan_version_id FROM DUAL

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
3535: ) cbcov
3536: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */ /*1=1*/

Line 3534: SELECT -4 plan_version_id FROM DUAL

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
3535: ) cbcov
3536: WHERE l_RBS_ASSOC_exists = 'Y' /* Added for bug 8708651 */ /*1=1*/
3537: AND bv.version_type IS NOT NULL
3538: AND bv.fin_plan_type_id IS NOT NULL

Line 3671: , (SELECT -3 plan_version_id FROM DUAL

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
3674: ) cbcov
3675: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */

Line 3673: SELECT -4 plan_version_id FROM DUAL

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
3674: ) cbcov
3675: WHERE l_RBS_PRG_exists = 'Y' /* Added for bug 8708651 */
3676: AND bv.version_type IS NOT NULL
3677: AND bv.fin_plan_type_id IS NOT NULL

Line 3769: , ( SELECT -3 plan_version_id FROM dual

3765: ) fpo
3766: , pji_pjp_proj_batch_map map
3767: , pji_pjp_wbs_header whsub
3768: , pa_xbs_denorm den
3769: , ( SELECT -3 plan_version_id FROM dual
3770: UNION ALL
3771: SELECT -4 plan_version_id FROM dual ) cbco
3772: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */
3773: AND map.worker_id = g_worker_id

Line 3771: SELECT -4 plan_version_id FROM dual ) cbco

3767: , pji_pjp_wbs_header whsub
3768: , pa_xbs_denorm den
3769: , ( SELECT -3 plan_version_id FROM dual
3770: UNION ALL
3771: SELECT -4 plan_version_id FROM dual ) cbco
3772: WHERE l_PRG_CHANGE_exists = 'Y' /* Added for bug 8708651 */
3773: AND map.worker_id = g_worker_id
3774: AND fpo.rpi = map.project_id
3775: AND NVL(fpolc, 'PLAN_VERSION') = 'PLAN_VERSION'

Line 3841: , ( SELECT -3 plan_version_id FROM dual

3837: , 'Y' lp_flag
3838: FROM
3839: pji_fm_extr_plnver4 hd2 -- sub
3840: , pji_xbs_denorm den
3841: , ( SELECT -3 plan_version_id FROM dual
3842: UNION ALL
3843: SELECT -4 plan_version_id FROM dual ) cbco
3844: WHERE hd2.baselined_flag = 'Y'
3845: AND hd2.wp_flag = 'N'

Line 3843: SELECT -4 plan_version_id FROM dual ) cbco

3839: pji_fm_extr_plnver4 hd2 -- sub
3840: , pji_xbs_denorm den
3841: , ( SELECT -3 plan_version_id FROM dual
3842: UNION ALL
3843: SELECT -4 plan_version_id FROM dual ) cbco
3844: WHERE hd2.baselined_flag = 'Y'
3845: AND hd2.wp_flag = 'N'
3846: AND hd2.plan_version_id > 0
3847: AND hd2.worker_id = g_worker_id

Line 3911: , ( SELECT -3 plan_version_id FROM dual

3907: , 'Y' SECONDARY_RBS_FLAG
3908: , 'Y' lp_flag
3909: FROM
3910: pji_fm_extr_plnver4 hd2 -- sub
3911: , ( SELECT -3 plan_version_id FROM dual
3912: UNION ALL
3913: SELECT -4 plan_version_id FROM dual ) cbco
3914: WHERE hd2.baselined_flag = 'Y'
3915: AND hd2.wp_flag = 'N'

Line 3913: SELECT -4 plan_version_id FROM dual ) cbco

3909: FROM
3910: pji_fm_extr_plnver4 hd2 -- sub
3911: , ( SELECT -3 plan_version_id FROM dual
3912: UNION ALL
3913: SELECT -4 plan_version_id FROM dual ) cbco
3914: WHERE hd2.baselined_flag = 'Y'
3915: AND hd2.wp_flag = 'N'
3916: AND hd2.plan_version_id > 0
3917: AND hd2.worker_id = g_worker_id

Line 4684: select 4 INVERT_ID from dual union all

4680: ) spread_bl
4681: ---- end of third inline view 'spread_bl'...........
4682: ,
4683: (
4684: select 4 INVERT_ID from dual union all
4685: select 8 INVERT_ID from dual union all
4686: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4687: ) invert
4688: ) collapse_bl

Line 4685: select 8 INVERT_ID from dual union all

4681: ---- end of third inline view 'spread_bl'...........
4682: ,
4683: (
4684: select 4 INVERT_ID from dual union all
4685: select 8 INVERT_ID from dual union all
4686: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4687: ) invert
4688: ) collapse_bl
4689: ---- End of second inline view 'collapse_bl' ..........

Line 4686: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

4682: ,
4683: (
4684: select 4 INVERT_ID from dual union all
4685: select 8 INVERT_ID from dual union all
4686: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4687: ) invert
4688: ) collapse_bl
4689: ---- End of second inline view 'collapse_bl' ..........
4690: GROUP BY

Line 5362: SELECT 4 INVERT_ID FROM dual UNION ALL

5358: ) spread_bl
5359: ---- end of third inline view 'spread_bl'...........
5360: ,
5361: (
5362: SELECT 4 INVERT_ID FROM dual UNION ALL
5363: SELECT 8 INVERT_ID FROM dual UNION ALL
5364: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
5365: ) invert
5366: ) collapse_bl

Line 5363: SELECT 8 INVERT_ID FROM dual UNION ALL

5359: ---- end of third inline view 'spread_bl'...........
5360: ,
5361: (
5362: SELECT 4 INVERT_ID FROM dual UNION ALL
5363: SELECT 8 INVERT_ID FROM dual UNION ALL
5364: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
5365: ) invert
5366: ) collapse_bl
5367: ---- End of second inline view 'collapse_bl' ..........

Line 5364: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

5360: ,
5361: (
5362: SELECT 4 INVERT_ID FROM dual UNION ALL
5363: SELECT 8 INVERT_ID FROM dual UNION ALL
5364: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
5365: ) invert
5366: ) collapse_bl
5367: ---- End of second inline view 'collapse_bl' ..........
5368: GROUP BY

Line 9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

9959: ) spread_bl
9960: ---- end of third inline view 'spread_bl'...........
9961: ,
9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

9960: ---- end of third inline view 'spread_bl'...........
9961: ,
9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert

Line 9965: select 4 INVERT_ID from dual union all

9961: ,
9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert
9969: ) collapse_bl

Line 9966: select 8 INVERT_ID from dual union all

9962: (
9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert
9969: ) collapse_bl
9970: ---- End of second inline view 'collapse_bl' ..........

Line 9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

9963: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
9964: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9965: select 4 INVERT_ID from dual union all
9966: select 8 INVERT_ID from dual union all
9967: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9968: ) invert
9969: ) collapse_bl
9970: ---- End of second inline view 'collapse_bl' ..........
9971: GROUP BY

Line 11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */

11119: ) spread_bl
11120: ---- end of third inline view 'spread_bl'...........
11121: ,
11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

Line 11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all

11120: ---- end of third inline view 'spread_bl'...........
11121: ,
11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert

Line 11125: select 4 INVERT_ID from dual union all

11121: ,
11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert
11129: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909

Line 11126: select 8 INVERT_ID from dual union all

11122: (
11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert
11129: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
11130: ---- End of second inline view 'collapse_bl' ..........

Line 11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

11123: select 1 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR1_FLAG') = 'Y' union all /* Added for bug 8708651 */
11124: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
11125: select 4 INVERT_ID from dual union all
11126: select 8 INVERT_ID from dual union all
11127: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11128: ) invert
11129: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
11130: ---- End of second inline view 'collapse_bl' ..........
11131: GROUP BY

Line 11807: SELECT 4 INVERT_ID FROM dual UNION ALL

11803: ) spread_bl
11804: ---- end of third inline view 'spread_bl'...........
11805: ,
11806: (
11807: SELECT 4 INVERT_ID FROM dual UNION ALL
11808: SELECT 8 INVERT_ID FROM dual UNION ALL
11809: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11810: ) invert
11811: ) collapse_bl

Line 11808: SELECT 8 INVERT_ID FROM dual UNION ALL

11804: ---- end of third inline view 'spread_bl'...........
11805: ,
11806: (
11807: SELECT 4 INVERT_ID FROM dual UNION ALL
11808: SELECT 8 INVERT_ID FROM dual UNION ALL
11809: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11810: ) invert
11811: ) collapse_bl
11812: ---- End of second inline view 'collapse_bl' ..........

Line 11809: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

11805: ,
11806: (
11807: SELECT 4 INVERT_ID FROM dual UNION ALL
11808: SELECT 8 INVERT_ID FROM dual UNION ALL
11809: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11810: ) invert
11811: ) collapse_bl
11812: ---- End of second inline view 'collapse_bl' ..........
11813: GROUP BY

Line 11944: FROM DUAL;

11940: , l_last_update_date last_update_date
11941: , l_last_updated_by last_updated_by
11942: , l_created_by created_by
11943: , l_last_update_login last_update_login
11944: FROM DUAL;
11945:
11946: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
11947:
11948: EXCEPTION

Line 12406: SELECT 4 INVERT_ID FROM dual UNION ALL

12402: ) spread_bl
12403: ---- end of third inline view 'spread_bl'...........
12404: ,
12405: (
12406: SELECT 4 INVERT_ID FROM dual UNION ALL
12407: SELECT 8 INVERT_ID FROM dual UNION ALL
12408: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
12409: ) invert
12410: ) collapse_bl

Line 12407: SELECT 8 INVERT_ID FROM dual UNION ALL

12403: ---- end of third inline view 'spread_bl'...........
12404: ,
12405: (
12406: SELECT 4 INVERT_ID FROM dual UNION ALL
12407: SELECT 8 INVERT_ID FROM dual UNION ALL
12408: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
12409: ) invert
12410: ) collapse_bl
12411: ---- End of second inline view 'collapse_bl' ..........

Line 12408: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

12404: ,
12405: (
12406: SELECT 4 INVERT_ID FROM dual UNION ALL
12407: SELECT 8 INVERT_ID FROM dual UNION ALL
12408: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
12409: ) invert
12410: ) collapse_bl
12411: ---- End of second inline view 'collapse_bl' ..........
12412: GROUP BY

Line 12663: from dual

12659:
12660: /* Added for bug 7551819 */
12661: begin
12662: select 'Y' into l_from_launch
12663: from dual
12664: where PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'FROM_PROJECT')
12665: like 'UPP-BATCH-%';
12666: exception
12667: when others then