APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AP_FA_BASE_REC

Line 34: CURSOR cur_isir(p_base_id igf_ap_fa_base_rec.base_id%TYPE) is

30: AND ( nvl(disb_gross_amt,0) <= 0
31: OR nvl(fee_1 ,0) <= 0
32: OR nvl(disb_net_amt ,0) <= 0);
33:
34: CURSOR cur_isir(p_base_id igf_ap_fa_base_rec.base_id%TYPE) is
35: SELECT isr.dependency_status s_depncy_status
36: FROM igf_ap_isir_matched_all isr
37: WHERE isr.base_id = p_base_id
38: AND isr.payment_isir = 'Y'

Line 47: CURSOR cur_special_school ( cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,

43: SELECT COUNT(*) disb_count
44: FROM igf_aw_awd_disb_all disb
45: WHERE disb.award_id = cp_award_id;
46:
47: CURSOR cur_special_school ( cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
48: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE) IS
49: SELECT dlsetup.special_school
50: FROM igf_sl_dl_setup_all dlsetup
51: WHERE dlsetup.ci_cal_type = cp_cal_type

Line 48: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE) IS

44: FROM igf_aw_awd_disb_all disb
45: WHERE disb.award_id = cp_award_id;
46:
47: CURSOR cur_special_school ( cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
48: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE) IS
49: SELECT dlsetup.special_school
50: FROM igf_sl_dl_setup_all dlsetup
51: WHERE dlsetup.ci_cal_type = cp_cal_type
52: AND dlsetup.ci_sequence_number = cp_seq_number;

Line 148: FUNCTION get_system_grade_level(p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

144: igs_ge_msg_stack.add;
145: app_exception.raise_exception;
146: END check_for_reqd;
147:
148: FUNCTION get_system_grade_level(p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
149: p_loan_per_begin_date IN DATE,
150: p_loan_per_end_date IN DATE
151: )
152: RETURN VARCHAR2

Line 169: FROM IGF_AP_FA_BASE_REC_ALL

165: ***************************************************************/
166:
167: CURSOR cur_get_person_id(cp_base_id NUMBER) IS
168: SELECT person_id
169: FROM IGF_AP_FA_BASE_REC_ALL
170: WHERE base_id = cp_base_id;
171: person_id_rec cur_get_person_id%ROWTYPE;
172:
173: l_person_id NUMBER;

Line 235: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,

231:
232: END get_system_grade_level;
233:
234: PROCEDURE loan_limit_validation (
235: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
236: p_fund_type IN igf_aw_fund_cat.fed_fund_code%TYPE,
237: p_award_id IN igf_aw_award_all.award_id%TYPE,
238: p_msg_name OUT NOCOPY fnd_new_messages.message_name%TYPE
239: )

Line 380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,

376: -- N : Not Ready
377:
378: -- FA 122 Loan Enhancements changed the cursor to obsolete the view igf_sl_lor_dtls_v
379: CURSOR cur_loans(
380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,

Line 381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,

377:
378: -- FA 122 Loan Enhancements changed the cursor to obsolete the view igf_sl_lor_dtls_v
379: CURSOR cur_loans(
380: cp_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
381: cp_seq_number igf_ap_fa_base_rec.ci_sequence_number%TYPE,
382: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
383: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
384: cp_status_1 igf_sl_loans.loan_status%TYPE,
385: cp_status_2 igf_sl_loans.loan_status%TYPE,

Line 415: igf_ap_fa_base_rec_all fabase

411: igf_sl_lor_all lor,
412: igf_aw_award_all awd,
413: igf_aw_fund_mast_all fmast,
414: igf_aw_fund_cat_all fcat,
415: igf_ap_fa_base_rec_all fabase
416: WHERE fabase.ci_cal_type = cp_cal_type
417: AND fabase.ci_sequence_number = cp_seq_number
418: AND fabase.base_id = awd.base_id
419: AND awd.fund_id = fmast.fund_id