APPS.QP_UTIL_PUB dependencies on FND_CURRENCIES_VL

Line 1143: FROM fnd_currencies_vl

1139:
1140: SELECT currency_code
1141: ,name currency_name
1142: ,PRECISION currency_precision
1143: FROM fnd_currencies_vl
1144: WHERE currency_flag = 'Y'
1145: AND enabled_flag = 'Y'
1146: AND TRUNC(NVL(start_date_active, SYSDATE)) <= TRUNC(SYSDATE)
1147: AND TRUNC(NVL(end_date_active, SYSDATE)) >= TRUNC(SYSDATE)

Line 1157: FROM fnd_currencies_vl a

1153:
1154: SELECT DISTINCT a.currency_code currency_code
1155: ,a.name currency_name
1156: ,a.PRECISION currency_precision
1157: FROM fnd_currencies_vl a
1158: ,qp_currency_details b
1159: ,qp_list_headers_b c
1160: WHERE c.list_header_id = l_price_list_id
1161: AND b.currency_header_id = c.currency_header_id

Line 2809: FROM fnd_currencies_vl fnd, qp_list_headers_b qlh

2805: ,x_sql_string OUT NOCOPY VARCHAR2
2806: )
2807: IS
2808: l_no_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2809: FROM fnd_currencies_vl fnd, qp_list_headers_b qlh
2810: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2811: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2812:
2813: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name

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

2810: WHERE fnd.currency_code = qlh.currency_code AND qlh.list_type_code in (''PRL'', ''AGR'')
2811: AND fnd.currency_flag = ''Y'' AND fnd.enabled_flag = ''Y''';
2812:
2813: l_multi_curr_sql VARCHAR2(2000) := 'SELECT distinct fnd.currency_code,fnd.name
2814: FROM fnd_currencies_vl fnd, qp_currency_details qcd, qp_list_headers_b qlh
2815: WHERE qcd.currency_header_id = qlh.currency_header_id AND fnd.currency_code = qcd.to_currency_code
2816: AND qlh.list_type_code in (''PRL'', ''AGR'') and fnd.currency_flag = ''Y''
2817: AND fnd.enabled_flag = ''Y''';
2818: BEGIN