APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on QP_LIST_HEADERS_B

Line 11475: --to query qp_list_headers_b with active_flag

11471: ) IS
11472: l_dummy VARCHAR2(1);
11473: BEGIN
11474: --Bug Fix 2262616, changed the query, which was lookong at SO_PRICE_LISTS
11475: --to query qp_list_headers_b with active_flag
11476: /**************************************************************************
11477: SELECT 'Y' INTO l_dummy
11478: FROM SO_PRICE_LISTS pl
11479: WHERE pl.price_list_id = p_column_value

Line 11484: FROM qp_list_headers_b lh

11480: AND sysdate between nvl(pl.start_date_active,sysdate) and nvl(pl.end_date_active,sysdate);
11481: ***************************************************************************/
11482: SELECT 'Y'
11483: INTO l_dummy
11484: FROM qp_list_headers_b lh
11485: WHERE list_header_id = p_column_value
11486: AND list_type_code = 'PRL'
11487: AND (sysdate between nvl(lh.start_date_active,sysdate) and nvl(lh.end_date_active,sysdate)
11488: AND nvl(active_flag, 'N') = 'Y');

Line 11495: FND_MESSAGE.SET_TOKEN( 'TABLE', 'QP_LIST_HEADERS_B' );

11491: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11492: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
11493: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11494: -- Bug 3591694 FND_MESSAGE.SET_TOKEN( 'TABLE', 'SO_PRICE_LISTS' );
11495: FND_MESSAGE.SET_TOKEN( 'TABLE', 'QP_LIST_HEADERS_B' );
11496:
11497: FND_MSG_PUB.ADD;
11498: x_return_status := FND_API.G_RET_STS_ERROR;
11499: END check_price_list_fk;