APPS.IGS_EN_VAL_SCI dependencies on IGS_CA_DA_INST_V

Line 36: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,

32: unit_attempt_status NOT IN ('UNCONFIRM',
33: 'INVALID',
34: 'DISCONTIN');
35: CURSOR c_daiv_details(
36: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
37: cp_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
38: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
39: SELECT alias_val
40: FROM IGS_CA_DA_INST_V

Line 37: cp_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE,

33: 'INVALID',
34: 'DISCONTIN');
35: CURSOR c_daiv_details(
36: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
37: cp_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
38: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
39: SELECT alias_val
40: FROM IGS_CA_DA_INST_V
41: WHERE cal_type = cp_cal_type AND

Line 38: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS

34: 'DISCONTIN');
35: CURSOR c_daiv_details(
36: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
37: cp_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
38: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
39: SELECT alias_val
40: FROM IGS_CA_DA_INST_V
41: WHERE cal_type = cp_cal_type AND
42: ci_sequence_number = cp_ci_seq_num AND

Line 40: FROM IGS_CA_DA_INST_V

36: cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,
37: cp_ci_seq_num IGS_CA_DA_INST_V.ci_sequence_number%TYPE,
38: cp_dt_alias IGS_CA_DA_INST_V.dt_alias%TYPE) IS
39: SELECT alias_val
40: FROM IGS_CA_DA_INST_V
41: WHERE cal_type = cp_cal_type AND
42: ci_sequence_number = cp_ci_seq_num AND
43: dt_alias = cp_dt_alias
44: ORDER BY alias_val;