eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_PROJECT_STRUCTURE_UTILS

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

205: bv.project_id project_id
206: , bv.budget_version_id plan_version_id
207: , DECODE ( NVL(bv.wp_version_flag, 'N')
208: , 'Y', bv.project_structure_version_id
209: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
210: ) wbs_struct_version_id
211: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
212: -- , to_char(fpo.fin_plan_type_id) plan_type_code
213: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

225: , 'N' SECONDARY_RBS_FLAG
226: , DECODE( NVL(bv.wp_version_flag, 'N')
227: , 'Y'
228: , DECODE(bv.project_structure_version_id
229: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
230: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
231: , 'Y'
232: , 'N')
233: , 'N'

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

226: , DECODE( NVL(bv.wp_version_flag, 'N')
227: , 'Y'
228: , DECODE(bv.project_structure_version_id
229: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
230: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
231: , 'Y'
232: , 'N')
233: , 'N'
234: ) lp_flag

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

267: bv.project_id project_id
268: , bv.budget_version_id plan_version_id
269: , DECODE ( NVL(bv.wp_version_flag, 'N')
270: , 'Y', bv.project_structure_version_id
271: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
272: ) wbs_struct_version_id
273: , rpa.rbs_version_id rbs_struct_version_id
274: -- , to_char(fpo.fin_plan_type_id) plan_type_code
275: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

287: , 'Y' SECONDARY_RBS_FLAG
288: , DECODE( NVL(bv.wp_version_flag, 'N')
289: , 'Y'
290: , DECODE(bv.project_structure_version_id
291: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
292: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
293: , 'Y'
294: , 'N')
295: , 'N'

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

288: , DECODE( NVL(bv.wp_version_flag, 'N')
289: , 'Y'
290: , DECODE(bv.project_structure_version_id
291: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
292: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
293: , 'Y'
294: , 'N')
295: , 'N'
296: ) lp_flag

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

337: bv.project_id project_id
338: , pln_ver.pvi plan_version_id
339: , DECODE ( NVL(bv.wp_version_flag, 'N')
340: , 'Y', bv.project_structure_version_id
341: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
342: ) wbs_struct_version_id
343: , rpa.rbs_version_id rbs_struct_version_id
344: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
345: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

467: bv.project_id project_id
468: , bv.budget_version_id plan_version_id
469: , DECODE ( NVL(bv.wp_version_flag, 'N')
470: , 'Y', bv.project_structure_version_id
471: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
472: ) wbs_struct_version_id
473: , fpo.rbs_version_id rbs_struct_version_id -- extract for this rbs version id
474: -- , to_char(fpo.fin_plan_type_id) plan_type_code
475: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

487: , 'N' SECONDARY_RBS_FLAG
488: , DECODE( NVL(bv.wp_version_flag, 'N')
489: , 'Y'
490: , DECODE(bv.project_structure_version_id
491: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
492: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
493: , 'Y'
494: , 'N')
495: , 'N'

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

488: , DECODE( NVL(bv.wp_version_flag, 'N')
489: , 'Y'
490: , DECODE(bv.project_structure_version_id
491: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
492: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
493: , 'Y'
494: , 'N')
495: , 'N'
496: ) lp_flag

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

552: bv.project_id project_id
553: , bv.budget_version_id plan_version_id
554: , DECODE ( NVL(bv.wp_version_flag, 'N')
555: , 'Y', bv.project_structure_version_id
556: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
557: ) wbs_struct_version_id
558: , rpa.rbs_version_id rbs_struct_version_id
559: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */
560: , fpo.fin_plan_type_id plan_type_id

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

571: , 'Y' SECONDARY_RBS_FLAG
572: , DECODE( NVL(bv.wp_version_flag, 'N')
573: , 'Y'
574: , DECODE(bv.project_structure_version_id
575: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
576: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
577: , 'Y'
578: , 'N')
579: , 'N'

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

572: , DECODE( NVL(bv.wp_version_flag, 'N')
573: , 'Y'
574: , DECODE(bv.project_structure_version_id
575: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
576: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
577: , 'Y'
578: , 'N')
579: , 'N'
580: ) lp_flag

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

1692: , bv.project_id project_id
1693: , bv.budget_version_id plan_version_id
1694: , DECODE ( NVL(bv.wp_version_flag, 'N')
1695: , 'Y', bv.project_structure_version_id
1696: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1697: ) wbs_struct_version_id
1698: , fpo.rbs_version_id rbs_struct_version_id
1699: -- , to_char(fpo.fin_plan_type_id) plan_type_code
1700: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

1715: , 'N' SECONDARY_RBS_FLAG
1716: , DECODE( NVL(bv.wp_version_flag, 'N')
1717: , 'Y'
1718: , DECODE(bv.project_structure_version_id
1719: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1720: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1721: , 'Y'
1722: , 'N')
1723: , 'N'

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

1716: , DECODE( NVL(bv.wp_version_flag, 'N')
1717: , 'Y'
1718: , DECODE(bv.project_structure_version_id
1719: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1720: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1721: , 'Y'
1722: , 'N')
1723: , 'N'
1724: ) lp_flag

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

1765: SELECT DISTINCT -- For insertion of -3/-4 header records.
1766: g_worker_id worker_id
1767: , den.sup_project_id project_id
1768: , cbco.plan_version_id plan_version_id
1769: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
1770: , hd2.rbs_struct_version_id rbs_version_id
1771: , hd2.plan_type_code plan_type_code /*4471527 */
1772: , hd2.plan_type_id plan_type_id
1773: , hd2.time_phased_type_code time_phased_type_code

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

1822: SELECT DISTINCT -- For insertion of -3/-4 header records.
1823: g_worker_id worker_id
1824: , hd2.project_id project_id
1825: , cbco.plan_version_id plan_version_id
1826: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id
1827: , hd2.rbs_struct_version_id rbs_version_id
1828: , hd2.plan_type_code plan_type_code /*4471527 */
1829: , hd2.plan_type_id plan_type_id
1830: , hd2.time_phased_type_code time_phased_type_code

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

1880: , bv.project_id project_id
1881: , bv.budget_version_id plan_version_id
1882: , DECODE ( NVL(bv.wp_version_flag, 'N')
1883: , 'Y', bv.project_structure_version_id
1884: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1885: ) wbs_struct_version_id
1886: , fpo.rbs_version_id rbs_struct_version_id
1887: -- , to_char(fpo.fin_plan_type_id) plan_type_code
1888: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

1903: , 'N' SECONDARY_RBS_FLAG
1904: , DECODE( NVL(bv.wp_version_flag, 'N')
1905: , 'Y'
1906: , DECODE(bv.project_structure_version_id
1907: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1908: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1909: , 'Y'
1910: , 'N')
1911: , 'N'

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

1904: , DECODE( NVL(bv.wp_version_flag, 'N')
1905: , 'Y'
1906: , DECODE(bv.project_structure_version_id
1907: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1908: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1909: , 'Y'
1910: , 'N')
1911: , 'N'
1912: ) lp_flag

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

1956: , bv.project_id project_id
1957: , bv.budget_version_id plan_version_id
1958: , DECODE ( NVL(bv.wp_version_flag, 'N')
1959: , 'Y', bv.project_structure_version_id
1960: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
1961: ) wbs_struct_version_id
1962: , rpa.rbs_version_id rbs_struct_version_id
1963: -- , fpo.rbs_version_id rbs_struct_version_id
1964: -- , to_char(fpo.fin_plan_type_id) plan_type_code

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

1980: , 'Y' SECONDARY_RBS_FLAG
1981: , DECODE( NVL(bv.wp_version_flag, 'N')
1982: , 'Y'
1983: , DECODE(bv.project_structure_version_id
1984: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1985: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1986: , 'Y'
1987: , 'N')
1988: , 'N'

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

1981: , DECODE( NVL(bv.wp_version_flag, 'N')
1982: , 'Y'
1983: , DECODE(bv.project_structure_version_id
1984: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
1985: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
1986: , 'Y'
1987: , 'N')
1988: , 'N'
1989: ) lp_flag

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

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

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

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

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

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

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

2096: , bv.project_id project_id
2097: , cbco.plan_version_id plan_version_id
2098: , DECODE ( NVL(bv.wp_version_flag, 'N')
2099: , 'Y', bv.project_structure_version_id
2100: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2101: ) wbs_struct_version_id
2102: , fpo.rbs_version_id rbs_struct_version_id
2103: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2104: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2119: , 'N' SECONDARY_RBS_FLAG
2120: , DECODE( NVL(bv.wp_version_flag, 'N')
2121: , 'Y'
2122: , DECODE(bv.project_structure_version_id
2123: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2124: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2125: , 'Y'
2126: , 'N')
2127: , 'N'

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

2120: , DECODE( NVL(bv.wp_version_flag, 'N')
2121: , 'Y'
2122: , DECODE(bv.project_structure_version_id
2123: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2124: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2125: , 'Y'
2126: , 'N')
2127: , 'N'
2128: ) lp_flag

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

2195: bv.project_id project_id
2196: , bv.budget_version_id plan_version_id
2197: , DECODE ( NVL(bv.wp_version_flag, 'N')
2198: , 'Y', bv.project_structure_version_id
2199: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2200: ) wbs_struct_version_id
2201: , rpa.rbs_version_id rbs_struct_version_id
2202: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2203: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2218: , 'Y' SECONDARY_RBS_FLAG
2219: , DECODE( NVL(bv.wp_version_flag, 'N')
2220: , 'Y'
2221: , DECODE(bv.project_structure_version_id
2222: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2223: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2224: , 'Y'
2225: , 'N')
2226: , 'N'

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

2219: , DECODE( NVL(bv.wp_version_flag, 'N')
2220: , 'Y'
2221: , DECODE(bv.project_structure_version_id
2222: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2223: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2224: , 'Y'
2225: , 'N')
2226: , 'N'
2227: ) lp_flag

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

2255: bv.project_id project_id
2256: , cbco.plan_version_id plan_version_id
2257: , DECODE ( NVL(bv.wp_version_flag, 'N')
2258: , 'Y', bv.project_structure_version_id
2259: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2260: ) wbs_struct_version_id
2261: , rpa.rbs_version_id rbs_struct_version_id
2262: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2263: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2275: , 'Y' SECONDARY_RBS_FLAG
2276: , DECODE( NVL(bv.wp_version_flag, 'N')
2277: , 'Y'
2278: , DECODE(bv.project_structure_version_id
2279: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2280: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2281: , 'Y'
2282: , 'N')
2283: , 'N'

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

2276: , DECODE( NVL(bv.wp_version_flag, 'N')
2277: , 'Y'
2278: , DECODE(bv.project_structure_version_id
2279: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2280: -- , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(bv.project_id)
2281: , 'Y'
2282: , 'N')
2283: , 'N'
2284: ) lp_flag

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

2315: bv.project_id project_id
2316: , bv.budget_version_id plan_version_id
2317: , DECODE ( NVL(bv.wp_version_flag, 'N')
2318: , 'Y', bv.project_structure_version_id
2319: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2320: ) wbs_struct_version_id
2321: , rpa.rbs_version_id rbs_struct_version_id
2322: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2323: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2338: , 'Y' SECONDARY_RBS_FLAG
2339: , DECODE( NVL(bv.wp_version_flag, 'N')
2340: , 'Y'
2341: , DECODE(bv.project_structure_version_id
2342: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2343: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2344: , 'Y'
2345: , 'N')
2346: , 'N'

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

2339: , DECODE( NVL(bv.wp_version_flag, 'N')
2340: , 'Y'
2341: , DECODE(bv.project_structure_version_id
2342: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2343: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2344: , 'Y'
2345: , 'N')
2346: , 'N'
2347: ) lp_flag

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

2378: bv.project_id project_id
2379: , cbcov.plan_version_id plan_version_id
2380: , DECODE ( NVL(bv.wp_version_flag, 'N')
2381: , 'Y', bv.project_structure_version_id
2382: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2383: ) wbs_struct_version_id
2384: , TO_NUMBER(ev.event_object) rbs_struct_version_id
2385: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2386: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2401: , 'Y' SECONDARY_RBS_FLAG
2402: , DECODE( NVL(bv.wp_version_flag, 'N')
2403: , 'Y'
2404: , DECODE(bv.project_structure_version_id
2405: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2406: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2407: , 'Y'
2408: , 'N')
2409: , 'N'

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

2402: , DECODE( NVL(bv.wp_version_flag, 'N')
2403: , 'Y'
2404: , DECODE(bv.project_structure_version_id
2405: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2406: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2407: , 'Y'
2408: , 'N')
2409: , 'N'
2410: ) lp_flag

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

2442: bv.project_id project_id
2443: , bv.budget_version_id plan_version_id
2444: , DECODE ( NVL(bv.wp_version_flag, 'N')
2445: , 'Y', bv.project_structure_version_id
2446: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2447: ) wbs_struct_version_id
2448: , TO_NUMBER(ev.event_object) rbs_version_id
2449: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2450: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

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

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

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

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

2516: bv.project_id project_id
2517: , cbcov.plan_version_id plan_version_id
2518: , DECODE ( NVL(bv.wp_version_flag, 'N')
2519: , 'Y', bv.project_structure_version_id
2520: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
2521: ) wbs_struct_version_id
2522: , TO_NUMBER(ev.event_object) rbs_version_id
2523: -- , TO_CHAR(fpo.fin_plan_type_id) plan_type_code
2524: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2536: , 'Y' SECONDARY_RBS_FLAG
2537: , DECODE( NVL(bv.wp_version_flag, 'N')
2538: , 'Y'
2539: , DECODE(bv.project_structure_version_id
2540: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2541: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2542: , 'Y'
2543: , 'N')
2544: , 'N'

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

2537: , DECODE( NVL(bv.wp_version_flag, 'N')
2538: , 'Y'
2539: , DECODE(bv.project_structure_version_id
2540: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2541: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2542: , 'Y'
2543: , 'N')
2544: , 'N'
2545: ) lp_flag

Line 2593: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_version_id

2589: UNION ALL
2590: SELECT DISTINCT -- 'PRG_CHANGE' event.
2591: den.sup_project_id project_id
2592: , cbco.plan_version_id plan_version_id -- -3/-4
2593: , Pa_Project_Structure_Utils.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_version_id
2594: , fpo.parvi rbs_version_id
2595: -- , TO_CHAR(whsub.plan_type_id) plan_type_code
2596: , whsub.plan_type_code plan_type_code /*4471527 */
2597: , whsub.plan_type_id plan_type_id

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

2700: SELECT DISTINCT -- For insertion of -3/-4 header records.
2701: g_worker_id worker_id
2702: , den.sup_project_id project_id
2703: , cbco.plan_version_id plan_version_id
2704: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(den.sup_project_id) wbs_struct_version_id
2705: , hd2.rbs_struct_version_id rbs_version_id
2706: ,hd2.plan_type_code plan_type_code /*4471527 */
2707: , hd2.plan_type_id plan_type_id
2708: , hd2.time_phased_type_code time_phased_type_code

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

2761: SELECT DISTINCT -- For insertion of -3/-4 header records.
2762: g_worker_id worker_id
2763: , hd2.project_id project_id
2764: , cbco.plan_version_id plan_version_id
2765: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(hd2.project_id) wbs_struct_version_id
2766: , hd2.rbs_struct_version_id rbs_version_id
2767: , hd2.plan_type_code plan_type_code /*4471527 */
2768: , hd2.plan_type_id plan_type_id
2769: , hd2.time_phased_type_code time_phased_type_code

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

2861: , bv.project_id project_id
2862: , bv.budget_version_id plan_version_id
2863: , DECODE ( NVL(bv.wp_version_flag, 'N')
2864: , 'Y', bv.project_structure_version_id
2865: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2866: ) wbs_struct_version_id
2867: , fpo.rbs_version_id rbs_struct_version_id
2868: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2869: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2884: , 'N' SECONDARY_RBS_FLAG
2885: , DECODE( NVL(bv.wp_version_flag, 'N')
2886: , 'Y'
2887: , DECODE(bv.project_structure_version_id
2888: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2889: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2890: , 'Y'
2891: , 'N')
2892: , 'N'

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

2885: , DECODE( NVL(bv.wp_version_flag, 'N')
2886: , 'Y'
2887: , DECODE(bv.project_structure_version_id
2888: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2889: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2890: , 'Y'
2891: , 'N')
2892: , 'N'
2893: ) lp_flag

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

2940: , bv.project_id project_id
2941: , bv.budget_version_id plan_version_id
2942: , DECODE ( NVL(bv.wp_version_flag, 'N')
2943: , 'Y', bv.project_structure_version_id
2944: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2945: ) wbs_struct_version_id
2946: , fpo.rbs_version_id rbs_struct_version_id
2947: -- , to_char(fpo.fin_plan_type_id) plan_type_code
2948: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

2963: , 'N' SECONDARY_RBS_FLAG
2964: , DECODE( NVL(bv.wp_version_flag, 'N')
2965: , 'Y'
2966: , DECODE(bv.project_structure_version_id
2967: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2968: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2969: , 'Y'
2970: , 'N')
2971: , 'N'

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

2964: , DECODE( NVL(bv.wp_version_flag, 'N')
2965: , 'Y'
2966: , DECODE(bv.project_structure_version_id
2967: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
2968: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
2969: , 'Y'
2970: , 'N')
2971: , 'N'
2972: ) lp_flag

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

3021: , bv.project_id project_id
3022: , bv.budget_version_id plan_version_id
3023: , DECODE ( NVL(bv.wp_version_flag, 'N')
3024: , 'Y', bv.project_structure_version_id
3025: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3026: ) wbs_struct_version_id
3027: , rpa.rbs_version_id rbs_struct_version_id
3028: -- , to_char(fpo.fin_plan_type_id) plan_type_code
3029: , DECODE (bv.version_type, 'COST' ,'C' , 'REVENUE', 'R', 'A') plan_type_code /* 4471527 */

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

3044: , 'Y' SECONDARY_RBS_FLAG
3045: , DECODE( NVL(bv.wp_version_flag, 'N')
3046: , 'Y'
3047: , DECODE(bv.project_structure_version_id
3048: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3049: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3050: , 'Y'
3051: , 'N')
3052: , 'N'

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

3045: , DECODE( NVL(bv.wp_version_flag, 'N')
3046: , 'Y'
3047: , DECODE(bv.project_structure_version_id
3048: , PA_PROJECT_STRUCTURE_UTILS.GET_LATEST_WP_VERSION( bv.project_id) -- 4682341
3049: -- , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id)
3050: , 'Y'
3051: , 'N')
3052: , 'N'
3053: ) lp_flag

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

4797: , epl.project_id
4798: , epl.plan_version_id
4799: , DECODE ( NVL(bv.wp_version_flag, 'N')
4800: , 'Y', bv.project_structure_version_id
4801: , PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(bv.project_id) -- -9999 --
4802: ) wbs_struct_version_id
4803: -- , epl.struct_ver_id
4804: , fpo.rbs_version_id -- epl.rbs_version_id
4805: -- , to_char(epl.plan_type_id) -- pln type code