APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_LOOKUPS_VIEW

Line 100: p_v_media_type IN igf_lookups_view.lookup_code%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
104: ) AS

Line 154: CURSOR c_aw_lookups_view (cp_v_lookup_type igf_lookups_view.lookup_type%TYPE,

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,
156: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
157: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
158: ) IS

Line 155: cp_v_lookup_code igf_lookups_view.lookup_code%TYPE,

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,
156: cp_v_cal_type igs_ca_inst_all.cal_type%TYPE,
157: cp_n_sequence_number igs_ca_inst_all.sequence_number%TYPE
158: ) IS
159: SELECT lkups.meaning

Line 224: l_v_media_type igf_lookups_view.lookup_code%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;
227:
228: l_v_awd_yr_status_cd igf_ap_batch_aw_map.award_year_status_code%TYPE;

Line 226: l_v_non_ed_branch igf_lookups_view.lookup_code%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;
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;

Line 236: l_v_meaning igf_lookups_view.meaning%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);
236: l_v_meaning igf_lookups_view.meaning%TYPE;
237: l_v_message_name fnd_new_messages.message_name%TYPE;
238: l_n_request_id NUMBER;
239: l_n_ctr_recip NUMBER;
240: lv_group_type igs_pe_persid_group_v.group_type%TYPE;

Line 1343: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,

1339: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1340: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1341: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
1342: p_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
1343: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
1344: p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
1345: p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE
1346: ) AS
1347: ------------------------------------------------------------------

Line 1556: FROM igf_lookups_view

1552:
1553:
1554: CURSOR c_school_opeid(cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE) IS
1555: SELECT meaning
1556: FROM igf_lookups_view
1557: WHERE lookup_type = 'IGF_AP_SCHOOL_OPEID'
1558: AND lookup_code = cp_v_school_id;
1559:
1560: CURSOR c_cl_recipient_dtls (cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE)IS

Line 1652: l_v_media_type igf_lookups_view.lookup_code%TYPE;

1648: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
1649: l_n_base_id igf_ap_fa_base_rec_all.base_id%TYPE;
1650: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
1651: l_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE;
1652: l_v_media_type igf_lookups_view.lookup_code%TYPE;
1653: l_v_sch_non_ed_branch igf_sl_school_codes_v.alternate_identifier%TYPE;
1654: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;
1655:
1656: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;