APPS.AMS_ACT_LIST_PVT dependencies on DUAL

Line 386: FROM dual;

382:
383:
384: CURSOR c_id IS
385: SELECT AMS_ACT_LISTS_s.NEXTVAL
386: FROM dual;
387:
388: CURSOR c_id_exists (l_id IN NUMBER) IS
389: SELECT 1
390: FROM AMS_ACT_LISTS

Line 4743: SELECT AMS_LIST_QUERIES_PARAM_s.NEXTVAL FROM dual;

4739: FROM AMS_LIST_QUERIES_PARAM_VL
4740: WHERE list_query_id =p_query_id;
4741:
4742: CURSOR c_qlp is
4743: SELECT AMS_LIST_QUERIES_PARAM_s.NEXTVAL FROM dual;
4744:
4745:
4746: l_api_version CONSTANT NUMBER := 1.0;
4747: l_init_msg_list VARCHAR2(2000) := FND_API.G_FALSE;

Line 4805: SELECT ams_query_template_instance_s.NEXTVAL FROM dual;

4801: x_old_templ_inst_id OUT NOCOPY number,
4802: x_new_templ_inst_id OUT NOCOPY number
4803: )is
4804: CURSOR c_templInst is
4805: SELECT ams_query_template_instance_s.NEXTVAL FROM dual;
4806:
4807: CURSOR fetch_templ_instance(p_header_id NUMBER) IS
4808: SELECT template_instance_id, admin_indicator_flag, request_id, view_application_id, instance_used_by, instance_used_by_id
4809: FROM ams_query_template_instance

Line 4881: SELECT ams_query_temp_inst_cond_asc_s.NEXTVAL FROM dual;

4877: x_msg_data OUT NOCOPY varchar2,
4878: x_return_status IN OUT NOCOPY VARCHAR2
4879: )is
4880: CURSOR c_cond_assoc is
4881: SELECT ams_query_temp_inst_cond_asc_s.NEXTVAL FROM dual;
4882:
4883: CURSOR c_cond_value is
4884: SELECT ams_query_condition_value_s.NEXTVAL FROM dual;
4885:

Line 4884: SELECT ams_query_condition_value_s.NEXTVAL FROM dual;

4880: CURSOR c_cond_assoc is
4881: SELECT ams_query_temp_inst_cond_asc_s.NEXTVAL FROM dual;
4882:
4883: CURSOR c_cond_value is
4884: SELECT ams_query_condition_value_s.NEXTVAL FROM dual;
4885:
4886:
4887: CURSOR fetch_condition_assoc(p_templ_inst_id NUMBER) IS
4888: SELECT assoc_id ,template_instance_id,query_condition_id,condition_sequence,running_total, delta