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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_RES_LIST_MAP_TMP4

Line 119: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

115: CURSOR budget_line_src_to_cal
116: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE ,
117: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
118:
119: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
120: ra.resource_assignment_id,
121: ra.rate_based_flag,
122: decode(l_txn_currency_flag,
123: 'Y', sbl.txn_currency_code,

Line 152: FROM pa_res_list_map_tmp4 tmp4,

148: NULL,
149: NULL,
150: NULL,
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
152: FROM pa_res_list_map_tmp4 tmp4,
153: pa_budget_lines sbl,
154: pa_resource_assignments ra,
155: pa_tasks ta /* Added for ER 4376722 */
156: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 219: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

215: CURSOR fcst_budget_line_src_to_cal
216: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
217: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
218: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
219: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
220: ra.resource_assignment_id,
221: ra.rate_based_flag,
222: decode(l_txn_currency_flag,
223: 'Y', sbl.txn_currency_code,

Line 252: FROM pa_res_list_map_tmp4 tmp4,

248: NULL,
249: NULL,
250: NULL,
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
252: FROM pa_res_list_map_tmp4 tmp4,
253: pa_budget_lines sbl,
254: pa_resource_assignments ra,
255: pa_tasks ta /* Added for ER 4376722 */
256: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 290: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

286: CURSOR fcst_bdgt_line_src_to_cal_none
287: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
288: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
289: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
290: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
291: ra.resource_assignment_id,
292: ra.rate_based_flag,
293: decode(l_txn_currency_flag,
294: 'Y', sbl.txn_currency_code,

Line 323: FROM pa_res_list_map_tmp4 tmp4,

319: NULL,
320: NULL,
321: NULL,
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
323: FROM pa_res_list_map_tmp4 tmp4,
324: pa_budget_lines sbl,
325: pa_resource_assignments ra,
326: pa_tasks ta /* Added for ER 4376722 */
327: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 883: DELETE from pa_res_list_map_tmp4;

879: /*populating tmp1 with PA_RESOURCE_ASSIGNMENTS*/
880: IF l_fp_cols_rec_source.x_resource_list_id <>
881: l_fp_cols_rec_target.x_resource_list_id THEN
882: DELETE FROM PA_RES_LIST_MAP_TMP1;
883: DELETE from pa_res_list_map_tmp4;
884:
885: -- Bug 3962468: Previously, the code was pulling data for target resource assignments.
886: -- Changed query to get source (l_source_id) resource assignments instead.
887:

Line 1024: SELECT /+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)/

1020: x_return_status,
1021: P_MODULE_NAME => l_module_name);
1022: END IF;
1023:
1024: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
1025: count(*) INTO l_count1
1026: FROM PA_RES_LIST_MAP_TMP4
1027: WHERE RESOURCE_LIST_MEMBER_ID IS NULL AND rownum=1;
1028: IF l_count1 > 0 THEN

Line 1026: FROM PA_RES_LIST_MAP_TMP4

1022: END IF;
1023:
1024: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
1025: count(*) INTO l_count1
1026: FROM PA_RES_LIST_MAP_TMP4
1027: WHERE RESOURCE_LIST_MEMBER_ID IS NULL AND rownum=1;
1028: IF l_count1 > 0 THEN
1029: PA_UTILS.ADD_MESSAGE
1030: (p_app_short_name => 'PA',

Line 1039: from PA_RES_LIST_MAP_TMP4;

1035: IF P_PA_DEBUG_MODE = 'Y' THEN
1036: tmp_rlm_tab.delete;
1037: select distinct resource_list_member_id,txn_task_id
1038: bulk collect into tmp_rlm_tab, tmp_task_tab
1039: from PA_RES_LIST_MAP_TMP4;
1040: for i in 1..tmp_rlm_tab.count loop
1041: pa_fp_gen_amount_utils.fp_debug
1042: (p_called_mode => p_called_mode,
1043: p_msg => 'after res mapping, @@rlm in tmp4:'||tmp_rlm_tab(i)

Line 1082: DELETE from PA_RES_LIST_MAP_TMP4;

1078: -- select count(*) into l_count from pa_resource_assignments where
1079: -- budget_version_id = p_budget_version_id;
1080: -- dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
1081: ELSE
1082: DELETE from PA_RES_LIST_MAP_TMP4;
1083: INSERT INTO PA_RES_LIST_MAP_TMP4( PERSON_ID,
1084: JOB_ID,
1085: ORGANIZATION_ID,
1086: VENDOR_ID,

Line 1083: INSERT INTO PA_RES_LIST_MAP_TMP4( PERSON_ID,

1079: -- budget_version_id = p_budget_version_id;
1080: -- dbms_output.put_line('before calling cre res asg api: res_assign has: '||l_count);
1081: ELSE
1082: DELETE from PA_RES_LIST_MAP_TMP4;
1083: INSERT INTO PA_RES_LIST_MAP_TMP4( PERSON_ID,
1084: JOB_ID,
1085: ORGANIZATION_ID,
1086: VENDOR_ID,
1087: EXPENDITURE_TYPE,

Line 1185: -- select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4;

1181: X_RETURN_STATUS => x_return_status,
1182: X_MSG_COUNT => x_msg_count,
1183: X_MSG_DATA => x_msg_data );
1184:
1185: -- select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4;
1186: -- dbms_output.put_line('after calling cre res asg api, tmp4 has: '||l_count1);
1187: IF P_PA_DEBUG_MODE = 'Y' THEN
1188: pa_fp_gen_amount_utils.fp_debug
1189: ( p_called_mode => p_called_mode,

Line 1249: --select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4

1245: X_RETURN_STATUS => x_return_status,
1246: X_MSG_COUNT => x_msg_count,
1247: X_MSG_DATA => x_msg_data );
1248:
1249: --select count(*) into l_count1 from PA_RES_LIST_MAP_TMP4
1250: --where TXN_RESOURCE_ASSIGNMENT_ID is not null;
1251: --hr_utility.trace('aft call update_res_asg, tmp4 with not null txn_res_asg_id '||l_count1);
1252:
1253: -- select count(*) into l_count from pa_resource_assignments where

Line 1278: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra

1274: SELECT /*+ LEADING(tmp) */
1275: DISTINCT txn_resource_assignment_id
1276: BULK COLLECT
1277: INTO l_tgt_res_asg_id_tab
1278: FROM pa_res_list_map_tmp4 tmp, pa_resource_assignments ra
1279: WHERE tmp.txn_resource_assignment_id = ra.resource_assignment_id
1280: AND ra.rate_based_flag = 'Y'
1281: AND tmp.txn_rate_based_flag = 'N';
1282:

Line 1301: from PA_RES_LIST_MAP_TMP4;

1297: tmp_task_tab.delete;
1298: tmp_ra_tab.delete;
1299: select distinct resource_list_member_id,txn_task_id,txn_resource_assignment_id
1300: bulk collect into tmp_rlm_tab, tmp_task_tab, tmp_ra_tab
1301: from PA_RES_LIST_MAP_TMP4;
1302: for i in 1..tmp_rlm_tab.count loop
1303: pa_fp_gen_amount_utils.fp_debug
1304: (p_called_mode => p_called_mode,
1305: p_msg => 'after update res asg, @@rlm in tmp4:'||tmp_rlm_tab(i)

Line 1326: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

1322: IF l_calling_context = lc_BudgetGeneration THEN
1323: DELETE FROM pa_budget_lines bl
1324: WHERE budget_version_id = p_budget_version_id
1325: AND EXISTS
1326: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1327: FROM pa_res_list_map_tmp4 tmp
1328: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1329: AND rownum = 1 );
1330: ELSIF l_calling_context = lc_ForecastGeneration THEN

Line 1327: FROM pa_res_list_map_tmp4 tmp

1323: DELETE FROM pa_budget_lines bl
1324: WHERE budget_version_id = p_budget_version_id
1325: AND EXISTS
1326: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1327: FROM pa_res_list_map_tmp4 tmp
1328: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1329: AND rownum = 1 );
1330: ELSIF l_calling_context = lc_ForecastGeneration THEN
1331: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE

Line 1337: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

1333: IF l_fp_cols_rec_target.x_time_phased_code IN ('P','G') THEN
1334: DELETE FROM pa_budget_lines bl
1335: WHERE budget_version_id = p_budget_version_id
1336: AND EXISTS
1337: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1338: FROM pa_res_list_map_tmp4 tmp
1339: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1340: AND rownum = 1 )
1341: AND bl.start_date >= l_etc_start_date;

Line 1338: FROM pa_res_list_map_tmp4 tmp

1334: DELETE FROM pa_budget_lines bl
1335: WHERE budget_version_id = p_budget_version_id
1336: AND EXISTS
1337: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1338: FROM pa_res_list_map_tmp4 tmp
1339: WHERE tmp.txn_resource_assignment_id = bl.resource_assignment_id
1340: AND rownum = 1 )
1341: AND bl.start_date >= l_etc_start_date;
1342: END IF;

Line 1379: FROM pa_res_list_map_tmp4;

1375: l_rev_gen_method = 'C' THEN
1376: l_res_asg_uom_update_tab.DELETE;
1377: SELECT DISTINCT txn_resource_assignment_id
1378: BULK COLLECT INTO l_res_asg_uom_update_tab
1379: FROM pa_res_list_map_tmp4;
1380:
1381: FORALL i IN 1..l_res_asg_uom_update_tab.count
1382: UPDATE pa_resource_assignments
1383: SET unit_of_measure = 'DOLLARS',

Line 1464: AND EXISTS (SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/ 1

1460: pa_resource_assignments ra
1461: WHERE bl.budget_version_id = p_budget_version_id
1462: AND ra.budget_version_id = p_budget_version_id
1463: AND bl.resource_assignment_id = ra.resource_assignment_id
1464: AND EXISTS (SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1465: FROM pa_res_list_map_tmp4 tmp4
1466: WHERE ra.resource_assignment_id = tmp4.txn_resource_assignment_id
1467: AND rownum = 1)
1468: and bl.cost_rejection_code is null

Line 1465: FROM pa_res_list_map_tmp4 tmp4

1461: WHERE bl.budget_version_id = p_budget_version_id
1462: AND ra.budget_version_id = p_budget_version_id
1463: AND bl.resource_assignment_id = ra.resource_assignment_id
1464: AND EXISTS (SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1465: FROM pa_res_list_map_tmp4 tmp4
1466: WHERE ra.resource_assignment_id = tmp4.txn_resource_assignment_id
1467: AND rownum = 1)
1468: and bl.cost_rejection_code is null
1469: and bl.revenue_rejection_code is null

Line 1588: SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/

1584: /* Get source resource assignments that map to the current target
1585: * resource assignment into l_mapped_src_res_asg_id_tab. */
1586: l_mapped_src_res_asg_id_tab.delete;
1587:
1588: SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/
1589: tmp.txn_source_id BULK COLLECT INTO l_mapped_src_res_asg_id_tab
1590: FROM pa_res_list_map_tmp4 tmp
1591: WHERE tmp.txn_resource_assignment_id = l_tgt_res_asg_id_tab(i);
1592:

Line 1590: FROM pa_res_list_map_tmp4 tmp

1586: l_mapped_src_res_asg_id_tab.delete;
1587:
1588: SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/
1589: tmp.txn_source_id BULK COLLECT INTO l_mapped_src_res_asg_id_tab
1590: FROM pa_res_list_map_tmp4 tmp
1591: WHERE tmp.txn_resource_assignment_id = l_tgt_res_asg_id_tab(i);
1592:
1593: /* API to get pro-rated amounts for the first source period, which may
1594: * be passed by during source data collection if the target's actual through

Line 2417: FROM pa_res_list_map_tmp4;

2413: l_rev_gen_method = 'C' THEN
2414: l_res_asg_uom_update_tab.DELETE;
2415: SELECT DISTINCT txn_resource_assignment_id
2416: BULK COLLECT INTO l_res_asg_uom_update_tab
2417: FROM pa_res_list_map_tmp4;
2418:
2419: FORALL i IN 1..l_res_asg_uom_update_tab.count
2420: UPDATE pa_resource_assignments
2421: SET unit_of_measure = 'DOLLARS',

Line 2765: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

2761: when target is approved budget version, then take projfunc currency and amts.
2762: Don't pick up amounts for budget lines with non-null rejection codes. */
2763: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2764: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2765: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2766: ra.resource_assignment_id,
2767: ra.rate_based_flag,
2768: sbl.start_date,
2769: sbl.end_date,

Line 2820: FROM pa_res_list_map_tmp4 tmp4,

2816: NULL,
2817: NULL,
2818: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2819: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2820: FROM pa_res_list_map_tmp4 tmp4,
2821: pa_budget_lines sbl,
2822: pa_resource_assignments ra,
2823: pa_tasks ta /* Added for ER 4376722 */
2824: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 2855: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

2851: --Start Changes Bug 6411406
2852: -- Created this cursor for non time phased scenario while generation of budget line.
2853: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2854: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2855: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2856: ra.resource_assignment_id,
2857: ra.rate_based_flag,
2858: ra.planning_start_date,
2859: ra.planning_end_date,

Line 2909: FROM pa_res_list_map_tmp4 tmp4,

2905: NULL,
2906: NULL,
2907: NULL,
2908: NVL(ta.billable_flag,'Y')
2909: FROM pa_res_list_map_tmp4 tmp4,
2910: pa_budget_lines sbl,
2911: pa_resource_assignments ra,
2912: pa_tasks ta
2913: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 2950: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

2946: CURSOR fcst_budget_line_src_tgt
2947: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2948: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2949: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
2950: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2951: ra.resource_assignment_id,
2952: ra.rate_based_flag,
2953: sbl.start_date,
2954: sbl.end_date,

Line 3005: FROM pa_res_list_map_tmp4 tmp4,

3001: NULL,
3002: NULL,
3003: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3004: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3005: FROM pa_res_list_map_tmp4 tmp4,
3006: pa_budget_lines sbl,
3007: pa_resource_assignments ra,
3008: pa_tasks ta /* Added for ER 4376722 */
3009: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 3047: SELECT /+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)/

3043: CURSOR fcst_budget_line_src_tgt_none
3044: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3045: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3046: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3047: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3048: ra.resource_assignment_id,
3049: ra.rate_based_flag,
3050: sbl.start_date,
3051: sbl.end_date,

Line 3102: FROM pa_res_list_map_tmp4 tmp4,

3098: NULL,
3099: NULL,
3100: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3101: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3102: FROM pa_res_list_map_tmp4 tmp4,
3103: pa_budget_lines sbl,
3104: pa_resource_assignments ra,
3105: pa_tasks ta /* Added for ER 4376722 */
3106: WHERE tmp4.txn_source_id = sbl.resource_assignment_id

Line 3499: SELECT /+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N3)/

3495: IF l_same_planning_options_flag = 'Y' THEN
3496:
3497: /* Pick up the source resource assignment attributes.
3498: * The where clause of this query contains the Retain Manual Lines logic. */
3499: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N3)*/
3500: TMP.TXN_RESOURCE_ASSIGNMENT_ID,
3501: RA.RESOURCE_CLASS_FLAG,
3502: RA.RESOURCE_CLASS_CODE,
3503: RA.RES_TYPE_CODE,

