DBA Data[Home] [Help]

APPS.IGS_AS_GEN_003 dependencies on IGS_EN_GEN_014

Line 732: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(

728: uai.version_number = p_version_number AND
729: uai.cal_type = p_cal_type AND
730: uai.ci_sequence_number = p_ci_sequence_number AND
731: uai.ass_id = p_ass_id AND
732: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(
733: p_exam_cal_type,p_exam_ci_sequence_number,
734: ci.cal_type, ci.sequence_number,
735: 'N') = 'Y'
736: and UAI.LOGICAL_DELETE_DT IS NULL AND

Line 749: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE,CI.SEQUENCE_NUMBER,

745: (UAI.EXAM_CAL_TYPE IS NULL OR
746: CI.CAL_TYPE = UAI.EXAM_CAL_TYPE) AND
747: (UAI.EXAM_CI_SEQUENCE_NUMBER IS NULL OR
748: CI.SEQUENCE_NUMBER = UAI.EXAM_CI_SEQUENCE_NUMBER) AND
749: IGS_EN_GEN_014.ENRS_GET_WITHIN_CI(CI.CAL_TYPE,CI.SEQUENCE_NUMBER,
750: UAI.CAL_TYPE, UAI.CI_SEQUENCE_NUMBER, 'N') = 'Y';
751: v_unit_cd IGS_CA_INST_REL.sup_cal_type%TYPE;
752: CURSOR c_uv IS
753: SELECT supp_exam_permitted_ind