APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_PROJECT_STRUCTURE_UTILS

Line 306: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

302: bv.project_id project_id
303: , bv.budget_version_id plan_version_id
304: , DECODE ( NVL(bv.wp_version_flag, 'N')
305: , 'Y', bv.project_structure_version_id
306: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
307: ) wbs_struct_version_id
308: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
309: -- , to_char(fpo.fin_plan_type_id) plan_type_code
310: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 326: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

322: , 'N' SECONDARY_RBS_FLAG
323: , DECODE( NVL(bv.wp_version_flag, 'N')
324: , 'Y'
325: , DECODE(bv.project_structure_version_id
326: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
327: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
328: , 'Y'
329: , 'N')
330: , 'N'

Line 327: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

323: , DECODE( NVL(bv.wp_version_flag, 'N')
324: , 'Y'
325: , DECODE(bv.project_structure_version_id
326: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
327: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
328: , 'Y'
329: , 'N')
330: , 'N'
331: ) lp_flag

Line 368: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

364: bv.project_id project_id
365: , bv.budget_version_id plan_version_id
366: , DECODE ( NVL(bv.wp_version_flag, 'N')
367: , 'Y', bv.project_structure_version_id
368: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
369: ) wbs_struct_version_id
370: , rpa.rbs_version_id rbs_struct_version_id
371: -- , to_char(fpo.fin_plan_type_id) plan_type_code
372: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 388: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

384: , 'Y' SECONDARY_RBS_FLAG
385: , DECODE( NVL(bv.wp_version_flag, 'N')
386: , 'Y'
387: , DECODE(bv.project_structure_version_id
388: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
389: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
390: , 'Y'
391: , 'N')
392: , 'N'

Line 389: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

385: , DECODE( NVL(bv.wp_version_flag, 'N')
386: , 'Y'
387: , DECODE(bv.project_structure_version_id
388: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
389: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
390: , 'Y'
391: , 'N')
392: , 'N'
393: ) lp_flag

Line 438: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

434: bv.project_id project_id
435: , pln_ver.pvi plan_version_id
436: , DECODE ( NVL(bv.wp_version_flag, 'N')
437: , 'Y', bv.project_structure_version_id
438: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
439: ) wbs_struct_version_id
440: , rpa.rbs_version_id rbs_struct_version_id
441: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
442: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 568: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

564: bv.project_id project_id
565: , bv.budget_version_id plan_version_id
566: , DECODE ( NVL(bv.wp_version_flag, 'N')
567: , 'Y', bv.project_structure_version_id
568: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
569: ) wbs_struct_version_id
570: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
571: -- , to_char(fpo.fin_plan_type_id) plan_type_code
572: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 588: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

584: , 'N' SECONDARY_RBS_FLAG
585: , DECODE( NVL(bv.wp_version_flag, 'N')
586: , 'Y'
587: , DECODE(bv.project_structure_version_id
588: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
589: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
590: , 'Y'
591: , 'N')
592: , 'N'

Line 589: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

585: , DECODE( NVL(bv.wp_version_flag, 'N')
586: , 'Y'
587: , DECODE(bv.project_structure_version_id
588: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
589: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
590: , 'Y'
591: , 'N')
592: , 'N'
593: ) lp_flag

Line 653: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

649: bv.project_id project_id
650: , bv.budget_version_id plan_version_id
651: , DECODE ( NVL(bv.wp_version_flag, 'N')
652: , 'Y', bv.project_structure_version_id
653: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
654: ) wbs_struct_version_id
655: , rpa.rbs_version_id rbs_struct_version_id
656: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */
657: , fpo.fin_plan_type_id plan_type_id

Line 672: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

668: , 'Y' SECONDARY_RBS_FLAG
669: , DECODE( NVL(bv.wp_version_flag, 'N')
670: , 'Y'
671: , DECODE(bv.project_structure_version_id
672: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
673: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
674: , 'Y'
675: , 'N')
676: , 'N'

Line 673: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

669: , DECODE( NVL(bv.wp_version_flag, 'N')
670: , 'Y'
671: , DECODE(bv.project_structure_version_id
672: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
673: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
674: , 'Y'
675: , 'N')
676: , 'N'
677: ) lp_flag

Line 1871: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

1867: , bv.project_id project_id
1868: , bv.budget_version_id plan_version_id
1869: , DECODE ( NVL(bv.wp_version_flag, 'N')
1870: , 'Y', bv.project_structure_version_id
1871: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1872: ) wbs_struct_version_id
1873: , fpo.rbs_version_id rbs_struct_version_id
1874: -- , to_char(fpo.fin_plan_type_id) plan_type_code
1875: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 1894: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

1890: , 'N' SECONDARY_RBS_FLAG
1891: , DECODE( NVL(bv.wp_version_flag, 'N')
1892: , 'Y'
1893: , DECODE(bv.project_structure_version_id
1894: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1895: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1896: , 'Y'
1897: , 'N')
1898: , 'N'

Line 1895: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

1891: , DECODE( NVL(bv.wp_version_flag, 'N')
1892: , 'Y'
1893: , DECODE(bv.project_structure_version_id
1894: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1895: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1896: , 'Y'
1897: , 'N')
1898: , 'N'
1899: ) lp_flag

Line 1921: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

1917: , bv.project_id project_id
1918: , bv.budget_version_id plan_version_id
1919: , DECODE ( NVL(bv.wp_version_flag, 'N')
1920: , 'Y', bv.project_structure_version_id
1921: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1922: ) wbs_struct_version_id
1923: , fpo.rbs_version_id rbs_struct_version_id
1924: -- , to_char(fpo.fin_plan_type_id) plan_type_code
1925: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 1944: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

1940: , 'N' SECONDARY_RBS_FLAG
1941: , DECODE( NVL(bv.wp_version_flag, 'N')
1942: , 'Y'
1943: , DECODE(bv.project_structure_version_id
1944: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1945: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1946: , 'Y'
1947: , 'N')
1948: , 'N'

Line 1945: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

1941: , DECODE( NVL(bv.wp_version_flag, 'N')
1942: , 'Y'
1943: , DECODE(bv.project_structure_version_id
1944: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1945: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1946: , 'Y'
1947: , 'N')
1948: , 'N'
1949: ) lp_flag

Line 1972: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

1968: , bv.project_id project_id
1969: , bv.budget_version_id plan_version_id
1970: , DECODE ( NVL(bv.wp_version_flag, 'N')
1971: , 'Y', bv.project_structure_version_id
1972: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1973: ) wbs_struct_version_id
1974: , fpo.rbs_version_id rbs_struct_version_id
1975: -- , to_char(fpo.fin_plan_type_id) plan_type_code
1976: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 1991: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

1987: , 'N' SECONDARY_RBS_FLAG
1988: , DECODE( NVL(bv.wp_version_flag, 'N')
1989: , 'Y'
1990: , DECODE(bv.project_structure_version_id
1991: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1992: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1993: , 'Y'
1994: , 'N')
1995: , 'N'

Line 1992: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

1988: , DECODE( NVL(bv.wp_version_flag, 'N')
1989: , 'Y'
1990: , DECODE(bv.project_structure_version_id
1991: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1992: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1993: , 'Y'
1994: , 'N')
1995: , 'N'
1996: ) lp_flag

Line 2043: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2039: , bv.project_id project_id
2040: , bv.budget_version_id plan_version_id
2041: , DECODE ( NVL(bv.wp_version_flag, 'N')
2042: , 'Y', bv.project_structure_version_id
2043: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2044: ) wbs_struct_version_id
2045: , fpo.rbs_version_id rbs_struct_version_id
2046: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2047: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2066: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2062: , 'N' SECONDARY_RBS_FLAG
2063: , DECODE( NVL(bv.wp_version_flag, 'N')
2064: , 'Y'
2065: , DECODE(bv.project_structure_version_id
2066: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2067: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2068: , 'Y'
2069: , 'N')
2070: , 'N'

Line 2067: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2063: , DECODE( NVL(bv.wp_version_flag, 'N')
2064: , 'Y'
2065: , DECODE(bv.project_structure_version_id
2066: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2067: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2068: , 'Y'
2069: , 'N')
2070: , 'N'
2071: ) lp_flag

Line 2117: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id

2113: SELECT DISTINCT -- For insertion of -3/-4 header records.
2114: g_worker_id worker_id
2115: , den.sup_project_id project_id
2116: , cbco.plan_version_id plan_version_id
2117: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
2118: , hd2.rbs_struct_version_id rbs_version_id
2119: , hd2.plan_type_code plan_type_code /*4471527 */
2120: , hd2.plan_type_id plan_type_id
2121: , hd2.time_phased_type_code time_phased_type_code

Line 2174: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id

2170: SELECT DISTINCT -- For insertion of -3/-4 header records.
2171: g_worker_id worker_id
2172: , hd2.project_id project_id
2173: , cbco.plan_version_id plan_version_id
2174: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id
2175: , hd2.rbs_struct_version_id rbs_version_id
2176: , hd2.plan_type_code plan_type_code /*4471527 */
2177: , hd2.plan_type_id plan_type_id
2178: , hd2.time_phased_type_code time_phased_type_code

Line 2232: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2228: , bv.project_id project_id
2229: , bv.budget_version_id plan_version_id
2230: , DECODE ( NVL(bv.wp_version_flag, 'N')
2231: , 'Y', bv.project_structure_version_id
2232: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2233: ) wbs_struct_version_id
2234: , fpo.rbs_version_id rbs_struct_version_id
2235: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2236: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2255: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2251: , 'N' SECONDARY_RBS_FLAG
2252: , DECODE( NVL(bv.wp_version_flag, 'N')
2253: , 'Y'
2254: , DECODE(bv.project_structure_version_id
2255: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2256: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2257: , 'Y'
2258: , 'N')
2259: , 'N'

Line 2256: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2252: , DECODE( NVL(bv.wp_version_flag, 'N')
2253: , 'Y'
2254: , DECODE(bv.project_structure_version_id
2255: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2256: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2257: , 'Y'
2258: , 'N')
2259: , 'N'
2260: ) lp_flag

Line 2308: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2304: , bv.project_id project_id
2305: , bv.budget_version_id plan_version_id
2306: , DECODE ( NVL(bv.wp_version_flag, 'N')
2307: , 'Y', bv.project_structure_version_id
2308: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2309: ) wbs_struct_version_id
2310: , rpa.rbs_version_id rbs_struct_version_id
2311: -- , fpo.rbs_version_id rbs_struct_version_id
2312: -- , to_char(fpo.fin_plan_type_id) plan_type_code

Line 2332: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2328: , 'Y' SECONDARY_RBS_FLAG
2329: , DECODE( NVL(bv.wp_version_flag, 'N')
2330: , 'Y'
2331: , DECODE(bv.project_structure_version_id
2332: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2333: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2334: , 'Y'
2335: , 'N')
2336: , 'N'

Line 2333: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2329: , DECODE( NVL(bv.wp_version_flag, 'N')
2330: , 'Y'
2331: , DECODE(bv.project_structure_version_id
2332: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2333: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2334: , 'Y'
2335: , 'N')
2336: , 'N'
2337: ) lp_flag

Line 2395: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2391: , bv.project_id project_id
2392: , bv.budget_version_id plan_version_id
2393: , DECODE ( NVL(bv.wp_version_flag, 'N')
2394: , 'Y', bv.project_structure_version_id
2395: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2396: ) wbs_struct_version_id
2397: , fpo.rbs_version_id rbs_struct_version_id
2398: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2399: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2418: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2414: , 'N' SECONDARY_RBS_FLAG
2415: , DECODE( NVL(bv.wp_version_flag, 'N')
2416: , 'Y'
2417: , DECODE(bv.project_structure_version_id
2418: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2419: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2420: , 'Y'
2421: , 'N')
2422: , 'N'

Line 2419: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2415: , DECODE( NVL(bv.wp_version_flag, 'N')
2416: , 'Y'
2417: , DECODE(bv.project_structure_version_id
2418: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2419: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2420: , 'Y'
2421: , 'N')
2422: , 'N'
2423: ) lp_flag

Line 2451: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2447: , bv.project_id project_id
2448: , bv.budget_version_id plan_version_id
2449: , DECODE ( NVL(bv.wp_version_flag, 'N')
2450: , 'Y', bv.project_structure_version_id
2451: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2452: ) wbs_struct_version_id
2453: , fpo.rbs_version_id rbs_struct_version_id
2454: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2455: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2470: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2466: , 'N' SECONDARY_RBS_FLAG
2467: , DECODE( NVL(bv.wp_version_flag, 'N')
2468: , 'Y'
2469: , DECODE(bv.project_structure_version_id
2470: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2471: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2472: , 'Y'
2473: , 'N')
2474: , 'N'

Line 2471: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2467: , DECODE( NVL(bv.wp_version_flag, 'N')
2468: , 'Y'
2469: , DECODE(bv.project_structure_version_id
2470: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2471: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2472: , 'Y'
2473: , 'N')
2474: , 'N'
2475: ) lp_flag

Line 2503: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2499: , bv.project_id project_id
2500: , cbco.plan_version_id plan_version_id
2501: , DECODE ( NVL(bv.wp_version_flag, 'N')
2502: , 'Y', bv.project_structure_version_id
2503: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2504: ) wbs_struct_version_id
2505: , fpo.rbs_version_id rbs_struct_version_id
2506: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2507: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2526: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2522: , 'N' SECONDARY_RBS_FLAG
2523: , DECODE( NVL(bv.wp_version_flag, 'N')
2524: , 'Y'
2525: , DECODE(bv.project_structure_version_id
2526: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2527: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2528: , 'Y'
2529: , 'N')
2530: , 'N'

Line 2527: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)

2523: , DECODE( NVL(bv.wp_version_flag, 'N')
2524: , 'Y'
2525: , DECODE(bv.project_structure_version_id
2526: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2527: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2528: , 'Y'
2529: , 'N')
2530: , 'N'
2531: ) lp_flag

Line 2582: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2578: , bv.project_id project_id
2579: , bv.budget_version_id plan_version_id
2580: , DECODE ( NVL(bv.wp_version_flag, 'N')
2581: , 'Y', bv.project_structure_version_id
2582: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2583: ) wbs_struct_version_id
2584: , fpo.rbs_version_id rbs_struct_version_id
2585: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2586: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2605: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2601: , 'N' SECONDARY_RBS_FLAG
2602: , DECODE( NVL(bv.wp_version_flag, 'N')
2603: , 'Y'
2604: , DECODE(bv.project_structure_version_id
2605: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2606: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2607: , 'Y'
2608: , 'N')
2609: , 'N'

Line 2606: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2602: , DECODE( NVL(bv.wp_version_flag, 'N')
2603: , 'Y'
2604: , DECODE(bv.project_structure_version_id
2605: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2606: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2607: , 'Y'
2608: , 'N')
2609: , 'N'
2610: ) lp_flag

Line 2637: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2633: , bv.project_id project_id
2634: , cbco.plan_version_id plan_version_id
2635: , DECODE ( NVL(bv.wp_version_flag, 'N')
2636: , 'Y', bv.project_structure_version_id
2637: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2638: ) wbs_struct_version_id
2639: , fpo.rbs_version_id rbs_struct_version_id
2640: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2641: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2660: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2656: , 'N' SECONDARY_RBS_FLAG
2657: , DECODE( NVL(bv.wp_version_flag, 'N')
2658: , 'Y'
2659: , DECODE(bv.project_structure_version_id
2660: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2661: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2662: , 'Y'
2663: , 'N')
2664: , 'N'

Line 2661: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)

2657: , DECODE( NVL(bv.wp_version_flag, 'N')
2658: , 'Y'
2659: , DECODE(bv.project_structure_version_id
2660: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2661: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2662: , 'Y'
2663: , 'N')
2664: , 'N'
2665: ) lp_flag

Line 2740: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2736: bv.project_id project_id
2737: , bv.budget_version_id plan_version_id
2738: , DECODE ( NVL(bv.wp_version_flag, 'N')
2739: , 'Y', bv.project_structure_version_id
2740: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2741: ) wbs_struct_version_id
2742: , rpa.rbs_version_id rbs_struct_version_id
2743: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2744: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2763: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2759: , 'Y' SECONDARY_RBS_FLAG
2760: , DECODE( NVL(bv.wp_version_flag, 'N')
2761: , 'Y'
2762: , DECODE(bv.project_structure_version_id
2763: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2764: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2765: , 'Y'
2766: , 'N')
2767: , 'N'

Line 2764: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2760: , DECODE( NVL(bv.wp_version_flag, 'N')
2761: , 'Y'
2762: , DECODE(bv.project_structure_version_id
2763: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2764: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2765: , 'Y'
2766: , 'N')
2767: , 'N'
2768: ) lp_flag

Line 2799: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2795: bv.project_id project_id
2796: , bv.budget_version_id plan_version_id
2797: , DECODE ( NVL(bv.wp_version_flag, 'N')
2798: , 'Y', bv.project_structure_version_id
2799: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2800: ) wbs_struct_version_id
2801: , rpa.rbs_version_id rbs_struct_version_id
2802: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2803: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2818: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2814: , 'Y' SECONDARY_RBS_FLAG
2815: , DECODE( NVL(bv.wp_version_flag, 'N')
2816: , 'Y'
2817: , DECODE(bv.project_structure_version_id
2818: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2819: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2820: , 'Y'
2821: , 'N')
2822: , 'N'

Line 2819: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2815: , DECODE( NVL(bv.wp_version_flag, 'N')
2816: , 'Y'
2817: , DECODE(bv.project_structure_version_id
2818: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2819: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2820: , 'Y'
2821: , 'N')
2822: , 'N'
2823: ) lp_flag

Line 2854: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2850: bv.project_id project_id
2851: , cbco.plan_version_id plan_version_id
2852: , DECODE ( NVL(bv.wp_version_flag, 'N')
2853: , 'Y', bv.project_structure_version_id
2854: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2855: ) wbs_struct_version_id
2856: , rpa.rbs_version_id rbs_struct_version_id
2857: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2858: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2874: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2870: , 'Y' SECONDARY_RBS_FLAG
2871: , DECODE( NVL(bv.wp_version_flag, 'N')
2872: , 'Y'
2873: , DECODE(bv.project_structure_version_id
2874: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2875: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2876: , 'Y'
2877: , 'N')
2878: , 'N'

Line 2875: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)

2871: , DECODE( NVL(bv.wp_version_flag, 'N')
2872: , 'Y'
2873: , DECODE(bv.project_structure_version_id
2874: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2875: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2876: , 'Y'
2877: , 'N')
2878: , 'N'
2879: ) lp_flag

Line 2912: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2908: bv.project_id project_id
2909: , bv.budget_version_id plan_version_id
2910: , DECODE ( NVL(bv.wp_version_flag, 'N')
2911: , 'Y', bv.project_structure_version_id
2912: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2913: ) wbs_struct_version_id
2914: , rpa.rbs_version_id rbs_struct_version_id
2915: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2916: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2935: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2931: , 'Y' SECONDARY_RBS_FLAG
2932: , DECODE( NVL(bv.wp_version_flag, 'N')
2933: , 'Y'
2934: , DECODE(bv.project_structure_version_id
2935: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2936: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2937: , 'Y'
2938: , 'N')
2939: , 'N'

Line 2936: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2932: , DECODE( NVL(bv.wp_version_flag, 'N')
2933: , 'Y'
2934: , DECODE(bv.project_structure_version_id
2935: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2936: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2937: , 'Y'
2938: , 'N')
2939: , 'N'
2940: ) lp_flag

Line 2976: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

2972: bv.project_id project_id
2973: , cbcov.plan_version_id plan_version_id
2974: , DECODE ( NVL(bv.wp_version_flag, 'N')
2975: , 'Y', bv.project_structure_version_id
2976: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2977: ) wbs_struct_version_id
2978: , TO_NUMBER(ev.event_object) rbs_struct_version_id
2979: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2980: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 2999: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

2995: , 'Y' SECONDARY_RBS_FLAG
2996: , DECODE( NVL(bv.wp_version_flag, 'N')
2997: , 'Y'
2998: , DECODE(bv.project_structure_version_id
2999: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3000: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3001: , 'Y'
3002: , 'N')
3003: , 'N'

Line 3000: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

2996: , DECODE( NVL(bv.wp_version_flag, 'N')
2997: , 'Y'
2998: , DECODE(bv.project_structure_version_id
2999: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3000: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3001: , 'Y'
3002: , 'N')
3003: , 'N'
3004: ) lp_flag

Line 3040: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3036: bv.project_id project_id
3037: , bv.budget_version_id plan_version_id
3038: , DECODE ( NVL(bv.wp_version_flag, 'N')
3039: , 'Y', bv.project_structure_version_id
3040: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3041: ) wbs_struct_version_id
3042: , TO_NUMBER(ev.event_object) rbs_version_id
3043: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3044: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3063: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3059: , 'Y' SECONDARY_RBS_FLAG
3060: , DECODE( NVL(bv.wp_version_flag, 'N')
3061: , 'Y'
3062: , DECODE(bv.project_structure_version_id
3063: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3064: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3065: , 'Y'
3066: , 'N')
3067: , 'N'

Line 3064: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3060: , DECODE( NVL(bv.wp_version_flag, 'N')
3061: , 'Y'
3062: , DECODE(bv.project_structure_version_id
3063: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3064: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3065: , 'Y'
3066: , 'N')
3067: , 'N'
3068: ) lp_flag

Line 3115: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3111: bv.project_id project_id
3112: , cbcov.plan_version_id plan_version_id
3113: , DECODE ( NVL(bv.wp_version_flag, 'N')
3114: , 'Y', bv.project_structure_version_id
3115: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3116: ) wbs_struct_version_id
3117: , TO_NUMBER(ev.event_object) rbs_version_id
3118: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3119: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3135: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3131: , 'Y' SECONDARY_RBS_FLAG
3132: , DECODE( NVL(bv.wp_version_flag, 'N')
3133: , 'Y'
3134: , DECODE(bv.project_structure_version_id
3135: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3136: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3137: , 'Y'
3138: , 'N')
3139: , 'N'

Line 3136: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3132: , DECODE( NVL(bv.wp_version_flag, 'N')
3133: , 'Y'
3134: , DECODE(bv.project_structure_version_id
3135: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3136: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3137: , 'Y'
3138: , 'N')
3139: , 'N'
3140: ) lp_flag

Line 3190: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(project_id) wbs_version_id

3186: -- Added for Bug# 8838371
3187: SELECT
3188: project_id
3189: , plan_version_id
3190: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(project_id) wbs_version_id
3191: , rbs_version_id
3192: , plan_type_code
3193: , plan_type_id
3194: , time_phased_type_code

Line 3207: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_version_id

3203: (
3204: SELECT DISTINCT /*+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) */ -- 'PRG_CHANGE' event.
3205: den.sup_project_id project_id
3206: , cbco.plan_version_id plan_version_id -- -3/-4
3207: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_version_id
3208: , fpo.parvi rbs_version_id
3209: -- , TO_CHAR(whsub.plan_type_id) plan_type_code
3210: , whsub.plan_type_code plan_type_code /*4471527 */
3211: , whsub.plan_type_id plan_type_id

Line 3318: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3314: bv.project_id project_id
3315: , bv.budget_version_id plan_version_id
3316: , DECODE ( NVL(bv.wp_version_flag, 'N')
3317: , 'Y', bv.project_structure_version_id
3318: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3319: ) wbs_struct_version_id
3320: , rpa.rbs_version_id rbs_struct_version_id
3321: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3322: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3341: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3337: , 'Y' SECONDARY_RBS_FLAG
3338: , DECODE( NVL(bv.wp_version_flag, 'N')
3339: , 'Y'
3340: , DECODE(bv.project_structure_version_id
3341: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3342: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3343: , 'Y'
3344: , 'N')
3345: , 'N'

Line 3342: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3338: , DECODE( NVL(bv.wp_version_flag, 'N')
3339: , 'Y'
3340: , DECODE(bv.project_structure_version_id
3341: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3342: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3343: , 'Y'
3344: , 'N')
3345: , 'N'
3346: ) lp_flag

Line 3378: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3374: bv.project_id project_id
3375: , cbco.plan_version_id plan_version_id
3376: , DECODE ( NVL(bv.wp_version_flag, 'N')
3377: , 'Y', bv.project_structure_version_id
3378: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3379: ) wbs_struct_version_id
3380: , rpa.rbs_version_id rbs_struct_version_id
3381: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3382: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3398: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3394: , 'Y' SECONDARY_RBS_FLAG
3395: , DECODE( NVL(bv.wp_version_flag, 'N')
3396: , 'Y'
3397: , DECODE(bv.project_structure_version_id
3398: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3399: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
3400: , 'Y'
3401: , 'N')
3402: , 'N'

Line 3399: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)

3395: , DECODE( NVL(bv.wp_version_flag, 'N')
3396: , 'Y'
3397: , DECODE(bv.project_structure_version_id
3398: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3399: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
3400: , 'Y'
3401: , 'N')
3402: , 'N'
3403: ) lp_flag

Line 3435: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3431: bv.project_id project_id
3432: , bv.budget_version_id plan_version_id
3433: , DECODE ( NVL(bv.wp_version_flag, 'N')
3434: , 'Y', bv.project_structure_version_id
3435: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3436: ) wbs_struct_version_id
3437: , rpa.rbs_version_id rbs_struct_version_id
3438: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3439: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3458: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3454: , 'Y' SECONDARY_RBS_FLAG
3455: , DECODE( NVL(bv.wp_version_flag, 'N')
3456: , 'Y'
3457: , DECODE(bv.project_structure_version_id
3458: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3459: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3460: , 'Y'
3461: , 'N')
3462: , 'N'

Line 3459: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3455: , DECODE( NVL(bv.wp_version_flag, 'N')
3456: , 'Y'
3457: , DECODE(bv.project_structure_version_id
3458: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3459: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3460: , 'Y'
3461: , 'N')
3462: , 'N'
3463: ) lp_flag

Line 3499: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3495: bv.project_id project_id
3496: , cbcov.plan_version_id plan_version_id
3497: , DECODE ( NVL(bv.wp_version_flag, 'N')
3498: , 'Y', bv.project_structure_version_id
3499: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3500: ) wbs_struct_version_id
3501: , TO_NUMBER(ev.event_object) rbs_struct_version_id
3502: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3503: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3522: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3518: , 'Y' SECONDARY_RBS_FLAG
3519: , DECODE( NVL(bv.wp_version_flag, 'N')
3520: , 'Y'
3521: , DECODE(bv.project_structure_version_id
3522: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3523: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3524: , 'Y'
3525: , 'N')
3526: , 'N'

Line 3523: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3519: , DECODE( NVL(bv.wp_version_flag, 'N')
3520: , 'Y'
3521: , DECODE(bv.project_structure_version_id
3522: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3523: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3524: , 'Y'
3525: , 'N')
3526: , 'N'
3527: ) lp_flag

Line 3563: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3559: bv.project_id project_id
3560: , bv.budget_version_id plan_version_id
3561: , DECODE ( NVL(bv.wp_version_flag, 'N')
3562: , 'Y', bv.project_structure_version_id
3563: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3564: ) wbs_struct_version_id
3565: , TO_NUMBER(ev.event_object) rbs_version_id
3566: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3567: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3586: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3582: , 'Y' SECONDARY_RBS_FLAG
3583: , DECODE( NVL(bv.wp_version_flag, 'N')
3584: , 'Y'
3585: , DECODE(bv.project_structure_version_id
3586: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3587: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3588: , 'Y'
3589: , 'N')
3590: , 'N'

Line 3587: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3583: , DECODE( NVL(bv.wp_version_flag, 'N')
3584: , 'Y'
3585: , DECODE(bv.project_structure_version_id
3586: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3587: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3588: , 'Y'
3589: , 'N')
3590: , 'N'
3591: ) lp_flag

Line 3638: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

3634: bv.project_id project_id
3635: , cbcov.plan_version_id plan_version_id
3636: , DECODE ( NVL(bv.wp_version_flag, 'N')
3637: , 'Y', bv.project_structure_version_id
3638: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
3639: ) wbs_struct_version_id
3640: , TO_NUMBER(ev.event_object) rbs_version_id
3641: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
3642: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 3658: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

3654: , 'Y' SECONDARY_RBS_FLAG
3655: , DECODE( NVL(bv.wp_version_flag, 'N')
3656: , 'Y'
3657: , DECODE(bv.project_structure_version_id
3658: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3659: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3660: , 'Y'
3661: , 'N')
3662: , 'N'

Line 3659: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

3655: , DECODE( NVL(bv.wp_version_flag, 'N')
3656: , 'Y'
3657: , DECODE(bv.project_structure_version_id
3658: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3659: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3660: , 'Y'
3661: , 'N')
3662: , 'N'
3663: ) lp_flag

Line 3713: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(project_id) wbs_struct_version_id

3709: -- Added for Bug# 8838371
3710: SELECT
3711: project_id
3712: , plan_version_id
3713: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(project_id) wbs_struct_version_id
3714: , rbs_struct_version_id
3715: , plan_type_code
3716: , plan_type_id
3717: , time_phased_type_code

Line 3730: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id

3726: (
3727: SELECT DISTINCT /*+ NO_MERGE(fpo) use_nl(fpo map whsub den) index(den pji_xbs_denorm_n6) */ -- 'PRG_CHANGE' event.
3728: den.sup_project_id project_id
3729: , cbco.plan_version_id plan_version_id -- -3/-4
3730: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
3731: , fpo.parvi rbs_struct_version_id
3732: -- , TO_CHAR(whsub.plan_type_id) plan_type_code
3733: , whsub.plan_type_code plan_type_code /*4471527 */
3734: , whsub.plan_type_id plan_type_id

Line 3823: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id

3819: SELECT DISTINCT -- For insertion of -3/-4 header records.
3820: g_worker_id worker_id
3821: , den.sup_project_id project_id
3822: , cbco.plan_version_id plan_version_id
3823: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
3824: , hd2.rbs_struct_version_id rbs_version_id
3825: ,hd2.plan_type_code plan_type_code /*4471527 */
3826: , hd2.plan_type_id plan_type_id
3827: , hd2.time_phased_type_code time_phased_type_code

Line 3894: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id

3890: SELECT DISTINCT -- For insertion of -3/-4 header records.
3891: g_worker_id worker_id
3892: , hd2.project_id project_id
3893: , cbco.plan_version_id plan_version_id
3894: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id
3895: , hd2.rbs_struct_version_id rbs_version_id
3896: , hd2.plan_type_code plan_type_code /*4471527 */
3897: , hd2.plan_type_id plan_type_id
3898: , hd2.time_phased_type_code time_phased_type_code

Line 4005: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4001: , bv.project_id project_id
4002: , bv.budget_version_id plan_version_id
4003: , DECODE ( NVL(bv.wp_version_flag, 'N')
4004: , 'Y', bv.project_structure_version_id
4005: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4006: ) wbs_struct_version_id
4007: , fpo.rbs_version_id rbs_struct_version_id
4008: -- , to_char(fpo.fin_plan_type_id) plan_type_code
4009: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 4028: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

4024: , 'N' SECONDARY_RBS_FLAG
4025: , DECODE( NVL(bv.wp_version_flag, 'N')
4026: , 'Y'
4027: , DECODE(bv.project_structure_version_id
4028: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4029: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4030: , 'Y'
4031: , 'N')
4032: , 'N'

Line 4029: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4025: , DECODE( NVL(bv.wp_version_flag, 'N')
4026: , 'Y'
4027: , DECODE(bv.project_structure_version_id
4028: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4029: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4030: , 'Y'
4031: , 'N')
4032: , 'N'
4033: ) lp_flag

Line 4084: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4080: , bv.project_id project_id
4081: , bv.budget_version_id plan_version_id
4082: , DECODE ( NVL(bv.wp_version_flag, 'N')
4083: , 'Y', bv.project_structure_version_id
4084: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4085: ) wbs_struct_version_id
4086: , fpo.rbs_version_id rbs_struct_version_id
4087: -- , to_char(fpo.fin_plan_type_id) plan_type_code
4088: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 4107: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

4103: , 'N' SECONDARY_RBS_FLAG
4104: , DECODE( NVL(bv.wp_version_flag, 'N')
4105: , 'Y'
4106: , DECODE(bv.project_structure_version_id
4107: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4108: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4109: , 'Y'
4110: , 'N')
4111: , 'N'

Line 4108: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4104: , DECODE( NVL(bv.wp_version_flag, 'N')
4105: , 'Y'
4106: , DECODE(bv.project_structure_version_id
4107: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4108: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4109: , 'Y'
4110: , 'N')
4111: , 'N'
4112: ) lp_flag

Line 4165: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4161: , bv.project_id project_id
4162: , bv.budget_version_id plan_version_id
4163: , DECODE ( NVL(bv.wp_version_flag, 'N')
4164: , 'Y', bv.project_structure_version_id
4165: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4166: ) wbs_struct_version_id
4167: , rpa.rbs_version_id rbs_struct_version_id
4168: -- , to_char(fpo.fin_plan_type_id) plan_type_code
4169: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

Line 4188: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341

4184: , 'Y' SECONDARY_RBS_FLAG
4185: , DECODE( NVL(bv.wp_version_flag, 'N')
4186: , 'Y'
4187: , DECODE(bv.project_structure_version_id
4188: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4189: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4190: , 'Y'
4191: , 'N')
4192: , 'N'

Line 4189: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)

4185: , DECODE( NVL(bv.wp_version_flag, 'N')
4186: , 'Y'
4187: , DECODE(bv.project_structure_version_id
4188: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
4189: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
4190: , 'Y'
4191: , 'N')
4192: , 'N'
4193: ) lp_flag

Line 5985: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --

5981: , epl.project_id
5982: , epl.plan_version_id
5983: , DECODE ( NVL(bv.wp_version_flag, 'N')
5984: , 'Y', bv.project_structure_version_id
5985: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
5986: ) wbs_struct_version_id
5987: -- , epl.struct_ver_id
5988: , fpo.rbs_version_id -- epl.rbs_version_id
5989: -- , to_char(epl.plan_type_id) -- pln type code