DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_CA_INST_ALL

Line 1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1720: AND version_number = p_unit_ver_num;
1721:
1722: --Check if there exist any user level deadline
1723: CURSOR cur_pe_usr_arg( cp_person_type IN igs_pe_person_types.person_type_code%TYPE,
1724: cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1725: IS
1726: SELECT dai.alias_val alias_val
1727: FROM igs_ca_da_inst_v dai,igs_pe_usr_arg_all pua
1728: WHERE pua.person_type = cp_person_type

Line 1744: CURSOR cur_en_cal_conf(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)

1740: AND uoo_id = p_uoo_id
1741: ORDER BY 1;
1742:
1743: --Check if deadline has passed for cp change at institution level
1744: CURSOR cur_en_cal_conf(cp_cal_type igs_ca_inst_all.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE)
1745: IS
1746: SELECT dai.alias_val alias_val
1747: FROM igs_ca_da_inst_v dai, igs_en_cal_conf ecc
1748: WHERE dai.cal_type = cp_cal_type