DBA Data[Home] [Help]

APPS.AP_APPROVAL_PKG dependencies on AP_TEMP_APPROVAL_GT

Line 11083: DELETE FROM ap_temp_approval_gt;

11079: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'Populate ap_temp_approval_temp_gt');
11080: END IF;
11081: ---------------------------------------------------------------------
11082:
11083: DELETE FROM ap_temp_approval_gt;
11084:
11085: FORALL i in g_org_holds.first..g_org_holds.last
11086: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);
11087:

Line 11086: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);

11082:
11083: DELETE FROM ap_temp_approval_gt;
11084:
11085: FORALL i in g_org_holds.first..g_org_holds.last
11086: INSERT INTO ap_temp_approval_gt VALUES g_org_holds(i);
11087:
11088: COMMIT;
11089:
11090: ---------------------------------------------------------------------

Line 11102: FROM ap_temp_approval_gt

11098: END IF;
11099: ---------------------------------------------------------------------
11100:
11101: SELECT count(*) into p_report_holds_count
11102: FROM ap_temp_approval_gt
11103: WHERE number_holds_placed <> 0
11104: OR number_holds_released <> 0;
11105:
11106: -- 7512258