DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on QP_CURRENCY_LISTS_TL

Line 5443: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt

5439: AND qpih.currency_header_id is NOT NULL
5440: AND qpih.currency_header is NOT NULL
5441: AND qpih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5442: AND NOT EXISTS ( SELECT qpclb.currency_header_id
5443: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt
5444: WHERE qpclb.currency_header_id = qpih.currency_header_id
5445: AND qpclb.base_currency_code = qpih.currency_code
5446: AND qpclt.currency_header_id = qpclb.currency_header_id
5447: AND qpclt.language = nvl(qpih.language,'US')

Line 5469: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt

5465: AND qpih.currency_header is NOT NULL
5466: AND qpih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5467: AND qpih.currency_header_id is NULL
5468: AND NOT EXISTS ( SELECT qpclb.currency_header_id
5469: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt
5470: WHERE qpclb.base_currency_code = qpih.currency_code
5471: AND qpclt.currency_header_id = qpclb.currency_header_id
5472: AND qpclt.language = nvl(qpih.language,'US')
5473: AND qpclt.name = qpih.currency_header);