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 407: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc

403: l_INVENTORY_ITEM_ID_tab,
404: l_FC_RES_TYPE_CODE_tab,
405: l_RESOURCE_CLASS_CODE_tab,
406: l_cbs_element_id_tab --bug#16827157
407: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc
408: WHERE ct.PROJECT_ID = P_PROJECT_ID
409: AND NVL(CT.generation_error_flag,'N') = 'N'
410: AND ct.RESOURCE_CLASS = rc.RESOURCE_CLASS_CODE(+);
411: --dbms_output.put_line('l_TXN_SOURCE_ID_tab.count: '||l_TXN_SOURCE_ID_tab.count);