APPS.IGS_CA_VAL_QLITY dependencies on IGS_AD_CAL_CONF

Line 892: IGS_AD_CAL_CONF sacc

888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
889: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
890: SELECT 'x'
891: FROM IGS_CA_DA_INST_V daiv,
892: IGS_AD_CAL_CONF sacc
893: WHERE daiv.CAL_TYPE = cp_cal_type AND
894: daiv.ci_sequence_number = cp_ci_sequence_number AND
895: daiv.DT_ALIAS = sacc.initialise_adm_perd_dt_alias AND
896: sacc.s_control_num = 1;

Line 902: IGS_AD_CAL_CONF sacc

898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
899: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
900: SELECT 'x'
901: FROM IGS_CA_DA_INST_V daiv,
902: IGS_AD_CAL_CONF sacc
903: WHERE daiv.CAL_TYPE = cp_cal_type AND
904: daiv.ci_sequence_number = cp_ci_sequence_number AND
905: daiv.DT_ALIAS = sacc.adm_appl_encmb_chk_dt_alias AND
906: sacc.s_control_num = 1;

Line 912: IGS_AD_CAL_CONF sacc

908: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
909: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_CA_DA_INST_V daiv,
912: IGS_AD_CAL_CONF sacc
913: WHERE daiv.CAL_TYPE = cp_cal_type AND
914: daiv.ci_sequence_number = cp_ci_sequence_number AND
915: daiv.DT_ALIAS = sacc.adm_appl_course_strt_dt_alias AND
916: sacc.s_control_num = 1;

Line 922: IGS_AD_CAL_CONF sacc

918: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
919: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
920: SELECT COUNT(*)
921: FROM IGS_CA_DA_INST_V daiv,
922: IGS_AD_CAL_CONF sacc
923: WHERE daiv.CAL_TYPE = cp_cal_type AND
924: daiv.ci_sequence_number = cp_ci_sequence_number AND
925: daiv.DT_ALIAS = sacc.adm_appl_due_dt_alias AND
926: sacc.s_control_num = 1 AND

Line 939: IGS_AD_CAL_CONF sacc

935: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
936: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
937: SELECT COUNT(*)
938: FROM IGS_CA_DA_INST_V daiv,
939: IGS_AD_CAL_CONF sacc
940: WHERE daiv.CAL_TYPE = cp_cal_type AND
941: daiv.ci_sequence_number = cp_ci_sequence_number AND
942: daiv.DT_ALIAS = sacc.adm_appl_final_dt_alias AND
943: sacc.s_control_num = 1 AND

Line 956: IGS_AD_CAL_CONF sacc

952: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
953: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
954: SELECT COUNT(*)
955: FROM IGS_CA_DA_INST_V daiv,
956: IGS_AD_CAL_CONF sacc
957: WHERE daiv.CAL_TYPE = cp_cal_type AND
958: daiv.ci_sequence_number = cp_ci_sequence_number AND
959: daiv.DT_ALIAS = sacc.adm_appl_offer_resp_dt_alias AND
960: sacc.s_control_num = 1 AND