APPS.PA_FP_GEN_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: ,DECODE(c_multi_curr_flag, 'Y', CT.DENOM_CURRENCY_CODE,CT.PROJECT_CURRENCY_CODE) currency_code
28: ,NVL(CT.CMT_NEED_BY_DATE,CT.EXPENDITURE_ITEM_DATE)
29: ,NVL(CT.CMT_NEED_BY_DATE,CT.EXPENDITURE_ITEM_DATE)

Line 38: PA_RES_LIST_MAP_TMP4 TMP,

34: ,NVL(CT.ACCT_RAW_COST,0) tot_projfunc_raw_cost
35: ,NVL(CT.ACCT_BURDENED_COST,0) tot_projfunc_burdened_cost
36: ,NVL(CT.TOT_CMT_QUANTITY,0) tot_quantity
37: FROM PA_COMMITMENT_TXNS CT,
38: PA_RES_LIST_MAP_TMP4 TMP,
39: PA_RESOURCE_ASSIGNMENTS P
40: WHERE TMP.TXN_SOURCE_ID = CT.CMT_LINE_ID
41: AND CT.PROJECT_ID = P_PROJECT_ID
42: AND NVL(CT.generation_error_flag,'N') = 'N'

Line 365: DELETE FROM PA_RES_LIST_MAP_TMP4;

361: /* deleting the PJI resource mapping tmp tables. */
362: DELETE FROM PA_RES_LIST_MAP_TMP1;
363: DELETE FROM PA_RES_LIST_MAP_TMP2;
364: DELETE FROM PA_RES_LIST_MAP_TMP3;
365: DELETE FROM PA_RES_LIST_MAP_TMP4;
366:
367: SELECT RESOURCE_CLASS_ID
368: INTO l_resource_class_id
369: FROM PA_RESOURCE_CLASSES_B

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

500: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
501: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
502: END IF;
503:
504: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
505: count(*) INTO l_count1
506: FROM PA_RES_LIST_MAP_TMP4
507: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
508: IF l_count1 > 0 THEN

Line 506: FROM PA_RES_LIST_MAP_TMP4

502: END IF;
503:
504: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
505: count(*) INTO l_count1
506: FROM PA_RES_LIST_MAP_TMP4
507: WHERE RESOURCE_LIST_MEMBER_ID IS NULL and rownum=1;
508: IF l_count1 > 0 THEN
509: PA_UTILS.ADD_MESSAGE
510: (p_app_short_name => 'PA',