APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_HEADERS_VL

Line 3880: from ams_list_headers_vl a ,

3876:
3877:
3878: cursor c_query_temp_type is
3879: select 'Y'
3880: from ams_list_headers_vl a ,
3881: ams_query_template_all b
3882: where a.list_header_id = g_list_header_id
3883: and b.template_type = 'PARAMETERIZED'
3884: and a.query_template_id = b.template_id ;

Line 8164: from ams_list_headers_vl

8160: l_action_id number;
8161: l_import_list_name varchar2(200);
8162: cursor c_chk_name is
8163: select 'x'
8164: from ams_list_headers_vl
8165: where list_name = p_list_name ;
8166: cursor c_get_source_type
8167: is select decode(import_type,'B2C','PERSON_LIST','ORGANIZATION_CONTACT_LIST'),
8168: name

Line 8799: from ams_list_headers_vl a ,

8795: l_count1 number:= 0;
8796:
8797: cursor c_query_temp_type is
8798: select 'Y'
8799: from ams_list_headers_vl a ,
8800: ams_query_template_all b
8801: where a.list_header_id = g_list_header_id
8802: and b.template_type = 'PARAMETERIZED'
8803: and a.query_template_id = b.template_id ;