APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_NSLDS_DATA_ALL

Line 611: FROM igf_ap_nslds_data_all n

607:
608: -- Cursor to get rowid of the ISIR to be deleted.
609: CURSOR cur_get_rowid_nslds( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
610: SELECT ROWID row_id
611: FROM igf_ap_nslds_data_all n
612: WHERE n.isir_id = cp_isir_id;
613:
614: rec_get_rowid_nslds cur_get_rowid_nslds%ROWTYPE;
615:

Line 701: FROM igf_ap_isir_matched_all i, igf_ap_nslds_data_all n

697: n.nslds_loan_last_d_date_1, n.nslds_loan_last_d_amt_2, n.nslds_loan_last_d_date_2, n.nslds_loan_last_d_amt_3, n.nslds_loan_last_d_date_3,
698: n.nslds_loan_last_d_amt_4, n.nslds_loan_last_d_date_4, n.nslds_loan_last_d_amt_5, n.nslds_loan_last_d_date_5, n.nslds_loan_last_d_amt_6,
699: n.nslds_loan_last_d_date_6, n.dlp_master_prom_note_flag, n.subsidized_loan_limit_type, n.combined_loan_limit_type,
700: i.system_record_type
701: FROM igf_ap_isir_matched_all i, igf_ap_nslds_data_all n
702: WHERE i.isir_id = n.isir_id(+)
703: AND i.isir_id = cp_isir_id;
704:
705: cur_isir_int_rec cur_isir_int%ROWTYPE;