APPS.IGS_FI_AD_HOC_WAV dependencies on IGS_CA_INST

Line 37: FUNCTION fee_perd (p_cal_type IN igs_ca_inst.cal_type%TYPE ,

33: --sarakshi 28-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
34: --sbaliga 25-feb-2002 Modified procedure group_waiver_proc as part of #2144600
35: -------------------------------------------------------------------
36:
37: FUNCTION fee_perd (p_cal_type IN igs_ca_inst.cal_type%TYPE ,
38: p_seq_number IN igs_ca_inst.sequence_number%TYPE ) RETURN VARCHAR2 IS
39: ------------------------------------------------------------------
40: --Created by : Jabeen Begum, Oracle IDC
41: --Date created: 20/12/2001

Line 38: p_seq_number IN igs_ca_inst.sequence_number%TYPE ) RETURN VARCHAR2 IS

34: --sbaliga 25-feb-2002 Modified procedure group_waiver_proc as part of #2144600
35: -------------------------------------------------------------------
36:
37: FUNCTION fee_perd (p_cal_type IN igs_ca_inst.cal_type%TYPE ,
38: p_seq_number IN igs_ca_inst.sequence_number%TYPE ) RETURN VARCHAR2 IS
39: ------------------------------------------------------------------
40: --Created by : Jabeen Begum, Oracle IDC
41: --Date created: 20/12/2001
42: --

Line 56: FROM igs_ca_inst

52:
53: CURSOR cur_perd(cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
54: cp_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
55: SELECT cal_type , start_dt , end_dt
56: FROM igs_ca_inst
57: WHERE cal_type = cp_cal_type
58: AND sequence_number = cp_seq_num;
59:
60: l_fee_per cur_perd%ROWTYPE;

Line 273: FROM igs_ca_type t , igs_ca_inst i , igs_ca_stat s

269:
270: CURSOR c_cal_per (cp_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE ,
271: cp_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) IS
272: SELECT 'X'
273: FROM igs_ca_type t , igs_ca_inst i , igs_ca_stat s
274: WHERE t.closed_ind = 'N'
275: AND t.s_cal_cat = 'FEE'
276: AND t.cal_type = cp_cal_type
277: AND t.cal_type = i.cal_type