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 369: SELECT -3 pvi FROM dual UNION ALL

365: PA_RBS_PRJ_ASSIGNMENTS rpa,
366: PA_PROJECTS_ALL ppa,
367: PA_RBS_VERSIONS_B rvb,
368: (
369: SELECT -3 pvi FROM dual UNION ALL
370: SELECT -4 pvi FROM dual
371: ) pln_ver
372: WHERE 1=1
373: AND ppa.project_id = bv.project_id

Line 370: SELECT -4 pvi FROM dual

366: PA_PROJECTS_ALL ppa,
367: PA_RBS_VERSIONS_B rvb,
368: (
369: SELECT -3 pvi FROM dual UNION ALL
370: SELECT -4 pvi FROM dual
371: ) pln_ver
372: WHERE 1=1
373: AND ppa.project_id = bv.project_id
374: AND bv.version_type IS NOT NULL -- COST, REVENUE, etc. Should not be null.

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

516: (
517: Select decode(
518: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
519: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
520: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
521: UNION ALL
522: Select decode(
523: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
524: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

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

520: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
521: UNION ALL
522: Select decode(
523: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
524: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual
525: )
526: OR -- Bug#5099574 Pull Reversals for Fin plan Working Versions when l_refresh_code=16,30. ignore if l_refresh_code>=62
527: (
528: bv.BUDGET_STATUS_CODE in ('W','S') and

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

606: (
607: Select decode(
608: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
609: decode( bitand(l_refresh_code,g_cb_plans),g_cb_plans,
610: decode(decode(bv.baselined_date, NULL, 'N', 'Y')||bv.current_flag,'YY', 'Y', 'N'),'X')) from dual
611: UNION ALL
612: Select decode(
613: bitand(l_refresh_code,g_all_plans),g_all_plans,'Y',
614: decode( bitand(l_refresh_code,g_co_plans),g_co_plans,bv.current_original_flag,'X')) from dual

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

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

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

731: IF p_context = 'PLANTYPE' then
732: select decode(l_plan_type_id,NULL,decode(bitand (l_refresh_code,1),1,-1,-999),-999),
733: decode (bitand (l_refresh_code,2),2,-3,-999) ,
734: decode (bitand (l_refresh_code,4),4,-4,-999)
735: into l_actual_ver,l_cb_ver,l_co_ver from dual;
736: ELSE
737: l_actual_ver := -1;
738: l_cb_ver := -3;
739: l_co_ver := -4;

Line 1652: from dual

1648: --#bug 5356051
1649: begin
1650: select 'Y'
1651: into l_prg_exists
1652: from dual
1653: where exists (
1654: select null
1655: from
1656: pa_proj_element_versions proj

Line 1787: , ( SELECT -3 plan_version_id FROM dual

1783: , 'Y' lp_flag
1784: FROM
1785: pji_fm_extr_plnver4 hd2 -- sub
1786: , pji_xbs_denorm den
1787: , ( SELECT -3 plan_version_id FROM dual
1788: UNION ALL
1789: SELECT -4 plan_version_id FROM dual ) cbco
1790: WHERE
1791: hd2.baselined_flag = 'Y'

Line 1789: SELECT -4 plan_version_id FROM dual ) cbco

1785: pji_fm_extr_plnver4 hd2 -- sub
1786: , pji_xbs_denorm den
1787: , ( SELECT -3 plan_version_id FROM dual
1788: UNION ALL
1789: SELECT -4 plan_version_id FROM dual ) cbco
1790: WHERE
1791: hd2.baselined_flag = 'Y'
1792: AND hd2.wp_flag = 'N'
1793: AND hd2.worker_id = g_worker_id

Line 1843: , ( SELECT -3 plan_version_id FROM dual

1839: , 'Y' SECONDARY_RBS_FLAG
1840: , 'Y' lp_flag
1841: FROM
1842: pji_fm_extr_plnver4 hd2 -- sub
1843: , ( SELECT -3 plan_version_id FROM dual
1844: UNION ALL
1845: SELECT -4 plan_version_id FROM dual ) cbco
1846: WHERE
1847: hd2.baselined_flag = 'Y'

Line 1845: SELECT -4 plan_version_id FROM dual ) cbco

1841: FROM
1842: pji_fm_extr_plnver4 hd2 -- sub
1843: , ( SELECT -3 plan_version_id FROM dual
1844: UNION ALL
1845: SELECT -4 plan_version_id FROM dual ) cbco
1846: WHERE
1847: hd2.baselined_flag = 'Y'
1848: AND hd2.wp_flag = 'N'
1849: AND hd2.worker_id = g_worker_id;

Line 2133: , ( SELECT -3 plan_version_id FROM dual

2129: FROM
2130: pa_budget_versions bv
2131: , pa_proj_fp_options fpo
2132: , pji_pjp_proj_batch_map map
2133: , ( SELECT -3 plan_version_id FROM dual
2134: UNION ALL
2135: SELECT -4 plan_version_id FROM dual ) cbco
2136: WHERE 1=1
2137: AND bv.project_id = map.project_id

Line 2135: SELECT -4 plan_version_id FROM dual ) cbco

2131: , pa_proj_fp_options fpo
2132: , pji_pjp_proj_batch_map map
2133: , ( SELECT -3 plan_version_id FROM dual
2134: UNION ALL
2135: SELECT -4 plan_version_id FROM dual ) cbco
2136: WHERE 1=1
2137: AND bv.project_id = map.project_id
2138: AND map.worker_id = g_worker_id
2139: AND bv.version_type IS NOT NULL -- COST, REVENUE, etc. Should not be null.

Line 2291: , ( SELECT -3 plan_version_id FROM dual

2287: , pa_proj_fp_options fpo -- @pjdev115 fpo
2288: -- , pa_projects_all ppa -- @pjdev115 ppa
2289: , PA_RBS_PRJ_ASSIGNMENTS rpa
2290: , pji_pjp_proj_batch_map map
2291: , ( SELECT -3 plan_version_id FROM dual
2292: UNION ALL
2293: SELECT -4 plan_version_id FROM dual ) cbco
2294: WHERE map.project_id = bv.project_id
2295: AND bv.version_type IS NOT NULL

Line 2293: SELECT -4 plan_version_id FROM dual ) cbco

2289: , PA_RBS_PRJ_ASSIGNMENTS rpa
2290: , pji_pjp_proj_batch_map map
2291: , ( SELECT -3 plan_version_id FROM dual
2292: UNION ALL
2293: SELECT -4 plan_version_id FROM dual ) cbco
2294: WHERE map.project_id = bv.project_id
2295: AND bv.version_type IS NOT NULL
2296: AND bv.fin_plan_type_id IS NOT NULL
2297: AND fpo.project_id = bv.project_id

Line 2415: , (SELECT -3 plan_version_id FROM DUAL

2411: FROM
2412: pa_budget_versions bv
2413: , pa_proj_fp_options fpo
2414: , PJI_PA_PROJ_EVENTS_LOG ev
2415: , (SELECT -3 plan_version_id FROM DUAL
2416: UNION ALL
2417: SELECT -4 plan_version_id FROM DUAL
2418: ) cbcov
2419: WHERE 1=1

Line 2417: SELECT -4 plan_version_id FROM DUAL

2413: , pa_proj_fp_options fpo
2414: , PJI_PA_PROJ_EVENTS_LOG ev
2415: , (SELECT -3 plan_version_id FROM DUAL
2416: UNION ALL
2417: SELECT -4 plan_version_id FROM DUAL
2418: ) cbcov
2419: WHERE 1=1
2420: AND bv.version_type IS NOT NULL
2421: AND bv.fin_plan_type_id IS NOT NULL

Line 2553: , (SELECT -3 plan_version_id FROM DUAL

2549: , PJI_PA_PROJ_EVENTS_LOG ev
2550: , pji_pjp_wbs_header hd1 -- sup
2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den
2553: , (SELECT -3 plan_version_id FROM DUAL
2554: UNION ALL
2555: SELECT -4 plan_version_id FROM DUAL
2556: ) cbcov
2557: WHERE bv.version_type IS NOT NULL

Line 2555: SELECT -4 plan_version_id FROM DUAL

2551: , pji_pjp_wbs_header hd2 -- sub
2552: , pji_xbs_denorm den
2553: , (SELECT -3 plan_version_id FROM DUAL
2554: UNION ALL
2555: SELECT -4 plan_version_id FROM DUAL
2556: ) cbcov
2557: WHERE bv.version_type IS NOT NULL
2558: AND bv.fin_plan_type_id IS NOT NULL
2559: AND fpo.project_id = bv.project_id

Line 2641: , ( SELECT -3 plan_version_id FROM dual

2637: ) fpo
2638: , pa_xbs_denorm den
2639: , pji_pjp_proj_batch_map map
2640: , pji_pjp_wbs_header whsub
2641: , ( SELECT -3 plan_version_id FROM dual
2642: UNION ALL
2643: SELECT -4 plan_version_id FROM dual ) cbco
2644: WHERE NVL(fpolc, 'PLAN_VERSION') = 'PLAN_VERSION'
2645: AND map.worker_id = g_worker_id

Line 2643: SELECT -4 plan_version_id FROM dual ) cbco

2639: , pji_pjp_proj_batch_map map
2640: , pji_pjp_wbs_header whsub
2641: , ( SELECT -3 plan_version_id FROM dual
2642: UNION ALL
2643: SELECT -4 plan_version_id FROM dual ) cbco
2644: WHERE NVL(fpolc, 'PLAN_VERSION') = 'PLAN_VERSION'
2645: AND map.worker_id = g_worker_id
2646: AND map.project_id = whsub.project_id
2647: AND whsub.wp_flag = 'N'

Line 2722: , ( SELECT -3 plan_version_id FROM dual

2718: , 'Y' lp_flag
2719: FROM
2720: pji_fm_extr_plnver4 hd2 -- sub
2721: , pji_xbs_denorm den
2722: , ( SELECT -3 plan_version_id FROM dual
2723: UNION ALL
2724: SELECT -4 plan_version_id FROM dual ) cbco
2725: WHERE hd2.baselined_flag = 'Y'
2726: AND hd2.wp_flag = 'N'

Line 2724: SELECT -4 plan_version_id FROM dual ) cbco

2720: pji_fm_extr_plnver4 hd2 -- sub
2721: , pji_xbs_denorm den
2722: , ( SELECT -3 plan_version_id FROM dual
2723: UNION ALL
2724: SELECT -4 plan_version_id FROM dual ) cbco
2725: WHERE hd2.baselined_flag = 'Y'
2726: AND hd2.wp_flag = 'N'
2727: AND hd2.plan_version_id > 0
2728: AND hd2.worker_id = g_worker_id

Line 2782: , ( SELECT -3 plan_version_id FROM dual

2778: , 'Y' SECONDARY_RBS_FLAG
2779: , 'Y' lp_flag
2780: FROM
2781: pji_fm_extr_plnver4 hd2 -- sub
2782: , ( SELECT -3 plan_version_id FROM dual
2783: UNION ALL
2784: SELECT -4 plan_version_id FROM dual ) cbco
2785: WHERE hd2.baselined_flag = 'Y'
2786: AND hd2.wp_flag = 'N'

Line 2784: SELECT -4 plan_version_id FROM dual ) cbco

2780: FROM
2781: pji_fm_extr_plnver4 hd2 -- sub
2782: , ( SELECT -3 plan_version_id FROM dual
2783: UNION ALL
2784: SELECT -4 plan_version_id FROM dual ) cbco
2785: WHERE hd2.baselined_flag = 'Y'
2786: AND hd2.wp_flag = 'N'
2787: AND hd2.plan_version_id > 0
2788: AND hd2.worker_id = g_worker_id

Line 3532: select 4 INVERT_ID from dual union all

3528: ) spread_bl
3529: ---- end of third inline view 'spread_bl'...........
3530: ,
3531: (
3532: select 4 INVERT_ID from dual union all
3533: select 8 INVERT_ID from dual union all
3534: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3535: ) invert
3536: ) collapse_bl

Line 3533: select 8 INVERT_ID from dual union all

3529: ---- end of third inline view 'spread_bl'...........
3530: ,
3531: (
3532: select 4 INVERT_ID from dual union all
3533: select 8 INVERT_ID from dual union all
3534: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3535: ) invert
3536: ) collapse_bl
3537: ---- End of second inline view 'collapse_bl' ..........

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

3530: ,
3531: (
3532: select 4 INVERT_ID from dual union all
3533: select 8 INVERT_ID from dual union all
3534: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
3535: ) invert
3536: ) collapse_bl
3537: ---- End of second inline view 'collapse_bl' ..........
3538: GROUP BY

Line 4191: SELECT 4 INVERT_ID FROM dual UNION ALL

4187: ) spread_bl
4188: ---- end of third inline view 'spread_bl'...........
4189: ,
4190: (
4191: SELECT 4 INVERT_ID FROM dual UNION ALL
4192: SELECT 8 INVERT_ID FROM dual UNION ALL
4193: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4194: ) invert
4195: ) collapse_bl

Line 4192: SELECT 8 INVERT_ID FROM dual UNION ALL

4188: ---- end of third inline view 'spread_bl'...........
4189: ,
4190: (
4191: SELECT 4 INVERT_ID FROM dual UNION ALL
4192: SELECT 8 INVERT_ID FROM dual UNION ALL
4193: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4194: ) invert
4195: ) collapse_bl
4196: ---- End of second inline view 'collapse_bl' ..........

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

4189: ,
4190: (
4191: SELECT 4 INVERT_ID FROM dual UNION ALL
4192: SELECT 8 INVERT_ID FROM dual UNION ALL
4193: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
4194: ) invert
4195: ) collapse_bl
4196: ---- End of second inline view 'collapse_bl' ..........
4197: GROUP BY

Line 8677: select 1 INVERT_ID from dual union all

8673: ) spread_bl
8674: ---- end of third inline view 'spread_bl'...........
8675: ,
8676: (
8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

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

8674: ---- end of third inline view 'spread_bl'...........
8675: ,
8676: (
8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert

Line 8679: select 4 INVERT_ID from dual union all

8675: ,
8676: (
8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert
8683: ) collapse_bl

Line 8680: select 8 INVERT_ID from dual union all

8676: (
8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert
8683: ) collapse_bl
8684: ---- End of second inline view 'collapse_bl' ..........

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

8677: select 1 INVERT_ID from dual union all
8678: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
8679: select 4 INVERT_ID from dual union all
8680: select 8 INVERT_ID from dual union all
8681: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
8682: ) invert
8683: ) collapse_bl
8684: ---- End of second inline view 'collapse_bl' ..........
8685: GROUP BY

Line 9812: select 1 INVERT_ID from dual union all

9808: ) spread_bl
9809: ---- end of third inline view 'spread_bl'...........
9810: ,
9811: (
9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'

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

9809: ---- end of third inline view 'spread_bl'...........
9810: ,
9811: (
9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert

Line 9814: select 4 INVERT_ID from dual union all

9810: ,
9811: (
9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert
9818: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909

Line 9815: select 8 INVERT_ID from dual union all

9811: (
9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert
9818: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
9819: ---- End of second inline view 'collapse_bl' ..........

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

9812: select 1 INVERT_ID from dual union all
9813: select 2 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('GLOBAL_CURR2_FLAG') = 'Y' union all
9814: select 4 INVERT_ID from dual union all
9815: select 8 INVERT_ID from dual union all
9816: select 16 INVERT_ID from dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
9817: ) invert
9818: ) collapse_bl -- WHERE wbs_element_id = 7474 -- and rbs_element_id = 10266 -- and budget_version_id = 2909
9819: ---- End of second inline view 'collapse_bl' ..........
9820: GROUP BY

Line 10475: SELECT 4 INVERT_ID FROM dual UNION ALL

10471: ) spread_bl
10472: ---- end of third inline view 'spread_bl'...........
10473: ,
10474: (
10475: SELECT 4 INVERT_ID FROM dual UNION ALL
10476: SELECT 8 INVERT_ID FROM dual UNION ALL
10477: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
10478: ) invert
10479: ) collapse_bl

