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_CAL_RLPS dependencies on PJI_UTILS

Line 51: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

47: PROCEDURE CREATE_FP_ENT_ROLLUP IS -- Public
48: BEGIN
49:
50: /* Added for bug 13030627 */
51: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
52:
53: PJI_PJP_PRG_PERF_ALL.CREATE_FP_ENT_ROLLUP;
54:
55: else

Line 280: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

276:
277: BEGIN
278:
279: /* Added for bug 13030627 */
280: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
281:
282: PJI_PJP_PRG_PERF_ALL.CREATE_FP_PA_PRI_ROLLUP;
283:
284: else

Line 508: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

504:
505: BEGIN
506:
507: /* Added for bug 13030627 */
508: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
509:
510: PJI_PJP_PRG_PERF_ALL.CREATE_FP_GL_PRI_ROLLUP;
511:
512: else

Line 737: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

733:
734: BEGIN
735:
736: /* Added for bug 13030627 */
737: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
738:
739: PJI_PJP_PRG_PERF_ALL.CREATE_FP_ALL_T_PRI_ROLLUP;
740:
741: else

Line 2082: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

2078: PROCEDURE PRORATE_TO_ENT_PG_PJP1_D IS
2079: BEGIN
2080:
2081: /* Added for bug 13030627 */
2082: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
2083:
2084: PJI_PJP_PRG_PERF_ALL.PRORATE_TO_ENT_PG_PJP1_D;
2085:
2086: else

