APPS.AMS_LISTSOURCETYPE_PVT dependencies on AMS_LIST_SRC_TYPES_VL

Line 1190: FROM AMS_LIST_SRC_TYPES_VL

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

Line 1286: FROM ams_list_src_types_vl

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

Line 1450: FROM ams_list_src_types_vl

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

Line 1455: FROM ams_list_src_types_vl

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