APPS.IGF_SL_DL_VALIDATION dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 36: FROM igf_ap_isir_matched_all isr

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'
39: AND isr.system_record_type = 'ORIGINAL';
40:

Line 57: FROM igf_ap_isir_matched_all

53:
54: CURSOR cur_isir_info (p_base_id NUMBER) IS
55: SELECT payment_isir,transaction_num,dependency_status,
56: date_of_birth,current_ssn,last_name
57: FROM igf_ap_isir_matched_all
58: WHERE base_id = p_base_id
59: AND payment_isir = 'Y'
60: AND system_record_type = 'ORIGINAL';
61:

Line 339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;

335: ***************************************************************/
336:
337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

Line 340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;

336:
337: lv_loan_catg igf_sl_reqd_fields.loan_type%TYPE;
338: lv_loan_status igf_sl_loans_all.loan_status%TYPE;
339: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
340: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
341: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
342: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE ;
343: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
344: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;

Line 917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;

913: FROM igf_aw_db_chg_dtls db
914: WHERE db.award_id = cp_award_id;
915:
916: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;

Line 918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;

914: WHERE db.award_id = cp_award_id;
915:
916: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
917: lv_s_depncy_status igf_ap_isir_matched_all.dependency_status%TYPE;
918: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
919: lv_acad_cal_type igs_ca_inst_all.cal_type%TYPE ;
920: lv_acad_seq_num igs_ca_inst_all.sequence_number%TYPE;
921: lv_acad_begin_date igs_ca_inst_all.start_dt%TYPE;
922: lv_acad_end_date igs_ca_inst_all.end_dt%TYPE;