APPS.ASO_BI_APPR_FACT_PVT dependencies on ASO_BI_QUOTE_IDS

Line 102: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);

98: l_login_id := FND_GLOBAL.login_id;
99:
100: --Delete the modified approvals
101: DELETE FROM ASO_BI_APR_F FACT
102: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);
103:
104: --insert statement
105: INSERT INTO ASO_BI_APR_F
106: (

Line 152: ASO_BI_QUOTE_IDS QID

148: l_login_id
149: FROM ASO_BI_QUOTE_HDRS_ALL QOT,
150: ASO_APR_OBJ_APPROVALS APR,
151: ASO_APR_APPROVAL_DETAILS APRD,
152: ASO_BI_QUOTE_IDS QID
153: WHERE
154: QOT.quote_header_id = APR.object_id
155: AND APR.object_type = 'Quote'
156: AND QID.quote_header_id = APR.object_id

Line 272: WHERE FACT.Quote_header_id IN (SELECT Quote_header_id FROM ASO_BI_QUOTE_IDS);

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
276: (

Line 320: ASO_BI_QUOTE_IDS QID

316: l_login_id
317: FROM
318: ASO_BI_APR_F APRF,
319: ASO_APR_RULES RUL,
320: ASO_BI_QUOTE_IDS QID
321: WHERE
322: APRF.Object_approval_id = RUL.Object_approval_id
323: AND QID.Quote_header_id = APRF.Quote_header_id;
324: