APPS.IGS_CA_VAL_QLITY dependencies on IGS_PS_UNIT_DISC_CRT

Line 2521: IGS_PS_UNIT_DISC_CRT uddc

2517: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2518: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2519: SELECT DISTINCT ADMINISTRATIVE_UNIT_STATUS
2520: FROM IGS_CA_DA_INST_V daiv,
2521: IGS_PS_UNIT_DISC_CRT uddc
2522: WHERE daiv.CAL_TYPE = cp_cal_type AND
2523: ci_sequence_number = cp_sequence_number AND
2524: daiv.DT_ALIAS = uddc.unit_discont_dt_alias AND
2525: uddc.delete_ind = 'N';

Line 2542: cp_uddc_aus IGS_PS_UNIT_DISC_CRT.ADMINISTRATIVE_UNIT_STATUS%TYPE,

2538: ci.CAL_TYPE,
2539: ci.sequence_number,
2540: 'N') = 'Y';
2541: CURSOR c_chk_ausl (
2542: cp_uddc_aus IGS_PS_UNIT_DISC_CRT.ADMINISTRATIVE_UNIT_STATUS%TYPE,
2543: cp_load_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2544: cp_load_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
2545: cp_teach_ci_cal_type IGS_CA_INST.CAL_TYPE%TYPE ) IS
2546: SELECT 'x'