DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on RA_TERMS

Line 5343: FROM RA_TERMS

5339: AND qpih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5340: --Bug#5248659 RAVI
5341: --Use Term_id not terms_id
5342: AND NOT EXISTS (SELECT TERM_ID
5343: FROM RA_TERMS
5344: WHERE TERM_ID = qpih.terms_id
5345: AND name = qpih.terms
5346: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5347: AND nvl(end_date_active, sysdate) );

Line 5369: FROM RA_TERMS

5365: AND qpih.terms IS NULL
5366: --Bug#5248659 RAVI
5367: --Use Term_id not terms_id
5368: AND NOT EXISTS (SELECT TERM_ID
5369: FROM RA_TERMS
5370: WHERE TERM_ID = qpih.terms_id
5371: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5372: AND nvl(end_date_active, sysdate) );
5373:

Line 5395: FROM RA_TERMS

5391: AND qpih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5392: --Bug#5248659 RAVI
5393: --Use Term_id not terms_id
5394: AND NOT EXISTS (SELECT TERM_ID
5395: FROM RA_TERMS
5396: WHERE name = qpih.terms
5397: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5398: AND nvl(end_date_active, sysdate) );
5399: