APPS.JTF_TERRITORY_PVT dependencies on FND_LOOKUPS

Line 10828: v_comparision_group fnd_lookups.lookup_type%type;

10824: v_tot_query VARCHAR2(1000);
10825: v_return_val VARCHAR2(100);
10826: v_value1_id NUMBER(30);
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;

Line 10829: v_lookup_code fnd_lookups.lookup_code%type;

10825: v_return_val VARCHAR2(100);
10826: v_value1_id NUMBER(30);
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

Line 10830: v_meaning fnd_lookups.meaning%type;

10826: v_value1_id NUMBER(30);
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

Line 10838: FROM fnd_lookups f

10834: IS
10835: SELECT 'GROUP1' COMPARISION_GROUP,
10836: f.lookup_code,
10837: f.meaning
10838: FROM fnd_lookups f
10839: WHERE f.lookup_type = 'JTF_TERR_COMP_OPERATOR'
10840: AND f.lookup_code IN ('=', '<>')
10841: AND f.enabled_flag = 'Y'
10842: UNION ALL

Line 10846: FROM fnd_lookups f

10842: UNION ALL
10843: SELECT 'GROUP2' COMPARISION_GROUP,
10844: f.lookup_code,
10845: f.meaning
10846: FROM fnd_lookups f
10847: WHERE f.lookup_type = 'JTF_TERR_COMP_OPERATOR'
10848: AND f.lookup_code IN ( '=', '<>', 'LIKE', 'NOT LIKE' , 'BETWEEN', 'NOT BETWEEN')
10849: AND f.enabled_flag = 'Y'
10850: UNION ALL

Line 10854: FROM fnd_lookups f

10850: UNION ALL
10851: SELECT 'GROUP3' COMPARISION_GROUP,
10852: f.lookup_code,
10853: f.meaning
10854: FROM fnd_lookups f
10855: WHERE f.lookup_type = 'JTF_TERR_COMP_OPERATOR'
10856: AND f.lookup_code IN ( '=', '<>' , 'BETWEEN', 'NOT BETWEEN')
10857: AND f.enabled_flag = 'Y'
10858: UNION ALL

Line 10862: FROM fnd_lookups f

10858: UNION ALL
10859: SELECT 'GROUP4' COMPARISION_GROUP,
10860: f.lookup_code,
10861: f.meaning
10862: FROM fnd_lookups f
10863: WHERE f.lookup_type = 'JTF_TERR_COMP_OPERATOR'
10864: AND f.lookup_code = '='
10865: AND f.enabled_flag = 'Y';
10866: CURSOR c_get_currency_code