DBA Data[Home] [Help]

APPS.IGF_AP_MATCHING_PROCESS_PKG dependencies on IGF_AP_NSLDS_DATA_ALL

Line 3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;

3681: lv_cur_fabase_rec cur_fabase%ROWTYPE;
3682:
3683: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3684: lv_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
3685: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3686: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3687: l_chk_fo_ant_data BOOLEAN;
3688: l_anticip_status VARCHAR2(30);
3689: l_awd_prc_status VARCHAR2(30);

Line 3888: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;

3884:
3885: lv_person_id igf_ap_person_v.person_id%TYPE ;
3886: lv_base_id igf_ap_fa_base_rec.base_id%TYPE;
3887: lv_isir_id igf_ap_css_profile.cssp_id%TYPE;
3888: lv_nslds_id igf_ap_nslds_data_all.nslds_id%TYPE;
3889: l_pymt_isir_flag igf_ap_isir_matched_all.payment_isir%TYPE;
3890:
3891: BEGIN
3892:

Line 8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS

8134: FROM igf_ap_isir_ints iii
8135: WHERE si_id = pn_si_id;
8136:
8137: CURSOR cur_nslds_data (cp_base_id NUMBER ,
8138: cp_trans_num igf_ap_nslds_data_all.transaction_num_txt%TYPE) IS
8139: SELECT nslds.rowid row_id,
8140: nslds.nslds_id
8141: FROM igf_ap_nslds_data nslds
8142: WHERE base_id = cp_base_id