APPS.IGS_AD_VAL_APAC dependencies on IGS_AD_PERD_AD_CAT

Line 108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,

104: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
105: v_start_dt IGS_CA_INST.start_dt%TYPE;
106: v_end_dt IGS_CA_INST.end_dt%TYPE;
107: CURSOR c_sup (
108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
109: p_adm_ci_sequence_number
110: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
111: Select cir1.sup_cal_type,
112: cir1.sup_ci_sequence_number

Line 110: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS

106: v_end_dt IGS_CA_INST.end_dt%TYPE;
107: CURSOR c_sup (
108: p_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
109: p_adm_ci_sequence_number
110: IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE) IS
111: Select cir1.sup_cal_type,
112: cir1.sup_ci_sequence_number
113: FROM IGS_CA_INST_REL cir1,
114: IGS_CA_TYPE cat

Line 142: FROM IGS_AD_PERD_AD_CAT

138: cp_sub_cal_type IGS_CA_INST_REL.sub_cal_type%TYPE,
139: cp_sub_ci_sequence_number
140: IGS_CA_INST_REL.sub_ci_sequence_number%TYPE) IS
141: SELECT admission_cat
142: FROM IGS_AD_PERD_AD_CAT
143: WHERE adm_cal_type = cp_sub_cal_type AND
144: adm_ci_sequence_number = cp_sub_ci_sequence_number;
145: BEGIN
146: p_message_name := Null;

Line 355: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE) IS

351: v_alternate_code IGS_CA_INST.alternate_code%TYPE;
352: v_start_dt IGS_CA_INST.start_dt%TYPE;
353: v_end_dt IGS_CA_INST.end_dt%TYPE;
354: CURSOR c_s_cal_cat (
355: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE) IS
356: SELECT cat.s_cal_cat
357: FROM IGS_CA_TYPE cat
358: WHERE cat.cal_type = cp_adm_cal_type;
359: CURSOR c_cal_instance_cal_status (

Line 360: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,

356: SELECT cat.s_cal_cat
357: FROM IGS_CA_TYPE cat
358: WHERE cat.cal_type = cp_adm_cal_type;
359: CURSOR c_cal_instance_cal_status (
360: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
361: cp_adm_ci_sequence_number IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE)
362: IS
363: SELECT cs.s_cal_status,
364: ci.alternate_code,

Line 361: cp_adm_ci_sequence_number IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE)

357: FROM IGS_CA_TYPE cat
358: WHERE cat.cal_type = cp_adm_cal_type;
359: CURSOR c_cal_instance_cal_status (
360: cp_adm_cal_type IGS_AD_PERD_AD_CAT.adm_cal_type%TYPE,
361: cp_adm_ci_sequence_number IGS_AD_PERD_AD_CAT.adm_ci_sequence_number%TYPE)
362: IS
363: SELECT cs.s_cal_status,
364: ci.alternate_code,
365: ci.start_dt,