APPS.PA_FP_GEN_COMMITMENT_AMOUNTS dependencies on PA_RES_LIST_MAP_TMP1

Line 363: DELETE FROM PA_RES_LIST_MAP_TMP1;

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

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

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