APPS.ASO_VALIDATE_PVT dependencies on FND_CURRENCIES

Line 5665: FROM Fnd_currencies d

5661: CURSOR C_QOTHDDET_CURRENCY_NOT_NULL(p_currency_code varchar2,p_price_list_id varchar2) is
5662: SELECT 1 FROM DUAL WHERE exists
5663: (
5664: SELECT d.currency_code currency_code
5665: FROM Fnd_currencies d
5666: ,qp_currency_details b
5667: ,qp_list_headers_b c
5668: WHERE c.list_header_id = p_price_list_id
5669: AND b.currency_header_id = c.currency_header_id

Line 5680: FROM fnd_currencies b,qp_list_headers_b c

5676: and trunc(sysdate) between trunc(nvl(b.start_date_active,sysdate)) and trunc(nvl(b.end_date_active,sysdate))
5677: AND d.currency_code = p_currency_code
5678: UNION
5679: SELECT b.currency_code currency_code
5680: FROM fnd_currencies b,qp_list_headers_b c
5681: WHERE c.currency_code = b.currency_code
5682: AND c.list_header_id = p_price_list_id
5683: AND c.list_type_code IN ('PRL', 'AGR')
5684: AND b.currency_flag = 'Y'

Line 5695: FROM fnd_currencies b

5691: CURSOR C_QOTHDDET_CURRENCY_NULL(p_currency_code varchar2) is
5692: SELECT 1 FROM DUAL WHERE exists
5693: (
5694: SELECT b.currency_code
5695: FROM fnd_currencies b
5696: WHERE b.currency_flag = 'Y'
5697: AND b.enabled_flag = 'Y'
5698: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate))
5699: and b.currency_code = p_currency_code