APPS.PA_FP_COMMITMENT_AMOUNTS dependencies on PA_COMMITMENT_TXNS

Line 50: FROM PA_COMMITMENT_TXNS CT,

46: ,SUM(NVL(CT.TOT_CMT_QUANTITY,
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

Line 238: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc

234: l_SYS_LINK_FUNCTION_tab,
235: l_INVENTORY_ITEM_ID_tab,
236: l_FC_RES_TYPE_CODE_tab,
237: l_RESOURCE_CLASS_CODE_tab
238: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc
239: WHERE ct.PROJECT_ID = P_PROJECT_ID
240: AND NVL(CT.generation_error_flag,'N') = 'N'
241: AND ct.RESOURCE_CLASS = rc.RESOURCE_CLASS_CODE(+);
242:

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: