APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_CLASSES_B

Line 99: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;

95:
96: l_gen_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
97: l_chk_duplicate_flag VARCHAR2(1) := 'N';
98:
99: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;
100:
101: l_bl_start_date DATE;
102: l_bl_end_date DATE;
103: l_bl_period_name pa_periods_all.period_name%TYPE;

Line 370: FROM PA_RESOURCE_CLASSES_B

366: DELETE FROM PA_RES_LIST_MAP_TMP4;
367:
368: SELECT RESOURCE_CLASS_ID
369: INTO l_resource_class_id
370: FROM PA_RESOURCE_CLASSES_B
371: WHERE RESOURCE_CLASS_CODE = 'FINANCIAL_ELEMENTS';
372:
373: --dbms_output.put_line('Value for res class id [' || to_char(l_resource_class_id) || ']');
374:

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);