APPS.PA_FP_COMMITMENT_AMOUNTS dependencies on PA_RES_LIST_MAP_TMP4

Line 25: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/

21: ,c_set_of_books_id PA_IMPLEMENTATIONS_ALL.SET_OF_BOOKS_ID%TYPE
22: ,c_org_id PA_PROJECTS_ALL.ORG_ID%TYPE
23: )
24: IS
25: SELECT /*+ INDEX(TMP,PA_RES_LIST_MAP_TMP4_N2)*/
26: P.RESOURCE_ASSIGNMENT_ID
27: ,TMP.TXN_TASK_ID
28: ,TMP.RESOURCE_LIST_MEMBER_ID
29: ,DECODE(c_multi_curr_flag, 'Y',

Line 51: PA_RES_LIST_MAP_TMP4 TMP,

47: DECODE(c_multi_curr_flag, 'Y',
48: CT.DENOM_RAW_COST,
49: CT.PROJ_RAW_COST)) ) tot_quantity
50: FROM PA_COMMITMENT_TXNS CT,
51: PA_RES_LIST_MAP_TMP4 TMP,
52: PA_RESOURCE_ASSIGNMENTS P
53: WHERE TMP.TXN_SOURCE_ID = CT.CMT_LINE_ID
54: AND CT.PROJECT_ID = P_PROJECT_ID
55: AND NVL(CT.generation_error_flag,'N') = 'N'

Line 341: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/

337: pa_resource_mapping.g_called_process :='PLAN'; --Bug 9753875
338:
339: --dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);
340:
341: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
342: count(*) INTO l_count1
343: FROM PA_RES_LIST_MAP_TMP4
344: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
345: IF l_count1 > 0 THEN

Line 343: FROM PA_RES_LIST_MAP_TMP4

339: --dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);
340:
341: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
342: count(*) INTO l_count1
343: FROM PA_RES_LIST_MAP_TMP4
344: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
345: IF l_count1 > 0 THEN
346: PA_UTILS.ADD_MESSAGE
347: (p_app_short_name => 'PA',

Line 438: --FROM PA_RES_LIST_MAP_TMP4;

434: CLOSE SUM_COMM_CRSR;
435: --dbms_output.put_line('l_res_asg_id.count: '||l_res_asg_id.count);
436:
437: --SELECT count(*) INTO l_tmp4
438: --FROM PA_RES_LIST_MAP_TMP4;
439:
440: --dbms_output.put_line('res_map_Tmp4 table count: '|| l_tmp4);
441:
442: INSERT INTO PA_FP_CALC_AMT_TMP1(

Line 504: FROM PA_RES_LIST_MAP_TMP4 TMP4, PA_COMMITMENT_TXNS CT

500: TMP4.NAMED_ROLE,
501: TMP4.TXN_ETC_METHOD_CODE,
502: TMP4.RESOURCE_LIST_MEMBER_ID,
503: TMP4.TXN_TASK_ID
504: FROM PA_RES_LIST_MAP_TMP4 TMP4, PA_COMMITMENT_TXNS CT
505: WHERE CT.CMT_LINE_ID = TMP4.TXN_SOURCE_ID;
506:
507: --dbms_output.put_line('calc_tmp1 table count: '||sql%rowcount);
508: