APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_CL_SETUP

Line 706: CURSOR c_get_rel_ver(p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE, p_cal_type VARCHAR2 , p_seq_num NUMBER)

702: */
703:
704:
705: -- Get the release version
706: CURSOR c_get_rel_ver(p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE, p_cal_type VARCHAR2 , p_seq_num NUMBER)
707: IS
708: SELECT cl_version
709: FROM igf_sl_cl_setup_all
710: WHERE ci_cal_type = p_cal_type

Line 709: FROM igf_sl_cl_setup_all

705: -- Get the release version
706: CURSOR c_get_rel_ver(p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE, p_cal_type VARCHAR2 , p_seq_num NUMBER)
707: IS
708: SELECT cl_version
709: FROM igf_sl_cl_setup_all
710: WHERE ci_cal_type = p_cal_type
711: AND ci_sequence_number = p_seq_num
712: AND relationship_cd= p_rel_code;
713:

Line 1314: igf_sl_cl_setup

1310: p_rel_code VARCHAR2)
1311: IS
1312: SELECT relationship_cd
1313: FROM
1314: igf_sl_cl_setup
1315: WHERE
1316: ci_cal_type = p_cal_type AND
1317: ci_sequence_number = p_seq_number AND
1318: NVL(relationship_cd,'*') = p_rel_code;

Line 3625: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE

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
3629: SELECT est_orig_fee_perct

Line 3630: FROM igf_sl_cl_setup

3626:
3627: )
3628: IS
3629: SELECT est_orig_fee_perct
3630: FROM igf_sl_cl_setup
3631: WHERE ci_cal_type = cp_cal_type
3632: AND ci_sequence_number = cp_sequence_number
3633: AND cp_rel_code = NVL(relationship_cd,'*');
3634: