DBA Data[Home] [Help]

APPS.ASO_BI_APPR_FACT_PVT dependencies on ASO_BI_APR_RUL_F

Line 201: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_RUL_F FACT

197: l_user_id := FND_GLOBAL.user_id;
198: l_login_id := FND_GLOBAL.login_id;
199:
200: --insert statement
201: INSERT /*+ APPEND PARALLEL(FACT) */ INTO ASO_BI_APR_RUL_F FACT
202: (
203: QUOTE_NUMBER,
204: QUOTE_VERSION,
205: QUOTE_HEADER_ID,

Line 271: DELETE FROM ASO_BI_APR_RUL_F FACT

267: l_user_id := FND_GLOBAL.user_id;
268: l_login_id := FND_GLOBAL.login_id;
269:
270: --Delete the modified approvals
271: DELETE FROM ASO_BI_APR_RUL_F FACT
272: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);
273:
274: --insert statement
275: INSERT INTO ASO_BI_APR_RUL_F

Line 275: INSERT INTO ASO_BI_APR_RUL_F

271: DELETE FROM ASO_BI_APR_RUL_F FACT
272: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);
273:
274: --insert statement
275: INSERT INTO ASO_BI_APR_RUL_F
276: (
277: QUOTE_NUMBER,
278: QUOTE_VERSION,
279: QUOTE_HEADER_ID,