APPS.IGS_SS_ENR_DETAILS dependencies on IGS_CA_DA_INST

Line 2418: igs_ca_da_inst dai

2414: dai.ci_sequence_number
2415: )
2416: ) AS term_census_date
2417: FROM igs_ge_s_gen_cal_con sgcc,
2418: igs_ca_da_inst dai
2419: WHERE sgcc.s_control_num = 1
2420: AND dai.dt_alias = sgcc.census_dt_alias
2421: AND dai.cal_type = cp_cal_type
2422: AND dai.ci_sequence_number = cp_cal_seq_number

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;

Line 5347: igs_ca_da_inst dai

5343: dai.ci_sequence_number
5344: )
5345: ) AS term_census_date
5346: FROM igs_ge_s_gen_cal_con sgcc,
5347: igs_ca_da_inst dai
5348: WHERE sgcc.s_control_num = 1
5349: AND dai.dt_alias = sgcc.census_dt_alias
5350: AND dai.cal_type = cp_cal_type
5351: AND dai.ci_sequence_number = cp_cal_seq_number