APPS.IGS_SS_ENR_DETAILS dependencies on IGS_CA_DA_INST_V

Line 3019: FROM igs_ca_da_inst_v

3015: CURSOR c_alias_val (cp_c_cal_type IN VARCHAR2,
3016: cp_n_seq_num IN NUMBER,
3017: cp_c_dt_alias IN VARCHAR2) IS
3018: SELECT alias_val
3019: FROM igs_ca_da_inst_v
3020: WHERE cal_type = cp_c_cal_type
3021: AND ci_sequence_number = cp_n_seq_num
3022: AND dt_alias = cp_c_dt_alias
3023: ORDER BY alias_val DESC;

Line 3025: l_d_alias_val igs_ca_da_inst_v.alias_val%TYPE;

3021: AND ci_sequence_number = cp_n_seq_num
3022: AND dt_alias = cp_c_dt_alias
3023: ORDER BY alias_val DESC;
3024:
3025: l_d_alias_val igs_ca_da_inst_v.alias_val%TYPE;
3026:
3027: BEGIN
3028: OPEN c_alias_val(p_c_cal_type, p_n_seq_num, p_c_dt_alias);
3029: FETCH c_alias_val INTO l_d_alias_val;

Line 3822: l_dt_alias_val igs_ca_da_inst_v.alias_val%TYPE;

3818:
3819:
3820: cur_uv_audit_ind_rec cur_uv_audit_ind%ROWTYPE;
3821: l_audit_dt_alias igs_en_cal_conf. AUDIT_STATUS_DT_ALIAS %TYPE;
3822: l_dt_alias_val igs_ca_da_inst_v.alias_val%TYPE;
3823: BEGIN
3824:
3825: OPEN cur_uv_audit_ind(p_uoo_id);
3826: FETCH cur_uv_audit_ind INTO cur_uv_audit_ind_rec;