eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_AWARD dependencies on IGF_SL_CL_SETUP

Line 71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;

67: l_dl_fee1_plus igf_sl_dl_setup.orig_fee_perct_plus%TYPE;
68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%TYPE;
69:
70:
71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
73:
74: CURSOR c_dlsetup (p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS

Line 72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;

68: l_dl_int_rebate igf_sl_dl_setup.int_rebate%TYPE;
69:
70:
71: l_cl_fee1 igf_sl_cl_setup.est_orig_fee_perct%TYPE;
72: l_cl_alt_fee1 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
73:
74: CURSOR c_dlsetup (p_ci_cal_type igs_ca_inst_all.cal_type%TYPE,
75: p_ci_seq_num igs_ca_inst_all.sequence_number%TYPE)IS
76: SELECT orig_fee_perct_stafford,

Line 115: l_hold_rel_ind igf_sl_cl_setup.hold_rel_ind%TYPE;

111: Added p_base_id and call to
112: Pick_setup
113: (reverse chronological order - newest change first)
114: ***************************************************************/
115: l_hold_rel_ind igf_sl_cl_setup.hold_rel_ind%TYPE;
116: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
117: l_party_id igf_sl_cl_setup.party_id%TYPE;
118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
119: CURSOR c_clsetup(

Line 116: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

112: Pick_setup
113: (reverse chronological order - newest change first)
114: ***************************************************************/
115: l_hold_rel_ind igf_sl_cl_setup.hold_rel_ind%TYPE;
116: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
117: l_party_id igf_sl_cl_setup.party_id%TYPE;
118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
119: CURSOR c_clsetup(
120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

Line 117: l_party_id igf_sl_cl_setup.party_id%TYPE;

113: (reverse chronological order - newest change first)
114: ***************************************************************/
115: l_hold_rel_ind igf_sl_cl_setup.hold_rel_ind%TYPE;
116: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
117: l_party_id igf_sl_cl_setup.party_id%TYPE;
118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
119: CURSOR c_clsetup(
120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
121: cp_party_id igf_sl_cl_setup.party_id%TYPE

Line 120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

116: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
117: l_party_id igf_sl_cl_setup.party_id%TYPE;
118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
119: CURSOR c_clsetup(
120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
121: cp_party_id igf_sl_cl_setup.party_id%TYPE
122: ) IS
123: SELECT hold_rel_ind FROM igf_sl_cl_setup
124: WHERE ci_cal_type = p_ci_cal_type

Line 121: cp_party_id igf_sl_cl_setup.party_id%TYPE

117: l_party_id igf_sl_cl_setup.party_id%TYPE;
118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
119: CURSOR c_clsetup(
120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
121: cp_party_id igf_sl_cl_setup.party_id%TYPE
122: ) IS
123: SELECT hold_rel_ind FROM igf_sl_cl_setup
124: WHERE ci_cal_type = p_ci_cal_type
125: AND ci_sequence_number = p_ci_seq_num

Line 123: SELECT hold_rel_ind FROM igf_sl_cl_setup

119: CURSOR c_clsetup(
120: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
121: cp_party_id igf_sl_cl_setup.party_id%TYPE
122: ) IS
123: SELECT hold_rel_ind FROM igf_sl_cl_setup
124: WHERE ci_cal_type = p_ci_cal_type
125: AND ci_sequence_number = p_ci_seq_num
126: AND NVL(relationship_cd,'*') = cp_rel_code
127: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 188: l_auto_late_disb_ind igf_sl_cl_setup.auto_late_disb_ind%TYPE;

184:
185: (reverse chronological order - newest change first)
186: ***************************************************************/
187:
188: l_auto_late_disb_ind igf_sl_cl_setup.auto_late_disb_ind%TYPE;
189: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
190: l_party_id igf_sl_cl_setup.party_id%TYPE;
191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
192: CURSOR c_clsetup(

Line 189: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

185: (reverse chronological order - newest change first)
186: ***************************************************************/
187:
188: l_auto_late_disb_ind igf_sl_cl_setup.auto_late_disb_ind%TYPE;
189: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
190: l_party_id igf_sl_cl_setup.party_id%TYPE;
191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
192: CURSOR c_clsetup(
193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

Line 190: l_party_id igf_sl_cl_setup.party_id%TYPE;

186: ***************************************************************/
187:
188: l_auto_late_disb_ind igf_sl_cl_setup.auto_late_disb_ind%TYPE;
189: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
190: l_party_id igf_sl_cl_setup.party_id%TYPE;
191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
192: CURSOR c_clsetup(
193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
194: cp_party_id igf_sl_cl_setup.party_id%TYPE

Line 193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

189: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
190: l_party_id igf_sl_cl_setup.party_id%TYPE;
191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
192: CURSOR c_clsetup(
193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
194: cp_party_id igf_sl_cl_setup.party_id%TYPE
195: ) IS
196: SELECT auto_late_disb_ind
197: FROM igf_sl_cl_setup

Line 194: cp_party_id igf_sl_cl_setup.party_id%TYPE

190: l_party_id igf_sl_cl_setup.party_id%TYPE;
191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
192: CURSOR c_clsetup(
193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
194: cp_party_id igf_sl_cl_setup.party_id%TYPE
195: ) IS
196: SELECT auto_late_disb_ind
197: FROM igf_sl_cl_setup
198: WHERE ci_cal_type = p_ci_cal_type

Line 197: FROM igf_sl_cl_setup

193: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
194: cp_party_id igf_sl_cl_setup.party_id%TYPE
195: ) IS
196: SELECT auto_late_disb_ind
197: FROM igf_sl_cl_setup
198: WHERE ci_cal_type = p_ci_cal_type
199: AND ci_sequence_number = p_ci_seq_num
200: AND NVL(relationship_cd,'*') = cp_rel_code
201: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 269: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

265: ***************************************************************/
266:
267:
268: CURSOR c_clsetup (
269: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
270: cp_party_id igf_sl_cl_setup.party_id%TYPE
271: )
272: IS
273: SELECT est_orig_fee_perct,

Line 270: cp_party_id igf_sl_cl_setup.party_id%TYPE

266:
267:
268: CURSOR c_clsetup (
269: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
270: cp_party_id igf_sl_cl_setup.party_id%TYPE
271: )
272: IS
273: SELECT est_orig_fee_perct,
274: est_alt_orig_fee_perct

Line 275: FROM igf_sl_cl_setup

271: )
272: IS
273: SELECT est_orig_fee_perct,
274: est_alt_orig_fee_perct
275: FROM igf_sl_cl_setup
276: WHERE ci_cal_type = p_ci_cal_type
277: AND ci_sequence_number = p_ci_seq_num
278: AND NVL(relationship_cd,'*') = cp_rel_code
279: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 281: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

277: AND ci_sequence_number = p_ci_seq_num
278: AND NVL(relationship_cd,'*') = cp_rel_code
279: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
280:
281: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
282: l_party_id igf_sl_cl_setup.party_id%TYPE;
283: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
284:
285: BEGIN

Line 282: l_party_id igf_sl_cl_setup.party_id%TYPE;

278: AND NVL(relationship_cd,'*') = cp_rel_code
279: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
280:
281: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
282: l_party_id igf_sl_cl_setup.party_id%TYPE;
283: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
284:
285: BEGIN
286:

Line 402: l_cl_fee2 igf_sl_cl_setup.est_guarnt_fee_perct%TYPE;

398: Pick_setup
399: (reverse chronological order - newest change first)
400: ***************************************************************/
401:
402: l_cl_fee2 igf_sl_cl_setup.est_guarnt_fee_perct%TYPE;
403: l_cl_alt_fee2 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
404:
405: CURSOR c_clsetup (
406: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

Line 403: l_cl_alt_fee2 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;

399: (reverse chronological order - newest change first)
400: ***************************************************************/
401:
402: l_cl_fee2 igf_sl_cl_setup.est_guarnt_fee_perct%TYPE;
403: l_cl_alt_fee2 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
404:
405: CURSOR c_clsetup (
406: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
407: cp_party_id igf_sl_cl_setup.party_id%TYPE

Line 406: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

402: l_cl_fee2 igf_sl_cl_setup.est_guarnt_fee_perct%TYPE;
403: l_cl_alt_fee2 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
404:
405: CURSOR c_clsetup (
406: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
407: cp_party_id igf_sl_cl_setup.party_id%TYPE
408: )
409: IS
410: SELECT est_guarnt_fee_perct,

Line 407: cp_party_id igf_sl_cl_setup.party_id%TYPE

403: l_cl_alt_fee2 igf_sl_cl_setup.est_alt_orig_fee_perct%TYPE;
404:
405: CURSOR c_clsetup (
406: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
407: cp_party_id igf_sl_cl_setup.party_id%TYPE
408: )
409: IS
410: SELECT est_guarnt_fee_perct,
411: est_alt_guarnt_fee_perct

Line 412: FROM igf_sl_cl_setup

408: )
409: IS
410: SELECT est_guarnt_fee_perct,
411: est_alt_guarnt_fee_perct
412: FROM igf_sl_cl_setup
413: WHERE ci_cal_type = p_ci_cal_type
414: AND ci_sequence_number = p_ci_seq_num
415: AND NVL(relationship_cd,'*') = cp_rel_code
416: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 418: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

414: AND ci_sequence_number = p_ci_seq_num
415: AND NVL(relationship_cd,'*') = cp_rel_code
416: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
417:
418: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
419: l_party_id igf_sl_cl_setup.party_id%TYPE;
420: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
421:
422: BEGIN

Line 419: l_party_id igf_sl_cl_setup.party_id%TYPE;

415: AND NVL(relationship_cd,'*') = cp_rel_code
416: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);
417:
418: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
419: l_party_id igf_sl_cl_setup.party_id%TYPE;
420: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
421:
422: BEGIN
423:

Line 594: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

590: ,loan_chg_status
591: FROM igf_sl_loans
592: WHERE award_id = p_award_id;
593:
594: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
595:
596: BEGIN
597:
598: -- If Loan Application Record is Created, then Check whether the

Line 728: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,

724: PROCEDURE recalc_fees(
725: p_base_id IN igf_aw_award_all.base_id%TYPE,
726: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
727: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
728: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
729: p_award_id IN igf_sl_loans.award_id%TYPE
730: )
731: IS
732: /*************************************************************

Line 761: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;

757: Changed calll to igf_aw_awd_disb_pkg.update_row to reflect the addition of attendance_type_code
758: (reverse chronological order - newest change first)
759: ***************************************************************/
760:
761: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
762: l_party_id igf_sl_cl_setup.party_id%TYPE;
763: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
764:
765: CURSOR cur_get_adisb (cp_award_id igf_sl_loans.award_id%TYPE)

Line 762: l_party_id igf_sl_cl_setup.party_id%TYPE;

758: (reverse chronological order - newest change first)
759: ***************************************************************/
760:
761: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
762: l_party_id igf_sl_cl_setup.party_id%TYPE;
763: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
764:
765: CURSOR cur_get_adisb (cp_award_id igf_sl_loans.award_id%TYPE)
766: IS

Line 924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,

920: PROCEDURE pick_setup(
921: p_base_id IN igf_aw_award_all.base_id%TYPE,
922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126
927: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE )
928: IS

Line 926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126

922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,
926: p_party_id OUT NOCOPY igf_sl_cl_setup.party_id%TYPE, -- this is used in FA 126
927: p_alt_rel_code IN igf_aw_fund_cat_all.alt_rel_code%TYPE )
928: IS
929: /*************************************************************
930: Created By : bkkumar

Line 971: cp_default_flag igf_sl_cl_setup.default_flag%TYPE

967:
968: CURSOR c_get_default_lender (
969: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
970: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
971: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
972: )
973: IS
974: SELECT relationship_cd
975: FROM igf_sl_cl_setup

Line 975: FROM igf_sl_cl_setup

971: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
972: )
973: IS
974: SELECT relationship_cd
975: FROM igf_sl_cl_setup
976: WHERE ci_cal_type = cp_cal_type
977: AND ci_sequence_number = cp_sequence_number
978: AND NVL(default_flag,'N') = cp_default_flag
979: AND party_id IS NULL;

Line 986: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,

982:
983: CURSOR c_get_ovrd_lender (
984: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
985: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
986: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
987: cp_party_id igf_sl_cl_setup.party_id%TYPE
988: )
989: IS
990: SELECT relationship_cd

Line 987: cp_party_id igf_sl_cl_setup.party_id%TYPE

983: CURSOR c_get_ovrd_lender (
984: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
985: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
986: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE,
987: cp_party_id igf_sl_cl_setup.party_id%TYPE
988: )
989: IS
990: SELECT relationship_cd
991: FROM igf_sl_cl_setup

Line 991: FROM igf_sl_cl_setup

987: cp_party_id igf_sl_cl_setup.party_id%TYPE
988: )
989: IS
990: SELECT relationship_cd
991: FROM igf_sl_cl_setup
992: WHERE ci_cal_type = cp_cal_type
993: AND ci_sequence_number = cp_sequence_number
994: AND cp_rel_code = NVL(relationship_cd,'*')
995: AND cp_party_id = NVL(party_id,-1000);

Line 1002: cp_party_id igf_sl_cl_setup.party_id%TYPE,

998:
999: CURSOR c_get_ovrd_default_lender (
1000: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1001: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1002: cp_party_id igf_sl_cl_setup.party_id%TYPE,
1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
1004: )
1005: IS
1006: SELECT relationship_cd

Line 1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE

999: CURSOR c_get_ovrd_default_lender (
1000: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1001: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1002: cp_party_id igf_sl_cl_setup.party_id%TYPE,
1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
1004: )
1005: IS
1006: SELECT relationship_cd
1007: FROM igf_sl_cl_setup

Line 1007: FROM igf_sl_cl_setup

1003: cp_default_flag igf_sl_cl_setup.default_flag%TYPE
1004: )
1005: IS
1006: SELECT relationship_cd
1007: FROM igf_sl_cl_setup
1008: WHERE ci_cal_type = cp_cal_type
1009: AND ci_sequence_number = cp_sequence_number
1010: AND NVL(default_flag,'N') = cp_default_flag
1011: AND NVL(party_id,-1000) = cp_party_id;

Line 1019: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE

1015:
1016: CURSOR cur_find_lender (
1017: cp_cal_type igs_ca_inst_all.cal_type%TYPE,
1018: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE,
1019: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
1020: )
1021: IS
1022: SELECT relationship_cd
1023: FROM igf_sl_cl_setup

Line 1023: FROM igf_sl_cl_setup

1019: cp_rel_code igf_sl_cl_setup.relationship_cd%TYPE
1020: )
1021: IS
1022: SELECT relationship_cd
1023: FROM igf_sl_cl_setup
1024: WHERE ci_cal_type = cp_cal_type
1025: AND ci_sequence_number = cp_sequence_number
1026: AND cp_rel_code = relationship_cd
1027: AND party_id IS NULL;

Line 1244: ,igf_sl_cl_setup_all clset

1240: FROM igf_sl_lor_all lor
1241: ,igf_sl_loans_all loans
1242: ,igf_aw_award_all awd
1243: ,igf_aw_fund_mast_all fmast
1244: ,igf_sl_cl_setup_all clset
1245: WHERE loans.loan_id = lor.loan_id
1246: AND loans.award_id = cp_n_award_id
1247: AND lor.prc_type_code IN ('GO','GP')
1248: AND ( lor.guarnt_status_code = '40' OR lor.cl_rec_status IN ('B','G'))

Line 1393: ,igf_sl_cl_setup_all clset

1389: FROM igf_sl_lor_all lor
1390: ,igf_sl_loans_all loans
1391: ,igf_aw_award_all awd
1392: ,igf_aw_fund_mast_all fmast
1393: ,igf_sl_cl_setup_all clset
1394: WHERE loans.loan_id = lor.loan_id
1395: AND loans.award_id = cp_n_award_id
1396: AND lor.prc_type_code IN ('GO','GP')
1397: AND loans.loan_status <> 'S'

Line 1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

1402: AND fmast.ci_sequence_number = clset.ci_sequence_number
1403: AND lor.relationship_cd = clset.relationship_cd ;
1404:
1405: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1407: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1408: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1409: l_n_award_id igf_aw_award_all.award_id%TYPE;
1410:

Line 1459: RETURN igf_sl_cl_setup_all.cl_version%TYPE AS

1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1457:
1458: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)
1459: RETURN igf_sl_cl_setup_all.cl_version%TYPE AS
1460: ------------------------------------------------------------------
1461: --Created by : Sanil Madathil, Oracle IDC
1462: --Date created: 14 October 2004
1463: --

Line 1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;

1500: fmast.fund_id = awd.fund_id AND
1501: awd.award_id = cp_n_award_id;
1502:
1503: /* Local Variables */
1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;