APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on QP_LIST_HEADERS_B

Line 11184: --to query qp_list_headers_b with active_flag

11180: ) IS
11181: l_dummy VARCHAR2(1);
11182: BEGIN
11183: --Bug Fix 2262616, changed the query, which was lookong at SO_PRICE_LISTS
11184: --to query qp_list_headers_b with active_flag
11185: /**************************************************************************
11186: SELECT 'Y' INTO l_dummy
11187: FROM SO_PRICE_LISTS pl
11188: WHERE pl.price_list_id = p_column_value

Line 11193: FROM qp_list_headers_b lh

11189: AND sysdate between nvl(pl.start_date_active,sysdate) and nvl(pl.end_date_active,sysdate);
11190: ***************************************************************************/
11191: SELECT 'Y'
11192: INTO l_dummy
11193: FROM qp_list_headers_b lh
11194: WHERE list_header_id = p_column_value
11195: AND list_type_code = 'PRL'
11196: AND (sysdate between nvl(lh.start_date_active,sysdate) and nvl(lh.end_date_active,sysdate)
11197: AND nvl(active_flag, 'N') = 'Y');

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

11200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11201: FND_MESSAGE.SET_TOKEN( 'FK', 'price_list_id' );
11202: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11203: -- Bug 3591694 FND_MESSAGE.SET_TOKEN( 'TABLE', 'SO_PRICE_LISTS' );
11204: FND_MESSAGE.SET_TOKEN( 'TABLE', 'QP_LIST_HEADERS_B' );
11205:
11206: FND_MSG_PUB.ADD;
11207: x_return_status := FND_API.G_RET_STS_ERROR;
11208: END check_price_list_fk;