DBA Data[Home] [Help]

APPS.ASO_VALIDATE_PVT dependencies on FND_CURRENCIES

Line 5649: FROM Fnd_currencies d

5645: CURSOR C_QOTHDDET_CURRENCY_NOT_NULL(p_currency_code varchar2,p_price_list_id varchar2) is
5646: SELECT 1 FROM DUAL WHERE exists
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

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'

Line 5679: FROM fnd_currencies b

5675: CURSOR C_QOTHDDET_CURRENCY_NULL(p_currency_code varchar2) is
5676: SELECT 1 FROM DUAL WHERE exists
5677: (
5678: SELECT b.currency_code
5679: FROM fnd_currencies b
5680: WHERE b.currency_flag = 'Y'
5681: AND b.enabled_flag = 'Y'
5682: AND trunc(sysdate) between trunc(nvl(start_date_active,sysdate)) and trunc(nvl(end_date_active,sysdate))
5683: and b.currency_code = p_currency_code