APPS.PA_FP_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_CLASSES_B

Line 120: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;

116:
117: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
118: l_chk_duplicate_flag VARCHAR2(1) := 'N';
119:
120: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
121:
122: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
123: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
124: l_total_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 206: FROM PA_RESOURCE_CLASSES_B

202: DELETE FROM PA_RES_LIST_MAP_TMP1;
203:
204: SELECT RESOURCE_CLASS_ID
205: INTO l_resource_class_id
206: FROM PA_RESOURCE_CLASSES_B
207: WHERE RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS';
208:
209: SELECT ct.CMT_LINE_ID,
210: 'OPEN_COMMITMENTS',

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: