APPS.IGS_FI_LOAD_EXT_CHG dependencies on IGS_CA_STAT

Line 20: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in

16: remarks :
17: Change History
18: Who When What
19: akandreg 16-May-2006 Bug 5105131, modified cursor c_f_cal_typ. In function igs_fi_ext_val, the system defined
20: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in
21: the validation test instead of IGS_CA_INST.CAL_TYPE, which is user defined status.
22: sapanigr 24-Feb-2006 Bug#5018036 - Replaced cursor cur_person in igs_fi_extto_imp procedure by function call.
23: sapanigr 12-Feb-2006 Bug#5018036 - Modified cursor cur_person in igs_fi_extto_imp procedure. (R12 SQL Repository tuning)
24: svuppala 09-AUG-2005 Enh 3392095 - Tution Waivers build

Line 96: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in

92: p_message_name OUT NOCOPY VARCHAR2)
93: RETURN BOOLEAN AS
94: /***
95: akandreg 16-May-2006 Bug 5105131, modified cursor c_f_cal_typ. In function igs_fi_ext_val, the system defined
96: status (igs_ca_stat.S_CAL_STATUS) displayed on the Calendar Statuses form would be used in
97: the validation test instead of IGS_CA_INST.CAL_TYPE, which is user defined status.
98: pmarada 29-Mar-2005 Bug 4270442, removed the cursor c_person instead of that calling
99: get_std_formerstd_ind function.
100: vvutukur 20-Jun-2003 Bug#2777502.Modified cursor c_fee_typ to exclude closed fee types.

Line 130: igs_ca_stat st

126: SELECT ci.start_dt,
127: ci.end_dt
128: FROM igs_ca_inst ci,
129: igs_ca_type ct,
130: igs_ca_stat st
131: WHERE ci.cal_type = ct.cal_type
132: AND ct.s_cal_cat = 'FEE'
133: AND ci.cal_status = st.cal_status
134: AND st.s_cal_status = 'ACTIVE'