DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on RA_TERMS

Line 5355: FROM RA_TERMS

5351: AND qpih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5352: --Bug#5248659 RAVI
5353: --Use Term_id not terms_id
5354: AND NOT EXISTS (SELECT TERM_ID
5355: FROM RA_TERMS
5356: WHERE TERM_ID = qpih.terms_id
5357: AND name = qpih.terms
5358: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5359: AND nvl(end_date_active, sysdate) );

Line 5381: FROM RA_TERMS

5377: AND qpih.terms IS NULL
5378: --Bug#5248659 RAVI
5379: --Use Term_id not terms_id
5380: AND NOT EXISTS (SELECT TERM_ID
5381: FROM RA_TERMS
5382: WHERE TERM_ID = qpih.terms_id
5383: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5384: AND nvl(end_date_active, sysdate) );
5385:

Line 5407: FROM RA_TERMS

5403: AND qpih.terms <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5404: --Bug#5248659 RAVI
5405: --Use Term_id not terms_id
5406: AND NOT EXISTS (SELECT TERM_ID
5407: FROM RA_TERMS
5408: WHERE name = qpih.terms
5409: AND sysdate BETWEEN nvl(start_date_active, sysdate)
5410: AND nvl(end_date_active, sysdate) );
5411: