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 504: FROM PA_RES_LIST_MAP_TMP4 TMP4, PA_COMMITMENT_TXNS CT

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