APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGS_CA_INST

Line 1326: FROM igs_ca_inst

1322: CURSOR c_get_alternate_code(cp_cal_type VARCHAR2,
1323: cp_seq_number NUMBER)
1324: IS
1325: SELECT alternate_code
1326: FROM igs_ca_inst
1327: WHERE cal_type = cp_cal_type
1328: AND sequence_number = cp_seq_number;
1329:
1330: l_get_alternate_code c_get_alternate_code%ROWTYPE;

Line 3623: cp_cal_type igs_ca_inst_all.cal_type%TYPE,

3619:
3620: l_get_base_id c_get_base_id%ROWTYPE;
3621: -- cursor to get the est_orig_fee_perct for the given set up FA 122 Loans Enhancemtns
3622: CURSOR c_setup (
3623: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
3624: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
3625: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
3626:
3627: )

Line 3624: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,

3620: l_get_base_id c_get_base_id%ROWTYPE;
3621: -- cursor to get the est_orig_fee_perct for the given set up FA 122 Loans Enhancemtns
3622: CURSOR c_setup (
3623: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
3624: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
3625: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
3626:
3627: )
3628: IS

Line 5106: FROM igs_ca_inst

5102: CURSOR c_get_alternate_code(cp_cal_type VARCHAR2,
5103: cp_seq_number NUMBER)
5104: IS
5105: SELECT alternate_code
5106: FROM igs_ca_inst
5107: WHERE cal_type = cp_cal_type
5108: AND sequence_number = cp_seq_number;
5109:
5110: l_get_alternate_code c_get_alternate_code%ROWTYPE;