DBA Data[Home] [Help]

APPS.JTF_TERRITORY_PVT dependencies on FND_CURRENCIES_VL

Line 10831: v_currency_name fnd_currencies_vl.NAME%type;

10827: v_value2_id NUMBER(30);
10828: v_comparision_group fnd_lookups.lookup_type%type;
10829: v_lookup_code fnd_lookups.lookup_code%type;
10830: v_meaning fnd_lookups.meaning%type;
10831: v_currency_name fnd_currencies_vl.NAME%type;
10832: v_curr_code fnd_currencies_vl.CURRENCY_CODE%type;
10833: CURSOR c_comparision_operator
10834: IS
10835: SELECT 'GROUP1' COMPARISION_GROUP,

Line 10832: v_curr_code fnd_currencies_vl.CURRENCY_CODE%type;

10828: v_comparision_group fnd_lookups.lookup_type%type;
10829: v_lookup_code fnd_lookups.lookup_code%type;
10830: v_meaning fnd_lookups.meaning%type;
10831: v_currency_name fnd_currencies_vl.NAME%type;
10832: v_curr_code fnd_currencies_vl.CURRENCY_CODE%type;
10833: CURSOR c_comparision_operator
10834: IS
10835: SELECT 'GROUP1' COMPARISION_GROUP,
10836: f.lookup_code,

Line 10870: FROM fnd_currencies_vl f

10866: CURSOR c_get_currency_code
10867: IS
10868: SELECT f.name currency_name,
10869: f.currency_code
10870: FROM fnd_currencies_vl f
10871: WHERE f.enabled_flag = 'Y'
10872: ORDER BY 1;
10873: BEGIN
10874: IF (select_flag ='CO' AND v_COMPARISON_OPERATOR IS NOT NULL) THEN