Line 3566: PA_RES_LIST_MAP_TMP4 TMP

3562: l_rate_expenditure_type_tab,
3563: l_rate_func_curr_code_tab,
3564: l_org_id_tab
3565: FROM PA_RESOURCE_ASSIGNMENTS RA,
3566: PA_RES_LIST_MAP_TMP4 TMP
3567: WHERE RA.budget_version_id = p_source_bv_id
3568: AND RA.resource_assignment_id = TMP.txn_source_id;
3569:
3570: -- Bug 4621901: When the Target is a Revenue-only version and the Revenue

Line 3664: -- should be distinct in pa_res_list_map_tmp4 because of the one-to-one

3660:
3661: DELETE pa_resource_asgn_curr_tmp;
3662:
3663: -- Note that while (txn_resource_assignment_id, txn_currency_code) pairs
3664: -- should be distinct in pa_res_list_map_tmp4 because of the one-to-one
3665: -- source/target mapping, (txn_resource_assignment_id) by itself is not
3666: -- guaranteed to be unique. Hence, the DISTINCT keyword is required in the
3667: -- query below.
3668:

Line 3676: FROM pa_res_list_map_tmp4;

3672:
3673: INSERT INTO pa_resource_asgn_curr_tmp
3674: ( resource_assignment_id )
3675: SELECT DISTINCT txn_resource_assignment_id
3676: FROM pa_res_list_map_tmp4;
3677:
3678: -- Call the maintenance api in COPY mode
3679: IF p_pa_debug_mode = 'Y' THEN
3680: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 3737: FROM pa_res_list_map_tmp4 tmp4,

