APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_RECORD_MATCH

Line 21: g_match_code igf_ap_record_match_all.match_code%TYPE;

17: l_document_type VARCHAR2(4000);
18:
19: -- added by rgangara as part of FA138 enh
20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;
25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;

Line 349: CURSOR cur_match_set(cp_match_code igf_ap_record_match_all.match_code%TYPE) IS

345: AND hz.status = 'A'
346: AND olt.system_id_type = 'FED_SCH_CD'
347: AND oli.org_alternate_id = cp_school_cd ;
348:
349: CURSOR cur_match_set(cp_match_code igf_ap_record_match_all.match_code%TYPE) IS
350: SELECT 'Y'
351: FROM igf_ap_record_match
352: WHERE match_code = cp_match_code
353: AND enabled_flag = 'Y';

Line 351: FROM igf_ap_record_match

347: AND oli.org_alternate_id = cp_school_cd ;
348:
349: CURSOR cur_match_set(cp_match_code igf_ap_record_match_all.match_code%TYPE) IS
350: SELECT 'Y'
351: FROM igf_ap_record_match
352: WHERE match_code = cp_match_code
353: AND enabled_flag = 'Y';
354:
355: l_valid_found VARCHAR2(1);