APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_AP_SCHOOL_OPEID_V

Line 179: FROM igf_ap_school_opeid_v

175: rec_c_school_codes c_school_codes%ROWTYPE;
176:
177: CURSOR c_school_opeid(cp_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE) IS
178: SELECT meaning
179: FROM igf_ap_school_opeid_v
180: WHERE alternate_identifier = cp_v_school_id;
181:
182: CURSOR c_sch_non_ed_branch (cp_v_non_ed_branch igf_sl_school_codes_v.system_id_type%TYPE,
183: cp_v_alt_identifier igf_sl_school_codes_v.alternate_identifier%TYPE

Line 1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;

1661: l_v_file_ident_name igf_sl_cl_file_type.file_ident_name%TYPE;
1662: l_v_file_crea_date VARCHAR2(8);
1663: l_v_file_crea_time VARCHAR2(6);
1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;
1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;