APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_COMMITMENT_TXNS

Line 37: FROM PA_COMMITMENT_TXNS CT,

33: ,NVL(CT.PROJ_BURDENED_COST,0) tot_proj_burdened_cost
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

Line 404: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc

400: l_SYS_LINK_FUNCTION_tab,
401: l_INVENTORY_ITEM_ID_tab,
402: l_FC_RES_TYPE_CODE_tab,
403: l_RESOURCE_CLASS_CODE_tab
404: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc
405: WHERE ct.PROJECT_ID = P_PROJECT_ID
406: AND NVL(CT.generation_error_flag,'N') = 'N'
407: AND ct.RESOURCE_CLASS = rc.RESOURCE_CLASS_CODE(+);
408: --dbms_output.put_line('l_TXN_SOURCE_ID_tab.count: '||l_TXN_SOURCE_ID_tab.count);