3733: FROM pa_resource_asgn_curr rbc
3734: WHERE rbc.budget_version_id = p_target_bv_id
3735: AND rbc.txn_bill_rate_override IS NOT NULL
3736: AND EXISTS ( SELECT null
3737: FROM pa_res_list_map_tmp4 tmp4,
3738: pa_resource_assignments ra,
3739: pa_tasks ta
3740: WHERE rbc.resource_assignment_id = tmp4.txn_resource_assignment_id
3741: AND tmp4.txn_resource_assignment_id = ra.resource_assignment_id

Line 3793: ( SELECT /+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)/ 1

3789: SET spread_curve_id = NULL,
3790: sp_fixed_date = NULL
3791: WHERE budget_version_id = p_target_bv_id
3792: AND EXISTS
3793: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
3794: FROM pa_res_list_map_tmp4 tmp
3795: WHERE tmp.txn_resource_assignment_id = resource_assignment_id
3796: AND rownum = 1 );
3797:

Line 3794: FROM pa_res_list_map_tmp4 tmp

3790: sp_fixed_date = NULL
3791: WHERE budget_version_id = p_target_bv_id
3792: AND EXISTS
3793: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
3794: FROM pa_res_list_map_tmp4 tmp
3795: WHERE tmp.txn_resource_assignment_id = resource_assignment_id
3796: AND rownum = 1 );
3797:
3798: END IF; -- end updating resource assignment attributes

Line 4918: FROM pa_res_list_map_tmp4;

4914: IF l_fp_cols_rec_target.x_version_type = 'REVENUE' and l_rev_gen_method = 'C' THEN
4915: l_res_asg_uom_update_tab.DELETE;
4916: SELECT DISTINCT txn_resource_assignment_id
4917: BULK COLLECT INTO l_res_asg_uom_update_tab
4918: FROM pa_res_list_map_tmp4;
4919:
4920: FORALL i IN 1..l_res_asg_uom_update_tab.count
4921: UPDATE pa_resource_assignments
4922: SET unit_of_measure = 'DOLLARS',

Line 5474: pa_res_list_map_tmp4 tmp4

5470: rbc.txn_bill_rate_override
5471: FROM pa_resource_assignments ra,
5472: pa_budget_lines bl,
5473: pa_resource_asgn_curr rbc,
5474: pa_res_list_map_tmp4 tmp4
5475: WHERE ra.budget_version_id = p_target_bv_id
5476: AND ra.project_id = p_project_id
5477: AND ra.resource_assignment_id = tmp4.txn_resource_assignment_id
5478: AND bl.resource_assignment_id = ra.resource_assignment_id