APPS.PA_FP_GEN_FCST_AMT_PUB3 dependencies on PA_FP_CALC_AMT_TMP1

Line 199: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/

195: ELSIF p_fp_cols_tgt_rec.X_PLAN_IN_MULTI_CURR_FLAG = 'N' THEN
196: l_currency_flag := 'PC';
197: ELSIF l_rate_based_flag = 'N' THEN
198: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
199: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
200: DISTINCT act_tmp.txn_currency_code
201: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
202: PA_FP_CALC_AMT_TMP1 tot_tmp
203: WHERE act_tmp.project_element_id = tot_tmp.task_id

Line 202: PA_FP_CALC_AMT_TMP1 tot_tmp

198: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
199: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
200: DISTINCT act_tmp.txn_currency_code
201: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
202: PA_FP_CALC_AMT_TMP1 tot_tmp
203: WHERE act_tmp.project_element_id = tot_tmp.task_id
204: AND act_tmp.res_list_member_id = tot_tmp.resource_list_member_id
205: AND tot_tmp.target_res_asg_id = p_tgt_res_asg_id
206: AND data_type_code = DECODE(P_ETC_SOURCE_CODE,

Line 1368: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/

1364: * P_WP_PLANNING_OPTIONS_FLAG = Y
1365: * P_FP_PLANNING_OPTIONS_FLAG = N */
1366:
1367: CURSOR src_tgt_cur_wp_opt_same IS
1368: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1369: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1370: tmp.resource_assignment_id src_res_asg_id
1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1372: PA_FP_CALC_AMT_TMP2 tmp

Line 1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1367: CURSOR src_tgt_cur_wp_opt_same IS
1368: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1369: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1370: tmp.resource_assignment_id src_res_asg_id
1371: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1372: PA_FP_CALC_AMT_TMP2 tmp
1373: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1374: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1375: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES'

Line 1377: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/

1373: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1374: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1375: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES'
1376: UNION ALL
1377: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1378: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1379: NULL src_res_asg_id
1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1381: PA_FP_CALC_AMT_TMP2 tmp

Line 1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1376: UNION ALL
1377: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1378: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1379: NULL src_res_asg_id
1380: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1381: PA_FP_CALC_AMT_TMP2 tmp
1382: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1383: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1384: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN';

Line 1393: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/

1389: * P_WP_PLANNING_OPTIONS_FLAG = N
1390: * P_FP_PLANNING_OPTIONS_FLAG = Y */
1391:
1392: CURSOR src_tgt_cur_fp_opt_same IS
1393: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1394: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1395: tmp.resource_assignment_id src_res_asg_id
1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1397: PA_FP_CALC_AMT_TMP2 tmp

Line 1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1392: CURSOR src_tgt_cur_fp_opt_same IS
1393: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1394: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1395: tmp.resource_assignment_id src_res_asg_id
1396: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1397: PA_FP_CALC_AMT_TMP2 tmp
1398: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1399: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1400: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN'

Line 1402: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/

1398: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1399: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1400: AND tmp_ra.transaction_source_code = 'FINANCIAL_PLAN'
1401: UNION ALL
1402: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1403: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1404: NULL src_res_asg_id
1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1406: PA_FP_CALC_AMT_TMP2 tmp

Line 1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,

1401: UNION ALL
1402: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
1403: DISTINCT tmp.target_res_asg_id tgt_res_asg_id,
1404: NULL src_res_asg_id
1405: FROM PA_FP_CALC_AMT_TMP1 tmp_ra,
1406: PA_FP_CALC_AMT_TMP2 tmp
1407: WHERE tmp.TRANSACTION_SOURCE_CODE = 'TOTAL_ETC'
1408: AND tmp_ra.target_res_asg_id = tmp.target_res_asg_id
1409: AND tmp_ra.transaction_source_code = 'WORKPLAN_RESOURCES';

Line 2588: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/

2584: ELSIF p_fp_cols_tgt_rec.X_PLAN_IN_MULTI_CURR_FLAG = 'N' THEN
2585: l_currency_flag := 'PC';
2586: ELSIF l_rate_based_flag = 'N' THEN
2587: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
2588: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2589: DISTINCT act_tmp.txn_currency_code
2590: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
2591: PA_FP_CALC_AMT_TMP1 tot_tmp
2592: WHERE act_tmp.project_element_id = tot_tmp.task_id

Line 2591: PA_FP_CALC_AMT_TMP1 tot_tmp

2587: SELECT COUNT(*) INTO l_currency_count_for_flag FROM (
2588: SELECT /*+ INDEX(act_tmp,PA_FP_FCST_GEN_TMP1_N1) INDEX(tot_tmp,PA_FP_CALC_AMT_TMP1_N1)*/
2589: DISTINCT act_tmp.txn_currency_code
2590: FROM PA_FP_FCST_GEN_TMP1 act_tmp,
2591: PA_FP_CALC_AMT_TMP1 tot_tmp
2592: WHERE act_tmp.project_element_id = tot_tmp.task_id
2593: AND act_tmp.res_list_member_id = tot_tmp.resource_list_member_id
2594: AND tot_tmp.target_res_asg_id = l_tgt_res_asg_id
2595: AND data_type_code = DECODE(L_ETC_SOURCE_CODE,