DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on QP_LIST_HEADERS_B

Line 5651: ,qp_list_headers_b c

5647: (
5648: SELECT d.currency_code currency_code
5649: FROM Fnd_currencies d
5650: ,qp_currency_details b
5651: ,qp_list_headers_b c
5652: WHERE c.list_header_id = p_price_list_id
5653: AND b.currency_header_id = c.currency_header_id
5654: AND d.currency_code = b.to_currency_code
5655: AND c.list_type_code IN ('PRL', 'AGR')

Line 5664: FROM fnd_currencies b,qp_list_headers_b c

5660: and trunc(sysdate) between trunc(nvl(b.start_date_active,sysdate)) and trunc(nvl(b.end_date_active,sysdate))
5661: AND d.currency_code = p_currency_code
5662: UNION
5663: SELECT b.currency_code currency_code
5664: FROM fnd_currencies b,qp_list_headers_b c
5665: WHERE c.currency_code = b.currency_code
5666: AND c.list_header_id = p_price_list_id
5667: AND c.list_type_code IN ('PRL', 'AGR')
5668: AND b.currency_flag = 'Y'