APPS.IGF_SL_CL_CHG_FILE dependencies on IGS_PE_PERSID_GROUP_ALL

Line 99: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,

95: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
96: p_n_dummy_2 IN NUMBER,
97: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
98: p_n_dummy_3 IN NUMBER,
99: p_n_person_id_grp IN igs_pe_persid_group_all.group_id%TYPE,
100: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
101: p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
102: p_v_non_ed_branch IN igf_sl_school_codes_v.system_id_type%TYPE,
103: p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE

Line 149: CURSOR c_person_grp (cp_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS

145: WHERE lar.loan_id = cp_n_loan_id;
146:
147: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
148:
149: CURSOR c_person_grp (cp_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS
150: SELECT pig.group_cd
151: FROM igs_pe_persid_group_all pig
152: WHERE pig.group_id = cp_n_person_id_grp;
153:

Line 151: FROM igs_pe_persid_group_all pig

147: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
148:
149: CURSOR c_person_grp (cp_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE) IS
150: SELECT pig.group_cd
151: FROM igs_pe_persid_group_all pig
152: WHERE pig.group_id = cp_n_person_id_grp;
153:
154: CURSOR c_aw_lookups_view (cp_v_lookup_type igf_lookups_view.lookup_type%TYPE,
155: cp_v_lookup_code igf_lookups_view.lookup_code%TYPE,

Line 222: l_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE;

218: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
219: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
220: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
221: l_n_person_id igf_ap_fa_base_rec_all.person_id%TYPE;
222: l_n_person_id_grp igs_pe_persid_group_all.group_id%TYPE;
223: l_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE;
224: l_v_media_type igf_lookups_view.lookup_code%TYPE;
225: l_v_sch_non_ed_branch igf_sl_school_codes_v.alternate_identifier%TYPE;
226: l_v_non_ed_branch igf_lookups_view.lookup_code%TYPE;

Line 231: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;

227:
228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;
229: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;
230: l_v_fund_desc igf_aw_fund_mast_all.description%TYPE;
231: l_v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
232: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
233: l_c_flag VARCHAR2(1);
234: l_v_sql VARCHAR2(32767);
235: l_v_status VARCHAR2(1);