DBA Data[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on QP_CURRENCY_LISTS_TL

Line 5431: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt

5427: AND qpih.currency_header_id is NOT NULL
5428: AND qpih.currency_header is NOT NULL
5429: AND qpih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5430: AND NOT EXISTS ( SELECT qpclb.currency_header_id
5431: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt
5432: WHERE qpclb.currency_header_id = qpih.currency_header_id
5433: AND qpclb.base_currency_code = qpih.currency_code
5434: AND qpclt.currency_header_id = qpclb.currency_header_id
5435: AND qpclt.language = nvl(qpih.language,'US')

Line 5457: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt

5453: AND qpih.currency_header is NOT NULL
5454: AND qpih.currency_header <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5455: AND qpih.currency_header_id is NULL
5456: AND NOT EXISTS ( SELECT qpclb.currency_header_id
5457: FROM qp_currency_lists_b qpclb, qp_currency_lists_tl qpclt
5458: WHERE qpclb.base_currency_code = qpih.currency_code
5459: AND qpclt.currency_header_id = qpclb.currency_header_id
5460: AND qpclt.language = nvl(qpih.language,'US')
5461: AND qpclt.name = qpih.currency_header);