Line 2280: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2276: , '0-1' , fact.raw_cost
2277: , '1-1' , fact.raw_cost
2278: , 0 ) -- end decode
2279: , 0 ) -- end nvl
2280: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2281: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
2282: , ROUND (
2283: NVL (
2284: DECODE (

Line 2281: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost

2277: , '1-1' , fact.raw_cost
2278: , 0 ) -- end decode
2279: , 0 ) -- end nvl
2280: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2281: * PJI_UTILS.GET_MAU (fact.currency_code) raw_cost
2282: , ROUND (
2283: NVL (
2284: DECODE (
2285: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2297: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2293: , '0-1' , fact.brdn_cost
2294: , '1-1' , fact.brdn_cost
2295: , 0 ) -- end decode
2296: , 0 ) -- end nvl
2297: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2298: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
2299: , ROUND (
2300: NVL (
2301: DECODE (

Line 2298: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost

2294: , '1-1' , fact.brdn_cost
2295: , 0 ) -- end decode
2296: , 0 ) -- end nvl
2297: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2298: * PJI_UTILS.GET_MAU (fact.currency_code) brdn_cost
2299: , ROUND (
2300: NVL (
2301: DECODE (
2302: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2314: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2310: , '0-1' , fact.revenue
2311: , '1-1' , fact.revenue
2312: , 0 ) -- end decode
2313: , 0 ) -- end nvl
2314: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2315: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
2316: , ROUND (
2317: NVL (
2318: DECODE (

Line 2315: * PJI_UTILS.GET_MAU (fact.currency_code) revenue

2311: , '1-1' , fact.revenue
2312: , 0 ) -- end decode
2313: , 0 ) -- end nvl
2314: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2315: * PJI_UTILS.GET_MAU (fact.currency_code) revenue
2316: , ROUND (
2317: NVL (
2318: DECODE (
2319: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2331: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2327: , '0-1' , fact.bill_raw_cost
2328: , '1-1' , fact.bill_raw_cost
2329: , 0 ) -- end decode
2330: , 0 ) -- end nvl
2331: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2332: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
2333: , ROUND (
2334: NVL (
2335: DECODE (

Line 2332: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost

2328: , '1-1' , fact.bill_raw_cost
2329: , 0 ) -- end decode
2330: , 0 ) -- end nvl
2331: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2332: * PJI_UTILS.GET_MAU (fact.currency_code) bill_raw_cost
2333: , ROUND (
2334: NVL (
2335: DECODE (
2336: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2348: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2344: , '0-1' , fact.bill_brdn_cost
2345: , '1-1' , fact.bill_brdn_cost
2346: , 0 ) -- end decode
2347: , 0 ) -- end nvl
2348: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2349: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
2350: , ROUND (
2351: NVL (
2352: DECODE (

Line 2349: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost

2345: , '1-1' , fact.bill_brdn_cost
2346: , 0 ) -- end decode
2347: , 0 ) -- end nvl
2348: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2349: * PJI_UTILS.GET_MAU (fact.currency_code) bill_brdn_cost
2350: , ROUND (
2351: NVL (
2352: DECODE (
2353: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2365: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2361: , '0-1' , fact.bill_labor_raw_cost
2362: , '1-1' , fact.bill_labor_raw_cost
2363: , 0 ) -- end decode
2364: , 0 ) -- end nvl
2365: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2366: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
2367: , ROUND (
2368: NVL (
2369: DECODE (

Line 2366: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost

2362: , '1-1' , fact.bill_labor_raw_cost
2363: , 0 ) -- end decode
2364: , 0 ) -- end nvl
2365: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2366: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_raw_cost
2367: , ROUND (
2368: NVL (
2369: DECODE (
2370: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2382: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2378: , '0-1' , fact.bill_labor_brdn_cost
2379: , '1-1' , fact.bill_labor_brdn_cost
2380: , 0 ) -- end decode
2381: , 0 ) -- end nvl
2382: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2383: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
2384: , ROUND (
2385: NVL (
2386: DECODE (

Line 2383: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost

2379: , '1-1' , fact.bill_labor_brdn_cost
2380: , 0 ) -- end decode
2381: , 0 ) -- end nvl
2382: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2383: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_brdn_cost
2384: , ROUND (
2385: NVL (
2386: DECODE (
2387: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2399: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2395: , '0-1' , fact.bill_labor_hrs
2396: , '1-1' , fact.bill_labor_hrs
2397: , 0 ) -- end decode
2398: , 0 ) -- end nvl
2399: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2400: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
2401: , ROUND (
2402: NVL (
2403: DECODE (

Line 2400: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs

2396: , '1-1' , fact.bill_labor_hrs
2397: , 0 ) -- end decode
2398: , 0 ) -- end nvl
2399: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2400: * PJI_UTILS.GET_MAU (fact.currency_code) bill_labor_hrs
2401: , ROUND (
2402: NVL (
2403: DECODE (
2404: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2416: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2412: , '0-1' , fact.equipment_raw_cost
2413: , '1-1' , fact.equipment_raw_cost
2414: , 0 ) -- end decode
2415: , 0 ) -- end nvl
2416: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2417: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
2418: , ROUND (
2419: NVL (
2420: DECODE (

Line 2417: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost

2413: , '1-1' , fact.equipment_raw_cost
2414: , 0 ) -- end decode
2415: , 0 ) -- end nvl
2416: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2417: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_raw_cost
2418: , ROUND (
2419: NVL (
2420: DECODE (
2421: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2433: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2429: , '0-1' , fact.equipment_brdn_cost
2430: , '1-1' , fact.equipment_brdn_cost
2431: , 0 ) -- end decode
2432: , 0 ) -- end nvl
2433: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2434: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
2435: , ROUND (
2436: NVL (
2437: DECODE (

Line 2434: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost

2430: , '1-1' , fact.equipment_brdn_cost
2431: , 0 ) -- end decode
2432: , 0 ) -- end nvl
2433: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2434: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_brdn_cost
2435: , ROUND (
2436: NVL (
2437: DECODE (
2438: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2450: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2446: , '0-1' , fact.capitalizable_raw_cost
2447: , '1-1' , fact.capitalizable_raw_cost
2448: , 0 ) -- end decode
2449: , 0 ) -- end nvl
2450: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2451: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
2452: , ROUND (
2453: NVL (
2454: DECODE (

Line 2451: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost

2447: , '1-1' , fact.capitalizable_raw_cost
2448: , 0 ) -- end decode
2449: , 0 ) -- end nvl
2450: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2451: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_raw_cost
2452: , ROUND (
2453: NVL (
2454: DECODE (
2455: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2467: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2463: , '0-1' , fact.capitalizable_brdn_cost
2464: , '1-1' , fact.capitalizable_brdn_cost
2465: , 0 ) -- end decode
2466: , 0 ) -- end nvl
2467: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2468: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
2469: , ROUND (
2470: NVL (
2471: DECODE (

Line 2468: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost

2464: , '1-1' , fact.capitalizable_brdn_cost
2465: , 0 ) -- end decode
2466: , 0 ) -- end nvl
2467: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2468: * PJI_UTILS.GET_MAU (fact.currency_code) capitalizable_brdn_cost
2469: , ROUND (
2470: NVL (
2471: DECODE (
2472: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2484: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2480: , '0-1' , fact.labor_raw_cost
2481: , '1-1' , fact.labor_raw_cost
2482: , 0 ) -- end decode
2483: , 0 ) -- end nvl
2484: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2485: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
2486: , ROUND (
2487: NVL (
2488: DECODE (

Line 2485: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost

2481: , '1-1' , fact.labor_raw_cost
2482: , 0 ) -- end decode
2483: , 0 ) -- end nvl
2484: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2485: * PJI_UTILS.GET_MAU (fact.currency_code) labor_raw_cost
2486: , ROUND (
2487: NVL (
2488: DECODE (
2489: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2501: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2497: , '0-1' , fact.labor_brdn_cost
2498: , '1-1' , fact.labor_brdn_cost
2499: , 0 ) -- end decode
2500: , 0 ) -- end nvl
2501: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2502: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
2503: , ROUND (
2504: NVL (
2505: DECODE (

Line 2502: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost

2498: , '1-1' , fact.labor_brdn_cost
2499: , 0 ) -- end decode
2500: , 0 ) -- end nvl
2501: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2502: * PJI_UTILS.GET_MAU (fact.currency_code) labor_brdn_cost
2503: , ROUND (
2504: NVL (
2505: DECODE (
2506: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2518: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2514: , '0-1' , fact.labor_hrs
2515: , '1-1' , fact.labor_hrs
2516: , 0 ) -- end decode
2517: , 0 ) -- end nvl
2518: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2519: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
2520: , ROUND (
2521: NVL (
2522: DECODE (

Line 2519: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs

2515: , '1-1' , fact.labor_hrs
2516: , 0 ) -- end decode
2517: , 0 ) -- end nvl
2518: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2519: * PJI_UTILS.GET_MAU (fact.currency_code) labor_hrs
2520: , ROUND (
2521: NVL (
2522: DECODE (
2523: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2535: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2531: , '0-1' , fact.labor_revenue
2532: , '1-1' , fact.labor_revenue
2533: , 0 ) -- end decode
2534: , 0 ) -- end nvl
2535: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2536: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
2537: , ROUND (
2538: NVL (
2539: DECODE (

Line 2536: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue

2532: , '1-1' , fact.labor_revenue
2533: , 0 ) -- end decode
2534: , 0 ) -- end nvl
2535: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2536: * PJI_UTILS.GET_MAU (fact.currency_code) labor_revenue
2537: , ROUND (
2538: NVL (
2539: DECODE (
2540: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2552: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2548: , '0-1' , fact.equipment_hours
2549: , '1-1' , fact.equipment_hours
2550: , 0 ) -- end decode
2551: , 0 ) -- end nvl
2552: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2553: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
2554: , ROUND (
2555: NVL (
2556: DECODE (

Line 2553: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours

2549: , '1-1' , fact.equipment_hours
2550: , 0 ) -- end decode
2551: , 0 ) -- end nvl
2552: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2553: * PJI_UTILS.GET_MAU (fact.currency_code) equipment_hours
2554: , ROUND (
2555: NVL (
2556: DECODE (
2557: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2569: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2565: , '0-1' , fact.billable_equipment_hours
2566: , '1-1' , fact.billable_equipment_hours
2567: , 0 ) -- end decode
2568: , 0 ) -- end nvl
2569: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2570: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
2571: , ROUND (
2572: NVL (
2573: DECODE (

Line 2570: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours

2566: , '1-1' , fact.billable_equipment_hours
2567: , 0 ) -- end decode
2568: , 0 ) -- end nvl
2569: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2570: * PJI_UTILS.GET_MAU (fact.currency_code) billable_equipment_hours
2571: , ROUND (
2572: NVL (
2573: DECODE (
2574: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2586: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2582: , '0-1' , fact.sup_inv_committed_cost
2583: , '1-1' , fact.sup_inv_committed_cost
2584: , 0 ) -- end decode
2585: , 0 ) -- end nvl
2586: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2587: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
2588: , ROUND (
2589: NVL (
2590: DECODE (

Line 2587: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost

2583: , '1-1' , fact.sup_inv_committed_cost
2584: , 0 ) -- end decode
2585: , 0 ) -- end nvl
2586: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2587: * PJI_UTILS.GET_MAU (fact.currency_code) sup_inv_committed_cost
2588: , ROUND (
2589: NVL (
2590: DECODE (
2591: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2603: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2599: , '0-1' , fact.po_committed_cost
2600: , '1-1' , fact.po_committed_cost
2601: , 0 ) -- end decode
2602: , 0 ) -- end nvl
2603: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2604: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
2605: , ROUND (
2606: NVL (
2607: DECODE (

Line 2604: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost

2600: , '1-1' , fact.po_committed_cost
2601: , 0 ) -- end decode
2602: , 0 ) -- end nvl
2603: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2604: * PJI_UTILS.GET_MAU (fact.currency_code) po_committed_cost
2605: , ROUND (
2606: NVL (
2607: DECODE (
2608: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2620: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2616: , '0-1' , fact.pr_committed_cost
2617: , '1-1' , fact.pr_committed_cost
2618: , 0 ) -- end decode
2619: , 0 ) -- end nvl
2620: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2621: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
2622: , ROUND (
2623: NVL (
2624: DECODE (

Line 2621: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost

2617: , '1-1' , fact.pr_committed_cost
2618: , 0 ) -- end decode
2619: , 0 ) -- end nvl
2620: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2621: * PJI_UTILS.GET_MAU (fact.currency_code) pr_committed_cost
2622: , ROUND (
2623: NVL (
2624: DECODE (
2625: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2637: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2633: , '0-1' , fact.oth_committed_cost
2634: , '1-1' , fact.oth_committed_cost
2635: , 0 ) -- end decode
2636: , 0 ) -- end nvl
2637: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2638: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
2639: , ROUND (
2640: NVL (
2641: DECODE (

Line 2638: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost

2634: , '1-1' , fact.oth_committed_cost
2635: , 0 ) -- end decode
2636: , 0 ) -- end nvl
2637: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2638: * PJI_UTILS.GET_MAU (fact.currency_code) oth_committed_cost
2639: , ROUND (
2640: NVL (
2641: DECODE (
2642: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2654: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2650: , '0-1' , fact.ACT_LABOR_HRS
2651: , '1-1' , fact.ACT_LABOR_HRS
2652: , 0 ) -- end decode
2653: , 0 ) -- end nvl
2654: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2655: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
2656: , ROUND (
2657: NVL (
2658: DECODE (

Line 2655: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS

2651: , '1-1' , fact.ACT_LABOR_HRS
2652: , 0 ) -- end decode
2653: , 0 ) -- end nvl
2654: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2655: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_HRS
2656: , ROUND (
2657: NVL (
2658: DECODE (
2659: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2671: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2667: , '0-1' , fact.ACT_EQUIP_HRS
2668: , '1-1' , fact.ACT_EQUIP_HRS
2669: , 0 ) -- end decode
2670: , 0 ) -- end nvl
2671: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2672: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
2673: , ROUND (
2674: NVL (
2675: DECODE (

Line 2672: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS

2668: , '1-1' , fact.ACT_EQUIP_HRS
2669: , 0 ) -- end decode
2670: , 0 ) -- end nvl
2671: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2672: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_HRS
2673: , ROUND (
2674: NVL (
2675: DECODE (
2676: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2688: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2684: , '0-1' , fact.ACT_LABOR_BRDN_COST
2685: , '1-1' , fact.ACT_LABOR_BRDN_COST
2686: , 0 ) -- end decode
2687: , 0 ) -- end nvl
2688: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2689: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
2690: , ROUND (
2691: NVL (
2692: DECODE (

Line 2689: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST

2685: , '1-1' , fact.ACT_LABOR_BRDN_COST
2686: , 0 ) -- end decode
2687: , 0 ) -- end nvl
2688: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2689: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_BRDN_COST
2690: , ROUND (
2691: NVL (
2692: DECODE (
2693: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2705: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2701: , '0-1' , fact.ACT_EQUIP_BRDN_COST
2702: , '1-1' , fact.ACT_EQUIP_BRDN_COST
2703: , 0 ) -- end decode
2704: , 0 ) -- end nvl
2705: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2706: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
2707: , ROUND (
2708: NVL (
2709: DECODE (

Line 2706: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST

2702: , '1-1' , fact.ACT_EQUIP_BRDN_COST
2703: , 0 ) -- end decode
2704: , 0 ) -- end nvl
2705: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2706: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_BRDN_COST
2707: , ROUND (
2708: NVL (
2709: DECODE (
2710: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2722: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2718: , '0-1' , fact.ACT_BRDN_COST
2719: , '1-1' , fact.ACT_BRDN_COST
2720: , 0 ) -- end decode
2721: , 0 ) -- end nvl
2722: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2723: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
2724: , ROUND (
2725: NVL (
2726: DECODE (

Line 2723: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST

2719: , '1-1' , fact.ACT_BRDN_COST
2720: , 0 ) -- end decode
2721: , 0 ) -- end nvl
2722: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2723: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_BRDN_COST
2724: , ROUND (
2725: NVL (
2726: DECODE (
2727: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2739: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2735: , '0-1' , fact.ACT_RAW_COST
2736: , '1-1' , fact.ACT_RAW_COST
2737: , 0 ) -- end decode
2738: , 0 ) -- end nvl
2739: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2740: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
2741: , ROUND (
2742: NVL (
2743: DECODE (

Line 2740: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST

2736: , '1-1' , fact.ACT_RAW_COST
2737: , 0 ) -- end decode
2738: , 0 ) -- end nvl
2739: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2740: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_RAW_COST
2741: , ROUND (
2742: NVL (
2743: DECODE (
2744: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2756: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2752: , '0-1' , fact.ACT_REVENUE
2753: , '1-1' , fact.ACT_REVENUE
2754: , 0 ) -- end decode
2755: , 0 ) -- end nvl
2756: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2757: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
2758: , ROUND (
2759: NVL (
2760: DECODE (

Line 2757: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE

2753: , '1-1' , fact.ACT_REVENUE
2754: , 0 ) -- end decode
2755: , 0 ) -- end nvl
2756: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2757: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_REVENUE
2758: , ROUND (
2759: NVL (
2760: DECODE (
2761: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2773: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2769: , '0-1' , fact.ACT_LABOR_RAW_COST
2770: , '1-1' , fact.ACT_LABOR_RAW_COST
2771: , 0 ) -- end decode
2772: , 0 ) -- end nvl
2773: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2774: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
2775: , ROUND (
2776: NVL (
2777: DECODE (

Line 2774: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST

2770: , '1-1' , fact.ACT_LABOR_RAW_COST
2771: , 0 ) -- end decode
2772: , 0 ) -- end nvl
2773: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2774: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_LABOR_RAW_COST
2775: , ROUND (
2776: NVL (
2777: DECODE (
2778: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2790: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2786: , '0-1' , fact.ACT_EQUIP_RAW_COST
2787: , '1-1' , fact.ACT_EQUIP_RAW_COST
2788: , 0 ) -- end decode
2789: , 0 ) -- end nvl
2790: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2791: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
2792: , ROUND (
2793: NVL (
2794: DECODE (

Line 2791: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST

2787: , '1-1' , fact.ACT_EQUIP_RAW_COST
2788: , 0 ) -- end decode
2789: , 0 ) -- end nvl
2790: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2791: * PJI_UTILS.GET_MAU (fact.currency_code) ACT_EQUIP_RAW_COST
2792: , ROUND (
2793: NVL (
2794: DECODE (
2795: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2807: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2803: , '0-1' , fact.ETC_LABOR_HRS
2804: , '1-1' , fact.ETC_LABOR_HRS
2805: , 0 ) -- end decode
2806: , 0 ) -- end nvl
2807: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2808: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
2809: , ROUND (
2810: NVL (
2811: DECODE (

Line 2808: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS

2804: , '1-1' , fact.ETC_LABOR_HRS
2805: , 0 ) -- end decode
2806: , 0 ) -- end nvl
2807: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2808: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_HRS
2809: , ROUND (
2810: NVL (
2811: DECODE (
2812: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2824: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2820: , '0-1' , fact.ETC_EQUIP_HRS
2821: , '1-1' , fact.ETC_EQUIP_HRS
2822: , 0 ) -- end decode
2823: , 0 ) -- end nvl
2824: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2825: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
2826: , ROUND (
2827: NVL (
2828: DECODE (

Line 2825: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS

2821: , '1-1' , fact.ETC_EQUIP_HRS
2822: , 0 ) -- end decode
2823: , 0 ) -- end nvl
2824: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2825: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_HRS
2826: , ROUND (
2827: NVL (
2828: DECODE (
2829: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2841: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2837: , '0-1' , fact.ETC_LABOR_BRDN_COST
2838: , '1-1' , fact.ETC_LABOR_BRDN_COST
2839: , 0 ) -- end decode
2840: , 0 ) -- end nvl
2841: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2842: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
2843: , ROUND (
2844: NVL (
2845: DECODE (

Line 2842: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST

2838: , '1-1' , fact.ETC_LABOR_BRDN_COST
2839: , 0 ) -- end decode
2840: , 0 ) -- end nvl
2841: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2842: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_BRDN_COST
2843: , ROUND (
2844: NVL (
2845: DECODE (
2846: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2858: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2854: , '0-1' , fact.ETC_EQUIP_BRDN_COST
2855: , '1-1' , fact.ETC_EQUIP_BRDN_COST
2856: , 0 ) -- end decode
2857: , 0 ) -- end nvl
2858: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2859: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
2860: , ROUND (
2861: NVL (
2862: DECODE (

Line 2859: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST

2855: , '1-1' , fact.ETC_EQUIP_BRDN_COST
2856: , 0 ) -- end decode
2857: , 0 ) -- end nvl
2858: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2859: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_BRDN_COST
2860: , ROUND (
2861: NVL (
2862: DECODE (
2863: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2875: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2871: , '0-1' , fact.ETC_BRDN_COST
2872: , '1-1' , fact.ETC_BRDN_COST
2873: , 0 ) -- end decode
2874: , 0 ) -- end nvl
2875: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2876: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
2877: , ROUND (
2878: NVL (
2879: DECODE (

Line 2876: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST

2872: , '1-1' , fact.ETC_BRDN_COST
2873: , 0 ) -- end decode
2874: , 0 ) -- end nvl
2875: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2876: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_BRDN_COST
2877: , ROUND (
2878: NVL (
2879: DECODE (
2880: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2892: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2888: , '0-1' , fact.ETC_RAW_COST
2889: , '1-1' , fact.ETC_RAW_COST
2890: , 0 ) -- end decode
2891: , 0 ) -- end nvl
2892: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2893: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
2894: , ROUND (
2895: NVL (
2896: DECODE (

Line 2893: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST

2889: , '1-1' , fact.ETC_RAW_COST
2890: , 0 ) -- end decode
2891: , 0 ) -- end nvl
2892: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2893: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_RAW_COST
2894: , ROUND (
2895: NVL (
2896: DECODE (
2897: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2909: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2905: , '0-1' , fact.ETC_LABOR_RAW_COST
2906: , '1-1' , fact.ETC_LABOR_RAW_COST
2907: , 0 ) -- end decode
2908: , 0 ) -- end nvl
2909: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2910: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
2911: , ROUND (
2912: NVL (
2913: DECODE (

Line 2910: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST

2906: , '1-1' , fact.ETC_LABOR_RAW_COST
2907: , 0 ) -- end decode
2908: , 0 ) -- end nvl
2909: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2910: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_LABOR_RAW_COST
2911: , ROUND (
2912: NVL (
2913: DECODE (
2914: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2926: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2922: , '0-1' , fact.ETC_EQUIP_RAW_COST
2923: , '1-1' , fact.ETC_EQUIP_RAW_COST
2924: , 0 ) -- end decode
2925: , 0 ) -- end nvl
2926: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2927: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
2928: , ROUND (
2929: NVL (
2930: DECODE (

Line 2927: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST

2923: , '1-1' , fact.ETC_EQUIP_RAW_COST
2924: , 0 ) -- end decode
2925: , 0 ) -- end nvl
2926: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2927: * PJI_UTILS.GET_MAU (fact.currency_code) ETC_EQUIP_RAW_COST
2928: , ROUND (
2929: NVL (
2930: DECODE (
2931: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2943: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2939: , '0-1' , fact.custom1
2940: , '1-1' , fact.custom1
2941: , 0 ) -- end decode
2942: , 0 ) -- end nvl
2943: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2944: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
2945: , ROUND (
2946: NVL (
2947: DECODE (

Line 2944: * PJI_UTILS.GET_MAU (fact.currency_code) custom1

2940: , '1-1' , fact.custom1
2941: , 0 ) -- end decode
2942: , 0 ) -- end nvl
2943: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2944: * PJI_UTILS.GET_MAU (fact.currency_code) custom1
2945: , ROUND (
2946: NVL (
2947: DECODE (
2948: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2960: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2956: , '0-1' , fact.custom2
2957: , '1-1' , fact.custom2
2958: , 0 ) -- end decode
2959: , 0 ) -- end nvl
2960: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2961: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
2962: , ROUND (
2963: NVL (
2964: DECODE (

Line 2961: * PJI_UTILS.GET_MAU (fact.currency_code) custom2

2957: , '1-1' , fact.custom2
2958: , 0 ) -- end decode
2959: , 0 ) -- end nvl
2960: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2961: * PJI_UTILS.GET_MAU (fact.currency_code) custom2
2962: , ROUND (
2963: NVL (
2964: DECODE (
2965: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2977: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2973: , '0-1' , fact.custom3
2974: , '1-1' , fact.custom3
2975: , 0 ) -- end decode
2976: , 0 ) -- end nvl
2977: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2978: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
2979: , ROUND (
2980: NVL (
2981: DECODE (

Line 2978: * PJI_UTILS.GET_MAU (fact.currency_code) custom3

2974: , '1-1' , fact.custom3
2975: , 0 ) -- end decode
2976: , 0 ) -- end nvl
2977: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2978: * PJI_UTILS.GET_MAU (fact.currency_code) custom3
2979: , ROUND (
2980: NVL (
2981: DECODE (
2982: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 2994: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

2990: , '0-1' , fact.custom4
2991: , '1-1' , fact.custom4
2992: , 0 ) -- end decode
2993: , 0 ) -- end nvl
2994: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2995: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
2996: , ROUND (
2997: NVL (
2998: DECODE (

Line 2995: * PJI_UTILS.GET_MAU (fact.currency_code) custom4

2991: , '1-1' , fact.custom4
2992: , 0 ) -- end decode
2993: , 0 ) -- end nvl
2994: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
2995: * PJI_UTILS.GET_MAU (fact.currency_code) custom4
2996: , ROUND (
2997: NVL (
2998: DECODE (
2999: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3011: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3007: , '0-1' , fact.custom5
3008: , '1-1' , fact.custom5
3009: , 0 ) -- end decode
3010: , 0 ) -- end nvl
3011: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3012: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
3013: , ROUND (
3014: NVL (
3015: DECODE (

Line 3012: * PJI_UTILS.GET_MAU (fact.currency_code) custom5

3008: , '1-1' , fact.custom5
3009: , 0 ) -- end decode
3010: , 0 ) -- end nvl
3011: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3012: * PJI_UTILS.GET_MAU (fact.currency_code) custom5
3013: , ROUND (
3014: NVL (
3015: DECODE (
3016: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3028: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3024: , '0-1' , fact.custom6
3025: , '1-1' , fact.custom6
3026: , 0 ) -- end decode
3027: , 0 ) -- end nvl
3028: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3029: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
3030: , ROUND (
3031: NVL (
3032: DECODE (

Line 3029: * PJI_UTILS.GET_MAU (fact.currency_code) custom6

3025: , '1-1' , fact.custom6
3026: , 0 ) -- end decode
3027: , 0 ) -- end nvl
3028: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3029: * PJI_UTILS.GET_MAU (fact.currency_code) custom6
3030: , ROUND (
3031: NVL (
3032: DECODE (
3033: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3045: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3041: , '0-1' , fact.custom7
3042: , '1-1' , fact.custom7
3043: , 0 ) -- end decode
3044: , 0 ) -- end nvl
3045: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3046: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
3047: , ROUND (
3048: NVL (
3049: DECODE (

Line 3046: * PJI_UTILS.GET_MAU (fact.currency_code) custom7

3042: , '1-1' , fact.custom7
3043: , 0 ) -- end decode
3044: , 0 ) -- end nvl
3045: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3046: * PJI_UTILS.GET_MAU (fact.currency_code) custom7
3047: , ROUND (
3048: NVL (
3049: DECODE (
3050: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3062: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3058: , '0-1' , fact.custom8
3059: , '1-1' , fact.custom8
3060: , 0 ) -- end decode
3061: , 0 ) -- end nvl
3062: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3063: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
3064: , ROUND (
3065: NVL (
3066: DECODE (

Line 3063: * PJI_UTILS.GET_MAU (fact.currency_code) custom8

3059: , '1-1' , fact.custom8
3060: , 0 ) -- end decode
3061: , 0 ) -- end nvl
3062: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3063: * PJI_UTILS.GET_MAU (fact.currency_code) custom8
3064: , ROUND (
3065: NVL (
3066: DECODE (
3067: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3079: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3075: , '0-1' , fact.custom9
3076: , '1-1' , fact.custom9
3077: , 0 ) -- end decode
3078: , 0 ) -- end nvl
3079: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3080: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
3081: , ROUND (
3082: NVL (
3083: DECODE (

Line 3080: * PJI_UTILS.GET_MAU (fact.currency_code) custom9

3076: , '1-1' , fact.custom9
3077: , 0 ) -- end decode
3078: , 0 ) -- end nvl
3079: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3080: * PJI_UTILS.GET_MAU (fact.currency_code) custom9
3081: , ROUND (
3082: NVL (
3083: DECODE (
3084: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3096: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3092: , '0-1' , fact.custom10
3093: , '1-1' , fact.custom10
3094: , 0 ) -- end decode
3095: , 0 ) -- end nvl
3096: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3097: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
3098: , ROUND (
3099: NVL (
3100: DECODE (

Line 3097: * PJI_UTILS.GET_MAU (fact.currency_code) custom10

3093: , '1-1' , fact.custom10
3094: , 0 ) -- end decode
3095: , 0 ) -- end nvl
3096: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3097: * PJI_UTILS.GET_MAU (fact.currency_code) custom10
3098: , ROUND (
3099: NVL (
3100: DECODE (
3101: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3113: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3109: , '0-1' , fact.custom11
3110: , '1-1' , fact.custom11
3111: , 0 ) -- end decode
3112: , 0 ) -- end nvl
3113: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3114: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
3115: , ROUND (
3116: NVL (
3117: DECODE (

Line 3114: * PJI_UTILS.GET_MAU (fact.currency_code) custom11

3110: , '1-1' , fact.custom11
3111: , 0 ) -- end decode
3112: , 0 ) -- end nvl
3113: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3114: * PJI_UTILS.GET_MAU (fact.currency_code) custom11
3115: , ROUND (
3116: NVL (
3117: DECODE (
3118: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3130: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3126: , '0-1' , fact.custom12
3127: , '1-1' , fact.custom12
3128: , 0 ) -- end decode
3129: , 0 ) -- end nvl
3130: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3131: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
3132: , ROUND (
3133: NVL (
3134: DECODE (

Line 3131: * PJI_UTILS.GET_MAU (fact.currency_code) custom12

3127: , '1-1' , fact.custom12
3128: , 0 ) -- end decode
3129: , 0 ) -- end nvl
3130: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3131: * PJI_UTILS.GET_MAU (fact.currency_code) custom12
3132: , ROUND (
3133: NVL (
3134: DECODE (
3135: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3147: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3143: , '0-1' , fact.custom13
3144: , '1-1' , fact.custom13
3145: , 0 ) -- end decode
3146: , 0 ) -- end nvl
3147: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3148: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
3149: , ROUND (
3150: NVL (
3151: DECODE (

Line 3148: * PJI_UTILS.GET_MAU (fact.currency_code) custom13

3144: , '1-1' , fact.custom13
3145: , 0 ) -- end decode
3146: , 0 ) -- end nvl
3147: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3148: * PJI_UTILS.GET_MAU (fact.currency_code) custom13
3149: , ROUND (
3150: NVL (
3151: DECODE (
3152: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3164: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3160: , '0-1' , fact.custom14
3161: , '1-1' , fact.custom14
3162: , 0 ) -- end decode
3163: , 0 ) -- end nvl
3164: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3165: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
3166: , ROUND (
3167: NVL (
3168: DECODE (

Line 3165: * PJI_UTILS.GET_MAU (fact.currency_code) custom14

3161: , '1-1' , fact.custom14
3162: , 0 ) -- end decode
3163: , 0 ) -- end nvl
3164: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3165: * PJI_UTILS.GET_MAU (fact.currency_code) custom14
3166: , ROUND (
3167: NVL (
3168: DECODE (
3169: ( sign (non_pa_cal.start_date - pa_cal.start_date) || sign (non_pa_cal.end_date - pa_cal.end_date) )

Line 3181: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round

3177: , '0-1' , fact.custom15
3178: , '1-1' , fact.custom15
3179: , 0 ) -- end decode
3180: , 0 ) -- end nvl
3181: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3182: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
3183: , 'CF' line_type
3184: , fact.time_dangling_flag time_dangling_flag
3185: , fact.rate_dangling_flag rate_dangling_flag

Line 3182: * PJI_UTILS.GET_MAU (fact.currency_code) custom15

3178: , '1-1' , fact.custom15
3179: , 0 ) -- end decode
3180: , 0 ) -- end nvl
3181: / PJI_UTILS.GET_MAU (fact.currency_code) ) -- end round
3182: * PJI_UTILS.GET_MAU (fact.currency_code) custom15
3183: , 'CF' line_type
3184: , fact.time_dangling_flag time_dangling_flag
3185: , fact.rate_dangling_flag rate_dangling_flag
3186: FROM pji_fp_aggr_pjp1 fact

Line 3544: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

3540: PROCEDURE PRORATE_TO_ENT_N_PJP1_D IS
3541: BEGIN
3542:
3543: /* Added for bug 13030627 */
3544: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
3545:
3546: PJI_PJP_PRG_PERF_ALL.PRORATE_TO_ENT_N_PJP1_D;
3547:
3548: else

Line 4484: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

4480: PROCEDURE PRORATE_TO_PAGL_PGE_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
4481: BEGIN
4482:
4483: /* Added for bug 13030627 */
4484: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
4485:
4486: PJI_PJP_PRG_PERF_ALL.PRORATE_TO_PAGL_PGE_PJP1_D;
4487:
4488: else

Line 4823: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

4819: PROCEDURE PRORATE_TO_PAGL_N_PJP1_D (p_calendar_type IN VARCHAR2 := NULL) IS
4820: BEGIN
4821:
4822: /* Added for bug 13030627 */
4823: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
4824:
4825: PJI_PJP_PRG_PERF_ALL.PRORATE_TO_PAGL_N_PJP1_D;
4826:
4827: else