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 337: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/

333: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
334: END IF;
335: --dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);
336:
337: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
338: count(*) INTO l_count1
339: FROM PA_RES_LIST_MAP_TMP4
340: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
341: IF l_count1 > 0 THEN

Line 339: FROM PA_RES_LIST_MAP_TMP4

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

Line 434: --FROM PA_RES_LIST_MAP_TMP4;

430: CLOSE SUM_COMM_CRSR;
431: --dbms_output.put_line('l_res_asg_id.count: '||l_res_asg_id.count);
432:
433: --SELECT count(*) INTO l_tmp4
434: --FROM PA_RES_LIST_MAP_TMP4;
435:
436: --dbms_output.put_line('res_map_Tmp4 table count: '|| l_tmp4);
437:
438: INSERT INTO PA_FP_CALC_AMT_TMP1(

Line 500: FROM PA_RES_LIST_MAP_TMP4 TMP4, PA_COMMITMENT_TXNS CT

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