APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RES_LIST_MAP_TMP1

Line 362: DELETE FROM PA_RES_LIST_MAP_TMP1;

358:
359:
360: --dbms_output.put_line('Value for struct sharing code [' || l_stru_sharing_code || ']');
361: /* deleting the PJI resource mapping tmp tables. */
362: DELETE FROM PA_RES_LIST_MAP_TMP1;
363: DELETE FROM PA_RES_LIST_MAP_TMP2;
364: DELETE FROM PA_RES_LIST_MAP_TMP3;
365: DELETE FROM PA_RES_LIST_MAP_TMP4;
366:

Line 374: --dbms_output.put_line('inserting into PA_RES_LIST_MAP_TMP1 P_PROJECT_ID is [' || to_char(P_PROJECT_ID) || ']');

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:
374: --dbms_output.put_line('inserting into PA_RES_LIST_MAP_TMP1 P_PROJECT_ID is [' || to_char(P_PROJECT_ID) || ']');
375: SELECT ct.CMT_LINE_ID,
376: 'OPEN_COMMITMENTS',
377: ct.ORGANIZATION_ID,
378: ct.VENDOR_ID,