Line 10476: SELECT 8 INVERT_ID FROM dual UNION ALL

10472: ---- end of third inline view 'spread_bl'...........
10473: ,
10474: (
10475: SELECT 4 INVERT_ID FROM dual UNION ALL
10476: SELECT 8 INVERT_ID FROM dual UNION ALL
10477: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
10478: ) invert
10479: ) collapse_bl
10480: ---- End of second inline view 'collapse_bl' ..........

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

10473: ,
10474: (
10475: SELECT 4 INVERT_ID FROM dual UNION ALL
10476: SELECT 8 INVERT_ID FROM dual UNION ALL
10477: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
10478: ) invert
10479: ) collapse_bl
10480: ---- End of second inline view 'collapse_bl' ..........
10481: GROUP BY

Line 10611: FROM DUAL;

10607: , l_last_update_date last_update_date
10608: , l_last_updated_by last_updated_by
10609: , l_created_by created_by
10610: , l_last_update_login last_update_login
10611: FROM DUAL;
10612:
10613: print_time (' INSERT_NTP_CAL_RECORD, # rows inserted is: ' || SQL%ROWCOUNT );
10614:
10615: EXCEPTION

Line 11052: SELECT 4 INVERT_ID FROM dual UNION ALL

11048: ) spread_bl
11049: ---- end of third inline view 'spread_bl'...........
11050: ,
11051: (
11052: SELECT 4 INVERT_ID FROM dual UNION ALL
11053: SELECT 8 INVERT_ID FROM dual UNION ALL
11054: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11055: ) invert
11056: ) collapse_bl

Line 11053: SELECT 8 INVERT_ID FROM dual UNION ALL

11049: ---- end of third inline view 'spread_bl'...........
11050: ,
11051: (
11052: SELECT 4 INVERT_ID FROM dual UNION ALL
11053: SELECT 8 INVERT_ID FROM dual UNION ALL
11054: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11055: ) invert
11056: ) collapse_bl
11057: ---- End of second inline view 'collapse_bl' ..........

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

11050: ,
11051: (
11052: SELECT 4 INVERT_ID FROM dual UNION ALL
11053: SELECT 8 INVERT_ID FROM dual UNION ALL
11054: SELECT 16 INVERT_ID FROM dual where PJI_UTILS.GET_SETUP_PARAMETER('TXN_CURR_FLAG') = 'Y'
11055: ) invert
11056: ) collapse_bl
11057: ---- End of second inline view 'collapse_bl' ..........
11058: GROUP BY