APPS.JTF_LOC_AREAS_PVT dependencies on DUAL

Line 37: FROM DUAL;

33: l_loc_area_count NUMBER;
34:
35: CURSOR c_loc_area_seq IS
36: SELECT JTF_LOC_AREAS_B_S.NEXTVAL
37: FROM DUAL;
38:
39: CURSOR c_loc_area_count(loc_area_id IN NUMBER) IS
40: SELECT COUNT(*)
41: FROM JTF_LOC_AREAS_VL

Line 469: FROM DUAL

465: l_child_exist NUMBER := NULL;
466:
467: CURSOR c_child_exist(l_id NUMBER) IS
468: SELECT 1
469: FROM DUAL
470: WHERE EXISTS(SELECT 1
471: FROM jtf_loc_areas_b
472: WHERE nvl(end_date_active,SYSDATE + 1) > SYSDATE
473: AND parent_location_area_id = l_id);

Line 951: FROM DUAL

947: IS
948:
949: CURSOR c_world_exist IS
950: SELECT 1
951: FROM DUAL
952: WHERE EXISTS(SELECT 1
953: FROM jtf_loc_areas_b
954: WHERE location_type_code = 'AREA1');
955:

Line 1101: FROM DUAL

1097: l_count NUMBER := NULL;
1098:
1099: CURSOR c_area_name_count1(l_id NUMBER, l_parent_id NUMBER, l_name VARCHAR2) IS
1100: SELECT 1
1101: FROM DUAL
1102: WHERE EXISTS(SELECT 1
1103: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1104: WHERE t.location_area_name = l_name
1105: AND t.language = USERENV('LANG')

Line 1112: FROM DUAL

1108: AND b.location_area_id =t.location_area_id);
1109:
1110: CURSOR c_area_name_count2(l_parent_id NUMBER, l_name VARCHAR2) IS
1111: SELECT 1
1112: FROM DUAL
1113: WHERE EXISTS(SELECT 1
1114: FROM jtf_loc_areas_b b, jtf_loc_areas_tl t
1115: WHERE t.location_area_name = l_name
1116: AND t.language = USERENV('LANG')