APPS.IGS_EN_GEN_008 dependencies on IGS_PS_UNIT_DISC_CRT

Line 105: FROM igs_ps_unit_disc_crt uddc,

101: -- at the institutional level for the logged on person
102: CURSOR cur_unit_disc_crt
103: IS
104: SELECT daiv.alias_val
105: FROM igs_ps_unit_disc_crt uddc,
106: igs_ca_da_inst_v daiv
107: WHERE uddc.delete_ind = 'N'
108: AND daiv.cal_type = p_cal_type
109: AND daiv.ci_sequence_number = p_ci_sequence_number

Line 361: igs_ps_unit_disc_crt uddc

357: ) alias_val,
358: uddc.administrative_unit_status,
359: uddc.dflt_ind
360: FROM igs_ca_da_inst dai,
361: igs_ps_unit_disc_crt uddc
362: WHERE dai.cal_type = p_cal_type AND
363: dai.ci_sequence_number = p_ci_sequence_number AND
364: dai.dt_alias = uddc.unit_discont_dt_alias
365: ORDER BY 1;

Line 371: l_v_administrative_unit_status igs_ps_unit_disc_crt.administrative_unit_status%TYPE;

367: -- Rowtype Variables
368: l_cur_unit_usec_disc cur_unit_usec_disc%ROWTYPE;
369: l_cur_inst_date_aliases cur_inst_date_aliases%ROWTYPE;
370: l_v_alias_val igs_ca_da_inst_v.alias_val%TYPE;
371: l_v_administrative_unit_status igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
372: l_v_return_value igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
373: l_v_admin_unit_status_str VARCHAR2(2000);
374: l_b_dflt_admin_unit_found BOOLEAN;
375: l_n_aus_count NUMBER(2);

Line 372: l_v_return_value igs_ps_unit_disc_crt.administrative_unit_status%TYPE;

368: l_cur_unit_usec_disc cur_unit_usec_disc%ROWTYPE;
369: l_cur_inst_date_aliases cur_inst_date_aliases%ROWTYPE;
370: l_v_alias_val igs_ca_da_inst_v.alias_val%TYPE;
371: l_v_administrative_unit_status igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
372: l_v_return_value igs_ps_unit_disc_crt.administrative_unit_status%TYPE;
373: l_v_admin_unit_status_str VARCHAR2(2000);
374: l_b_dflt_admin_unit_found BOOLEAN;
375: l_n_aus_count NUMBER(2);
376: BEGIN