APPS.IGF_AW_PACKAGING dependencies on IGF_SL_CL_PREF_LENDERS

Line 5728: ln_person_id igf_sl_cl_pref_lenders.person_id%TYPE;

5724: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE;
5725: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE;
5726: --FACR116
5727: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5728: ln_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
5729: l_party_id igf_sl_cl_setup.party_id%TYPE;
5730: l_alt_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
5731:
5732: CURSOR c_dp_ap(

Line 12721: FROM igf_sl_cl_pref_lenders

12717: CURSOR c_active_lender(
12718: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE
12719: ) IS
12720: SELECT relationship_cd
12721: FROM igf_sl_cl_pref_lenders
12722: WHERE person_id = cp_person_id
12723: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND TRUNC(NVL(end_date,SYSDATE));
12724: l_active_lender igf_sl_cl_pref_lenders.relationship_cd%TYPE;
12725:

Line 12724: l_active_lender igf_sl_cl_pref_lenders.relationship_cd%TYPE;

12720: SELECT relationship_cd
12721: FROM igf_sl_cl_pref_lenders
12722: WHERE person_id = cp_person_id
12723: AND TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND TRUNC(NVL(end_date,SYSDATE));
12724: l_active_lender igf_sl_cl_pref_lenders.relationship_cd%TYPE;
12725:
12726: BEGIN
12727:
12728: -- Assign all the To Dos which are present at the Fund level and not present for the student.