APPS.AMS_ACT_LIST_PVT dependencies on AMS_QUERY_TEMPLATE_INSTANCE

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 4809: FROM ams_query_template_instance

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
4810: where instance_used_by_id = p_header_id;
4811:
4812:
4813: l_api_version CONSTANT NUMBER := 1.0;