APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RESOURCE_CLASSES_B

Line 98: l_resource_class_id PA_RESOURCE_CLASSES_B.RESOURCE_CLASS_ID%TYPE;

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

Line 369: FROM PA_RESOURCE_CLASSES_B

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

Line 404: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc

400: l_SYS_LINK_FUNCTION_tab,
401: l_INVENTORY_ITEM_ID_tab,
402: l_FC_RES_TYPE_CODE_tab,
403: l_RESOURCE_CLASS_CODE_tab
404: FROM PA_COMMITMENT_TXNS ct, PA_RESOURCE_CLASSES_B rc
405: WHERE ct.PROJECT_ID = P_PROJECT_ID
406: AND NVL(CT.generation_error_flag,'N') = 'N'
407: AND ct.RESOURCE_CLASS = rc.RESOURCE_CLASS_CODE(+);
408: --dbms_output.put_line('l_TXN_SOURCE_ID_tab.count: '||l_TXN_SOURCE_ID_tab.count);