APPS.QP_UTIL_PUB dependencies on FND_CURRENCIES_VL

Line 813: FROM fnd_currencies_vl

809:
810: SELECT currency_code
811: ,name currency_name
812: ,PRECISION currency_precision
813: FROM fnd_currencies_vl
814: WHERE currency_flag = 'Y'
815: AND enabled_flag = 'Y'
816: AND TRUNC(NVL(start_date_active, SYSDATE)) <= TRUNC(SYSDATE)
817: AND TRUNC(NVL(end_date_active, SYSDATE)) >= TRUNC(SYSDATE)

Line 827: FROM fnd_currencies_vl a

823:
824: SELECT DISTINCT a.currency_code currency_code
825: ,a.name currency_name
826: ,a.PRECISION currency_precision
827: FROM fnd_currencies_vl a
828: ,qp_currency_details b
829: ,qp_list_headers_b c
830: WHERE c.list_header_id = l_price_list_id
831: AND b.currency_header_id = c.currency_header_id

Line 2479: FROM fnd_currencies_vl fnd, qp_list_headers_b qlh

2475: ,x_sql_string OUT NOCOPY VARCHAR2
2476: )
2477: IS
2478: l_no_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2479: FROM fnd_currencies_vl fnd, qp_list_headers_b qlh
2480: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2481: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2482:
2483: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name

Line 2484: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh

2480: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2481: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2482:
2483: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2484: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh
2485: WHERE qcd.currency_header_id = qlh.currency_header_id AND fnd.currency_code = qcd.to_currency_code
2486: AND qlh.list_type_code in (''PRL'', ''AGR'') and fnd.currency_flag = ''Y''
2487: AND fnd.enabled_flag = ''Y''';
2488: BEGIN