APPS.IGF_SL_AWARD dependencies on IGF_SL_CL_PREF_LENDERS

Line 118: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

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
122: ) IS

Line 191: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

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
195: ) IS

Line 283: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

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:
287: l_dl_int_rebate := NULL;

Line 420: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

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:
424: l_rel_code := NULL;

Line 763: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

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
767: SELECT *

Line 925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,

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
929: /*************************************************************

Line 958: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE

954: l_get_details c_get_details%ROWTYPE;
955:
956:
957: CURSOR c_chk_pref_lender (
958: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
959: )
960: IS
961: SELECT relationship_cd
962: FROM igf_sl_cl_pref_lenders

Line 962: FROM igf_sl_cl_pref_lenders

958: cp_person_id igf_sl_cl_pref_lenders.person_id%TYPE
959: )
960: IS
961: SELECT relationship_cd
962: FROM igf_sl_cl_pref_lenders
963: WHERE person_id = cp_person_id
964: AND SYSDATE BETWEEN start_date AND NVL(end_date,SYSDATE);
965:
966: l_chk_pref_lender c_chk_pref_lender%ROWTYPE;