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.PA_FP_GEN_FCST_AMT_PUB1 dependencies on PA_FP_CALC_AMT_TMP2

Line 1571: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1567: IF P_ETC_SOURCE_CODE = 'FINANCIAL_PLAN' THEN
1568: l_currency_flag := 'PC';
1569: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
1570:
1571: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1572: COUNT(DISTINCT TXN_CURRENCY_CODE)
1573: INTO l_currency_count_tot
1574: FROM PA_FP_CALC_AMT_TMP2
1575: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1574: FROM PA_FP_CALC_AMT_TMP2

1570:
1571: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1572: COUNT(DISTINCT TXN_CURRENCY_CODE)
1573: INTO l_currency_count_tot
1574: FROM PA_FP_CALC_AMT_TMP2
1575: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1576: AND ETC_CURRENCY_CODE IS NULL;
1577:
1578: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/

Line 1597: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1593:
1594: IF l_currency_count_tot = 1
1595: AND l_currency_count_act = 1
1596: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1597: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1598: DISTINCT TXN_CURRENCY_CODE
1599: INTO l_currency_code_tot
1600: FROM PA_FP_CALC_AMT_TMP2
1601: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1600: FROM PA_FP_CALC_AMT_TMP2

1596: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1597: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1598: DISTINCT TXN_CURRENCY_CODE
1599: INTO l_currency_code_tot
1600: FROM PA_FP_CALC_AMT_TMP2
1601: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1602: AND ETC_CURRENCY_CODE IS NULL;
1603:
1604: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/

Line 1620: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1616: ELSIF l_currency_count_tot = 1
1617: AND l_currency_count_act = 0
1618: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1619: l_currency_flag := 'TC';
1620: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1621: DISTINCT TXN_CURRENCY_CODE
1622: INTO l_etc_currency_code
1623: FROM PA_FP_CALC_AMT_TMP2
1624: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1623: FROM PA_FP_CALC_AMT_TMP2

1619: l_currency_flag := 'TC';
1620: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1621: DISTINCT TXN_CURRENCY_CODE
1622: INTO l_etc_currency_code
1623: FROM PA_FP_CALC_AMT_TMP2
1624: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1625: AND ETC_CURRENCY_CODE IS NULL;
1626: ELSIF l_currency_count_tot = 0
1627: AND l_currency_count_act = 1

Line 1640: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1636: AND data_type_code = P_ETC_SOURCE_CODE;
1637: END IF;
1638:
1639: BEGIN
1640: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1641: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
1642: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
1643: 'PC', TOTAL_PC_RAW_COST), 0)),
1644: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 1649: FROM PA_FP_CALC_AMT_TMP2

1645: 'PC', TOTAL_PC_BURDENED_COST),0))
1646: INTO l_tot_qty,
1647: l_tot_txn_raw_cost,
1648: l_tot_txn_brdn_cost
1649: FROM PA_FP_CALC_AMT_TMP2
1650: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1651: AND ETC_CURRENCY_CODE IS NULL;
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN

Line 1773: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1769: nvl(l_eqpmt_act_rawcost_pc,0) +
1770: nvl(l_oth_act_rawcost_pc,0);
1771:
1772: /*getting total*/
1773: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1774: COUNT(DISTINCT TXN_CURRENCY_CODE)
1775: INTO l_currency_count_tot
1776: FROM PA_FP_CALC_AMT_TMP2
1777: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1776: FROM PA_FP_CALC_AMT_TMP2

1772: /*getting total*/
1773: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1774: COUNT(DISTINCT TXN_CURRENCY_CODE)
1775: INTO l_currency_count_tot
1776: FROM PA_FP_CALC_AMT_TMP2
1777: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1778: AND ETC_CURRENCY_CODE IS NULL;
1779:
1780: IF l_currency_count_tot = 1

Line 1782: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1778: AND ETC_CURRENCY_CODE IS NULL;
1779:
1780: IF l_currency_count_tot = 1
1781: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1782: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1783: DISTINCT TXN_CURRENCY_CODE
1784: INTO l_currency_code_tot
1785: FROM PA_FP_CALC_AMT_TMP2
1786: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1785: FROM PA_FP_CALC_AMT_TMP2

1781: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1782: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1783: DISTINCT TXN_CURRENCY_CODE
1784: INTO l_currency_code_tot
1785: FROM PA_FP_CALC_AMT_TMP2
1786: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1787: AND ETC_CURRENCY_CODE IS NULL;
1788:
1789: IF l_currency_code_tot = l_txn_currency_code OR

Line 1804: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1800: END IF;
1801: END IF;
1802:
1803: BEGIN
1804: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1805: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
1806: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
1807: 'PC', TOTAL_PC_RAW_COST), 0)),
1808: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 1813: FROM PA_FP_CALC_AMT_TMP2

1809: 'PC', TOTAL_PC_BURDENED_COST),0))
1810: INTO l_tot_qty,
1811: l_tot_txn_raw_cost,
1812: l_tot_txn_brdn_cost
1813: FROM PA_FP_CALC_AMT_TMP2
1814: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1815: AND ETC_CURRENCY_CODE IS NULL;
1816: EXCEPTION
1817: WHEN NO_DATA_FOUND THEN

