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 1548: SELECT /+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)/

1544: IF P_ETC_SOURCE_CODE = 'FINANCIAL_PLAN' THEN
1545: l_currency_flag := 'PC';
1546: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
1547:
1548: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1549: COUNT(DISTINCT TXN_CURRENCY_CODE)
1550: INTO l_currency_count_tot
1551: FROM PA_FP_CALC_AMT_TMP2
1552: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1551: FROM PA_FP_CALC_AMT_TMP2

1547:
1548: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1549: COUNT(DISTINCT TXN_CURRENCY_CODE)
1550: INTO l_currency_count_tot
1551: FROM PA_FP_CALC_AMT_TMP2
1552: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1553: AND ETC_CURRENCY_CODE IS NULL;
1554:
1555: SELECT /*+ INDEX(PA_FP_FCST_GEN_TMP1,PA_FP_FCST_GEN_TMP1_N1)*/

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

1570:
1571: IF l_currency_count_tot = 1
1572: AND l_currency_count_act = 1
1573: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1574: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1575: DISTINCT TXN_CURRENCY_CODE
1576: INTO l_currency_code_tot
1577: FROM PA_FP_CALC_AMT_TMP2
1578: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1577: FROM PA_FP_CALC_AMT_TMP2

1573: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1574: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1575: DISTINCT TXN_CURRENCY_CODE
1576: INTO l_currency_code_tot
1577: FROM PA_FP_CALC_AMT_TMP2
1578: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1579: AND ETC_CURRENCY_CODE IS NULL;
1580:
1581: 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: ELSIF l_currency_count_tot = 1
1594: AND l_currency_count_act = 0
1595: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1596: l_currency_flag := 'TC';
1597: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1598: DISTINCT TXN_CURRENCY_CODE
1599: INTO l_etc_currency_code
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: l_currency_flag := 'TC';
1597: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1598: DISTINCT TXN_CURRENCY_CODE
1599: INTO l_etc_currency_code
1600: FROM PA_FP_CALC_AMT_TMP2
1601: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1602: AND ETC_CURRENCY_CODE IS NULL;
1603: ELSIF l_currency_count_tot = 0
1604: AND l_currency_count_act = 1

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

1613: AND data_type_code = P_ETC_SOURCE_CODE;
1614: END IF;
1615:
1616: BEGIN
1617: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1618: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
1619: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
1620: 'PC', TOTAL_PC_RAW_COST), 0)),
1621: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 1626: FROM PA_FP_CALC_AMT_TMP2

1622: 'PC', TOTAL_PC_BURDENED_COST),0))
1623: INTO l_tot_qty,
1624: l_tot_txn_raw_cost,
1625: l_tot_txn_brdn_cost
1626: FROM PA_FP_CALC_AMT_TMP2
1627: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1628: AND ETC_CURRENCY_CODE IS NULL;
1629: EXCEPTION
1630: WHEN NO_DATA_FOUND THEN

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

1746: nvl(l_eqpmt_act_rawcost_pc,0) +
1747: nvl(l_oth_act_rawcost_pc,0);
1748:
1749: /*getting total*/
1750: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1751: COUNT(DISTINCT TXN_CURRENCY_CODE)
1752: INTO l_currency_count_tot
1753: FROM PA_FP_CALC_AMT_TMP2
1754: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1753: FROM PA_FP_CALC_AMT_TMP2

1749: /*getting total*/
1750: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1751: COUNT(DISTINCT TXN_CURRENCY_CODE)
1752: INTO l_currency_count_tot
1753: FROM PA_FP_CALC_AMT_TMP2
1754: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1755: AND ETC_CURRENCY_CODE IS NULL;
1756:
1757: IF l_currency_count_tot = 1

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

1755: AND ETC_CURRENCY_CODE IS NULL;
1756:
1757: IF l_currency_count_tot = 1
1758: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1759: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1760: DISTINCT TXN_CURRENCY_CODE
1761: INTO l_currency_code_tot
1762: FROM PA_FP_CALC_AMT_TMP2
1763: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 1762: FROM PA_FP_CALC_AMT_TMP2

1758: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
1759: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1760: DISTINCT TXN_CURRENCY_CODE
1761: INTO l_currency_code_tot
1762: FROM PA_FP_CALC_AMT_TMP2
1763: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1764: AND ETC_CURRENCY_CODE IS NULL;
1765:
1766: IF l_currency_code_tot = l_txn_currency_code OR

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

1777: END IF;
1778: END IF;
1779:
1780: BEGIN
1781: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
1782: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
1783: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
1784: 'PC', TOTAL_PC_RAW_COST), 0)),
1785: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 1790: FROM PA_FP_CALC_AMT_TMP2

1786: 'PC', TOTAL_PC_BURDENED_COST),0))
1787: INTO l_tot_qty,
1788: l_tot_txn_raw_cost,
1789: l_tot_txn_brdn_cost
1790: FROM PA_FP_CALC_AMT_TMP2
1791: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
1792: AND ETC_CURRENCY_CODE IS NULL;
1793: EXCEPTION
1794: WHEN NO_DATA_FOUND THEN

Line 1819: INSERT INTO PA_FP_CALC_AMT_TMP2

1815: hr_utility.trace('etc rc '||l_etc_txn_raw_cost );
1816: hr_utility.trace('etc bc '||l_etc_txn_brdn_cost ); */
1817:
1818: IF l_etc_qty <> 0 OR l_etc_txn_raw_cost <> 0 OR l_etc_txn_brdn_cost <> 0 THEN
1819: INSERT INTO PA_FP_CALC_AMT_TMP2
1820: (RESOURCE_ASSIGNMENT_ID,
1821: ETC_CURRENCY_CODE,
1822: ETC_PLAN_QUANTITY,
1823: ETC_TXN_RAW_COST,

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

2015: */
2016: l_currency_flag := 'PC';
2017: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
2018:
2019: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2020: COUNT(DISTINCT TXN_CURRENCY_CODE)
2021: INTO l_currency_count_tot
2022: FROM PA_FP_CALC_AMT_TMP2
2023: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2022: FROM PA_FP_CALC_AMT_TMP2

2018:
2019: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2020: COUNT(DISTINCT TXN_CURRENCY_CODE)
2021: INTO l_currency_count_tot
2022: FROM PA_FP_CALC_AMT_TMP2
2023: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2024: AND ETC_CURRENCY_CODE IS NULL;
2025:
2026: /* SELECT COUNT(DISTINCT TXN_CURRENCY_CODE)

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

2039: END IF;
2040:
2041: IF l_currency_count_tot = 1 AND
2042: p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2043: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2044: DISTINCT TXN_CURRENCY_CODE
2045: INTO l_currency_code_tot
2046: FROM PA_FP_CALC_AMT_TMP2
2047: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2046: FROM PA_FP_CALC_AMT_TMP2

2042: p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2043: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2044: DISTINCT TXN_CURRENCY_CODE
2045: INTO l_currency_code_tot
2046: FROM PA_FP_CALC_AMT_TMP2
2047: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2048: AND ETC_CURRENCY_CODE IS NULL;
2049: l_currency_flag := 'TC';
2050: l_etc_currency_code := l_currency_code_tot;

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

2053: l_etc_currency_code := P_FP_COLS_REC.x_project_currency_code;
2054: END IF;
2055:
2056: BEGIN
2057: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2058: SUM(NVL(TOTAL_PLAN_QUANTITY,0)),
2059: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_RAW_COST,
2060: 'PC', TOTAL_PC_RAW_COST),0)),
2061: SUM(NVL(DECODE(l_currency_flag, 'TC', TOTAL_TXN_BURDENED_COST,

Line 2066: FROM PA_FP_CALC_AMT_TMP2

2062: 'PC', TOTAL_PC_BURDENED_COST),0))
2063: INTO l_tot_qty,
2064: l_tot_txn_raw_cost,
2065: l_tot_txn_brdn_cost
2066: FROM PA_FP_CALC_AMT_TMP2
2067: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2068: AND ETC_CURRENCY_CODE IS NULL;
2069: EXCEPTION
2070: WHEN NO_DATA_FOUND THEN

Line 2089: INSERT INTO PA_FP_CALC_AMT_TMP2

2085: l_etc_txn_raw_cost := l_tot_txn_raw_cost - (l_percent_complete*l_tot_txn_raw_cost);
2086: l_etc_txn_brdn_cost := l_tot_txn_brdn_cost - (l_percent_complete*l_tot_txn_brdn_cost);
2087:
2088: IF l_etc_qty <> 0 OR l_etc_txn_raw_cost <> 0 OR l_etc_txn_brdn_cost <> 0 THEN
2089: INSERT INTO PA_FP_CALC_AMT_TMP2
2090: (RESOURCE_ASSIGNMENT_ID,
2091: ETC_CURRENCY_CODE,
2092: ETC_PLAN_QUANTITY,
2093: ETC_TXN_RAW_COST,

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

2455: l_txn_currency_code_act := l_txn_currency_code;
2456: END IF;
2457:
2458: /*Getting TOTAL in both TXN and PROJ currencies*/
2459: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2460: COUNT(DISTINCT TXN_CURRENCY_CODE)
2461: INTO l_txn_currency_count_tot
2462: FROM PA_FP_CALC_AMT_TMP2
2463: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2462: FROM PA_FP_CALC_AMT_TMP2

2458: /*Getting TOTAL in both TXN and PROJ currencies*/
2459: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2460: COUNT(DISTINCT TXN_CURRENCY_CODE)
2461: INTO l_txn_currency_count_tot
2462: FROM PA_FP_CALC_AMT_TMP2
2463: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2464: AND ETC_CURRENCY_CODE IS NULL;
2465:
2466: IF l_txn_currency_count_tot = 1

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

2465:
2466: IF l_txn_currency_count_tot = 1
2467: AND p_fp_cols_rec.x_plan_in_multi_curr_flag = 'Y' THEN
2468: l_tot_txn_pc_flag := 'TC';
2469: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2470: DISTINCT TXN_CURRENCY_CODE
2471: INTO l_txn_currency_code_tot
2472: FROM PA_FP_CALC_AMT_TMP2
2473: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID

Line 2472: FROM PA_FP_CALC_AMT_TMP2

2468: l_tot_txn_pc_flag := 'TC';
2469: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2470: DISTINCT TXN_CURRENCY_CODE
2471: INTO l_txn_currency_code_tot
2472: FROM PA_FP_CALC_AMT_TMP2
2473: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2474: AND ETC_CURRENCY_CODE IS NULL;
2475:
2476: BEGIN

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

2473: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2474: AND ETC_CURRENCY_CODE IS NULL;
2475:
2476: BEGIN
2477: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2478: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
2479: SUM(NVL(TOTAL_TXN_RAW_COST,0)),
2480: SUM(NVL(TOTAL_TXN_BURDENED_COST,0)),
2481: SUM(NVL(TOTAL_PC_RAW_COST, 0)),

Line 2488: FROM PA_FP_CALC_AMT_TMP2

2484: l_tot_txn_raw_cost,
2485: l_tot_txn_brdn_cost,
2486: l_tot_pc_raw_cost,
2487: l_tot_pc_brdn_cost
2488: FROM PA_FP_CALC_AMT_TMP2
2489: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2490: AND ETC_CURRENCY_CODE IS NULL;
2491: EXCEPTION
2492: WHEN NO_DATA_FOUND THEN

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

2498: END;
2499: ELSE
2500: l_tot_txn_pc_flag := 'PC';
2501: BEGIN
2502: SELECT /*+ INDEX(PA_FP_CALC_AMT_TMP2,PA_FP_CALC_AMT_TMP2_N2)*/
2503: SUM(NVL(TOTAL_PLAN_QUANTITY, 0)),
2504: SUM(NVL(TOTAL_PC_RAW_COST,0)),
2505: SUM(NVL(TOTAL_PC_BURDENED_COST,0))
2506: INTO l_tot_qty,

Line 2509: FROM PA_FP_CALC_AMT_TMP2

2505: SUM(NVL(TOTAL_PC_BURDENED_COST,0))
2506: INTO l_tot_qty,
2507: l_tot_pc_raw_cost,
2508: l_tot_pc_brdn_cost
2509: FROM PA_FP_CALC_AMT_TMP2
2510: WHERE RESOURCE_ASSIGNMENT_ID = P_RESOURCE_ASSIGNMENT_ID
2511: AND ETC_CURRENCY_CODE IS NULL;
2512: EXCEPTION
2513: WHEN NO_DATA_FOUND THEN

Line 2558: INSERT INTO PA_FP_CALC_AMT_TMP2

2554: END IF;
2555: END IF;
2556:
2557: IF l_etc_qty <> 0 OR l_etc_raw_cost <> 0 OR l_etc_brdn_cost <> 0 THEN
2558: INSERT INTO PA_FP_CALC_AMT_TMP2
2559: (RESOURCE_ASSIGNMENT_ID,
2560: ETC_CURRENCY_CODE,
2561: ETC_PLAN_QUANTITY,
2562: ETC_TXN_RAW_COST,

Line 2726: l_transaction_source_code PA_FP_CALC_AMT_TMP2.transaction_source_code%TYPE;

2722: l_msg_data VARCHAR2(2000);
2723: l_data VARCHAR2(2000);
2724: l_msg_index_out NUMBER:=0;
2725: l_sysdate DATE;
2726: l_transaction_source_code PA_FP_CALC_AMT_TMP2.transaction_source_code%TYPE;
2727: BEGIN
2728: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2729: X_MSG_COUNT := 0;
2730: l_sysdate := trunc(sysdate);

Line 2954: INSERT INTO PA_FP_CALC_AMT_TMP2 (

2950: END IF;
2951: END LOOP;
2952: END IF;
2953: /*not used in work_qty
2954: INSERT INTO PA_FP_CALC_AMT_TMP2 (
2955: RESOURCE_ASSIGNMENT_ID,
2956: TXN_CURRENCY_CODE,
2957: TOTAL_PLAN_QUANTITY,
2958: TOTAL_TXN_RAW_COST,

Line 2975: INSERT INTO PA_FP_CALC_AMT_TMP2 (

2971: l_transaction_source_code := 'TOTAL_ETC';
2972: ELSE
2973: l_transaction_source_code := 'ETC';
2974: END IF;
2975: INSERT INTO PA_FP_CALC_AMT_TMP2 (
2976: RESOURCE_ASSIGNMENT_ID,
2977: ETC_CURRENCY_CODE,
2978: ETC_PLAN_QUANTITY,
2979: ETC_TXN_RAW_COST,

Line 4956: PA_FP_CALC_AMT_TMP2 tmp2

4952: -- for etc_method_code
4953: SELECT tmp1.etc_method_code
4954: INTO l_etc_method_code
4955: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4956: PA_FP_CALC_AMT_TMP2 tmp2
4957: WHERE tmp1.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4958: AND tmp2.TARGET_RES_ASG_ID = l_ra_id_tbl_1(kk)
4959: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
4960: AND tmp1.target_res_asg_id = tmp2.target_res_asg_id

Line 4976: PA_FP_CALC_AMT_TMP2 tmp2

4972: ,tmp2.actual_work_qty
4973: INTO l_etc_plan_qty
4974: ,l_act_work_qty
4975: FROM PA_FP_CALC_AMT_TMP1 tmp1,
4976: PA_FP_CALC_AMT_TMP2 tmp2
4977: WHERE tmp1.resource_assignment_id = ((-1) * l_task_id_tab(kk))
4978: AND tmp2.resource_assignment_id = ((-1) * l_task_id_tab(kk))
4979: AND tmp1.resource_assignment_id = tmp2.resource_assignment_id
4980: AND tmp1.mapped_fin_task_id = l_task_id_tab(kk)