APPS.AMS_ACT_LIST_PVT dependencies on AMS_QUERY_CONDITION_VALUE

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

Line 4894: FROM ams_query_condition_value

4890: where template_instance_id = p_templ_inst_id;
4891:
4892: CURSOR fetch_condition_value(p_assoc_id NUMBER) IS
4893: SELECT query_cond_value_id,assoc_id,query_cond_disp_struct_id,value,lov_values_included_flag
4894: FROM ams_query_condition_value
4895: where assoc_id = p_assoc_id;
4896:
4897: l_assoc_id NUMBER;
4898: l_old_assoc_id NUMBER;

Line 4955: AMS_QUERY_CONDITION_VALUE_PKG.INSERT_ROW (

4951: OPEN c_cond_value;
4952: FETCH c_cond_value INTO l_cond_value_id;
4953: CLOSE c_cond_value;
4954:
4955: AMS_QUERY_CONDITION_VALUE_PKG.INSERT_ROW (
4956: X_QUERY_COND_VALUE_ID=>l_cond_value_id,
4957: X_ASSOC_ID => l_assoc_id,
4958: X_QUERY_COND_DISP_STRUCT_ID => l_cond_value_rec.query_cond_disp_struct_id,
4959: X_VALUE =>l_cond_value_rec.value,