Line 1842: INSERT INTO PA_FP_CALC_AMT_TMP2

1838: hr_utility.trace('etc rc '||l_etc_txn_raw_cost );
1839: hr_utility.trace('etc bc '||l_etc_txn_brdn_cost ); */
1840:
1841: IF l_etc_qty <> 0 OR l_etc_txn_raw_cost <> 0 OR l_etc_txn_brdn_cost <> 0 THEN
1842: INSERT INTO PA_FP_CALC_AMT_TMP2
1843: (RESOURCE_ASSIGNMENT_ID,
1844: ETC_CURRENCY_CODE,
1845: ETC_PLAN_QUANTITY,
1846: ETC_TXN_RAW_COST,

Line 2042: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2038: */
2039: l_currency_flag := 'PC';
2040: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
2041:
2042: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2043: COUNT(DISTINCT TXN_CURRENCY_CODE)
2044: INTO l_currency_count_tot
2045: FROM PA_FP_CALC_AMT_TMP2
2046: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2045: FROM PA_FP_CALC_AMT_TMP2

2041:
2042: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2043: COUNT(DISTINCT TXN_CURRENCY_CODE)
2044: INTO l_currency_count_tot
2045: FROM PA_FP_CALC_AMT_TMP2
2046: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2047: AND ETC_CURRENCY_CODE IS NULL;
2048:
2049: /* SELECT COUNT(DISTINCT TXN_CURRENCY_CODE)

Line 2066: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2062: END IF;
2063:
2064: IF l_currency_count_tot = 1 AND
2065: p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2066: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2067: DISTINCT TXN_CURRENCY_CODE
2068: INTO l_currency_code_tot
2069: FROM PA_FP_CALC_AMT_TMP2
2070: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2069: FROM PA_FP_CALC_AMT_TMP2

2065: p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2066: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2067: DISTINCT TXN_CURRENCY_CODE
2068: INTO l_currency_code_tot
2069: FROM PA_FP_CALC_AMT_TMP2
2070: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2071: AND ETC_CURRENCY_CODE IS NULL;
2072: l_currency_flag := 'TC';
2073: l_etc_currency_code := l_currency_code_tot;

Line 2080: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2076: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
2077: END IF;
2078:
2079: BEGIN
2080: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2081: SUM(NVL(TOTAL_PLAN_QUANTITY,0)),
2082: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
2083: 'PC', TOTAL_PC_RAW_COST),0)),
2084: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 2089: FROM PA_FP_CALC_AMT_TMP2

2085: 'PC', TOTAL_PC_BURDENED_COST),0))
2086: INTO l_tot_qty,
2087: l_tot_txn_raw_cost,
2088: l_tot_txn_brdn_cost
2089: FROM PA_FP_CALC_AMT_TMP2
2090: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2091: AND ETC_CURRENCY_CODE IS NULL;
2092: EXCEPTION
2093: WHEN NO_DATA_FOUND THEN

Line 2112: INSERT INTO PA_FP_CALC_AMT_TMP2

2108: l_etc_txn_raw_cost := l_tot_txn_raw_cost - (l_percent_complete*l_tot_txn_raw_cost);
2109: l_etc_txn_brdn_cost := l_tot_txn_brdn_cost - (l_percent_complete*l_tot_txn_brdn_cost);
2110:
2111: IF l_etc_qty <> 0 OR l_etc_txn_raw_cost <> 0 OR l_etc_txn_brdn_cost <> 0 THEN
2112: INSERT INTO PA_FP_CALC_AMT_TMP2
2113: (RESOURCE_ASSIGNMENT_ID,
2114: ETC_CURRENCY_CODE,
2115: ETC_PLAN_QUANTITY,
2116: ETC_TXN_RAW_COST,

Line 2482: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2478: l_txn_currency_code_act := l_txn_currency_code;
2479: END IF;
2480:
2481: /*Getting TOTAL in both TXN and PROJ currencies*/
2482: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2483: COUNT(DISTINCT TXN_CURRENCY_CODE)
2484: INTO l_txn_currency_count_tot
2485: FROM PA_FP_CALC_AMT_TMP2
2486: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2485: FROM PA_FP_CALC_AMT_TMP2

2481: /*Getting TOTAL in both TXN and PROJ currencies*/
2482: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2483: COUNT(DISTINCT TXN_CURRENCY_CODE)
2484: INTO l_txn_currency_count_tot
2485: FROM PA_FP_CALC_AMT_TMP2
2486: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2487: AND ETC_CURRENCY_CODE IS NULL;
2488:
2489: IF l_txn_currency_count_tot = 1

Line 2492: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2488:
2489: IF l_txn_currency_count_tot = 1
2490: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2491: l_tot_txn_pc_flag := 'TC';
2492: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2493: DISTINCT TXN_CURRENCY_CODE
2494: INTO l_txn_currency_code_tot
2495: FROM PA_FP_CALC_AMT_TMP2
2496: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2495: FROM PA_FP_CALC_AMT_TMP2

2491: l_tot_txn_pc_flag := 'TC';
2492: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2493: DISTINCT TXN_CURRENCY_CODE
2494: INTO l_txn_currency_code_tot
2495: FROM PA_FP_CALC_AMT_TMP2
2496: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2497: AND ETC_CURRENCY_CODE IS NULL;
2498:
2499: BEGIN

Line 2500: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2496: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2497: AND ETC_CURRENCY_CODE IS NULL;
2498:
2499: BEGIN
2500: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2501: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
2502: SUM(NVL(TOTAL_TXN_RAW_COST,0)),
2503: SUM(NVL(TOTAL_TXN_BURDENED_COST,0)),
2504: SUM(NVL(TOTAL_PC_RAW_COST, 0)),

Line 2511: FROM PA_FP_CALC_AMT_TMP2

2507: l_tot_txn_raw_cost,
2508: l_tot_txn_brdn_cost,
2509: l_tot_pc_raw_cost,
2510: l_tot_pc_brdn_cost
2511: FROM PA_FP_CALC_AMT_TMP2
2512: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2513: AND ETC_CURRENCY_CODE IS NULL;
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN

Line 2525: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

2521: END;
2522: ELSE
2523: l_tot_txn_pc_flag := 'PC';
2524: BEGIN
2525: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2526: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
2527: SUM(NVL(TOTAL_PC_RAW_COST,0)),
2528: SUM(NVL(TOTAL_PC_BURDENED_COST,0))
2529: INTO l_tot_qty,

Line 2532: FROM PA_FP_CALC_AMT_TMP2

2528: SUM(NVL(TOTAL_PC_BURDENED_COST,0))
2529: INTO l_tot_qty,
2530: l_tot_pc_raw_cost,
2531: l_tot_pc_brdn_cost
2532: FROM PA_FP_CALC_AMT_TMP2
2533: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2534: AND ETC_CURRENCY_CODE IS NULL;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN

Line 2581: INSERT INTO PA_FP_CALC_AMT_TMP2

2577: END IF;
2578: END IF;
2579:
2580: IF l_etc_qty <> 0 OR l_etc_raw_cost <> 0 OR l_etc_brdn_cost <> 0 THEN
2581: INSERT INTO PA_FP_CALC_AMT_TMP2
2582: (RESOURCE_ASSIGNMENT_ID,
2583: ETC_CURRENCY_CODE,
2584: ETC_PLAN_QUANTITY,
2585: ETC_TXN_RAW_COST,

Line 2749: l_transaction_source_code PA_FP_CALC_AMT_TMP2.transaction_source_code%TYPE;

2745: l_msg_data VARCHAR2(2000);
2746: l_data VARCHAR2(2000);
2747: l_msg_index_out NUMBER:=0;
2748: l_sysdate DATE;
2749: l_transaction_source_code PA_FP_CALC_AMT_TMP2.transaction_source_code%TYPE;
2750: BEGIN
2751: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2752: X_MSG_COUNT := 0;
2753: l_sysdate := trunc(sysdate);

Line 2977: INSERT INTO PA_FP_CALC_AMT_TMP2 (

2973: END IF;
2974: END LOOP;
2975: END IF;
2976: /*not used in work_qty
2977: INSERT INTO PA_FP_CALC_AMT_TMP2 (
2978: RESOURCE_ASSIGNMENT_ID,
2979: TXN_CURRENCY_CODE,
2980: TOTAL_PLAN_QUANTITY,
2981: TOTAL_TXN_RAW_COST,

Line 2998: INSERT INTO PA_FP_CALC_AMT_TMP2 (

2994: l_transaction_source_code := 'TOTAL_ETC';
2995: ELSE
2996: l_transaction_source_code := 'ETC';
2997: END IF;
2998: INSERT INTO PA_FP_CALC_AMT_TMP2 (
2999: RESOURCE_ASSIGNMENT_ID,
3000: ETC_CURRENCY_CODE,
3001: ETC_PLAN_QUANTITY,
3002: ETC_TXN_RAW_COST,

Line 4981: PA_FP_CALC_AMT_TMP2 tmp2

4977: -- for etc_method_code
4978: SELECT tmp1.etc_method_code
4979: INTO l_etc_method_code
4980: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4981: PA_FP_CALC_AMT_TMP2 tmp2
4982: WHERE tmp1.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4983: AND tmp2.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4984: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
4985: AND tmp1.target_res_asg_id = tmp2.target_res_asg_id

Line 5001: PA_FP_CALC_AMT_TMP2 tmp2

4997: ,tmp2.actual_work_qty
4998: INTO l_etc_plan_qty
4999: ,l_act_work_qty
5000: FROM PA_FP_CALC_AMT_TMP1 tmp1,
5001: PA_FP_CALC_AMT_TMP2 tmp2
5002: WHERE tmp1.resource_assignment_id = ((-1) * l_task_id_tab(kk))
5003: AND tmp2.resource_assignment_id = ((-1) * l_task_id_tab(kk))
5004: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
5005: AND tmp1.mapped_fin_task_id = l_task_id_tab(kk)