APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_LIST_SRC_TYPES_VL

Line 1188: FROM AMS_LIST_SRC_TYPES_VL

1184: , java_class_name
1185: , arc_act_src_used_by
1186: , source_category
1187: , import_type
1188: FROM AMS_LIST_SRC_TYPES_VL
1189: WHERE list_source_type_id = p_list_source_type_id
1190: ;
1191: l_reference_rec c_reference%ROWTYPE;
1192:

Line 1284: FROM ams_list_src_types_vl

1280: )
1281: IS
1282: CURSOR c_fields IS
1283: SELECT *
1284: FROM ams_list_src_types_vl
1285: WHERE list_source_type_id = p_listsrctype_rec.list_source_type_id
1286: ;
1287: l_listsrctype_rec c_fields%ROWTYPE;
1288: BEGIN

Line 1448: FROM ams_list_src_types_vl

1444: l_where_clause VARCHAR2(4000);
1445:
1446: CURSOR c_name_create (p_name IN VARCHAR2) IS
1447: SELECT 1
1448: FROM ams_list_src_types_vl
1449: WHERE list_source_name = p_name;
1450:
1451: CURSOR c_name_update (p_name IN VARCHAR2, p_id IN NUMBER) IS
1452: SELECT 'Y'

Line 1453: FROM ams_list_src_types_vl

1449: WHERE list_source_name = p_name;
1450:
1451: CURSOR c_name_update (p_name IN VARCHAR2, p_id IN NUMBER) IS
1452: SELECT 'Y'
1453: FROM ams_list_src_types_vl
1454: WHERE list_source_name = p_name
1455: AND list_source_type_id <> p_id;
1456:
1457: BEGIN