APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_CL_SETUP

Line 1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;

1258: lv_recip_non_ed_brc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1259: l_coa igf_ap_fa_base_rec_all.coa_f%TYPE;
1260: l_efc igf_ap_fa_base_rec_all.efc_f%TYPE;
1261: lv_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE;
1262: lv_eft_authorization igf_sl_cl_setup.eft_authorization%TYPE;
1263: l_dummy_pell_efc NUMBER;
1264:
1265: lv_source_name igf_lookups_view.meaning%TYPE;
1266:

Line 1323: CURSOR cur_get_setup(p_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,

1319: l_at4Record VARCHAR2(1000) := '';
1320: -- To get the School Id
1321: -- Get the details of
1322: /*
1323: CURSOR cur_get_setup(p_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
1324: p_seq_number igf_sl_cl_setup_all.ci_sequence_number%TYPE,
1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,
1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE
1327: ) IS

Line 1324: p_seq_number igf_sl_cl_setup_all.ci_sequence_number%TYPE,

1320: -- To get the School Id
1321: -- Get the details of
1322: /*
1323: CURSOR cur_get_setup(p_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
1324: p_seq_number igf_sl_cl_setup_all.ci_sequence_number%TYPE,
1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,
1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE
1327: ) IS
1328: SELECT eft_authorization

Line 1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,

1321: -- Get the details of
1322: /*
1323: CURSOR cur_get_setup(p_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
1324: p_seq_number igf_sl_cl_setup_all.ci_sequence_number%TYPE,
1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,
1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE
1327: ) IS
1328: SELECT eft_authorization
1329: FROM igf_sl_cl_setup

Line 1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE

1322: /*
1323: CURSOR cur_get_setup(p_cal_type igf_sl_cl_setup_all.ci_cal_type%TYPE,
1324: p_seq_number igf_sl_cl_setup_all.ci_sequence_number%TYPE,
1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,
1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE
1327: ) IS
1328: SELECT eft_authorization
1329: FROM igf_sl_cl_setup
1330: WHERE ci_cal_type = p_cal_type

Line 1329: FROM igf_sl_cl_setup

1325: p_rel_code igf_sl_cl_setup_all.relationship_cd%TYPE,
1326: p_party_id igf_sl_cl_setup_all.party_id%TYPE
1327: ) IS
1328: SELECT eft_authorization
1329: FROM igf_sl_cl_setup
1330: WHERE ci_cal_type = p_cal_type
1331: AND ci_sequence_number = p_seq_number
1332: AND relationship_cd = p_rel_code
1333: AND NVL(party_id,-100) = NVL(p_party_id,-100);