eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_ISIR_GEN_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 343: FROM igf_ap_isir_matched_all

339:
340: -- Cursor to check wether the student has any outstanding corrections with status 'BATCHED' or 'READY'
341: CURSOR cur_isir( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
342: SELECT 'X'
343: FROM igf_ap_isir_matched_all
344: WHERE base_id = p_base_id
345: AND system_record_type IN ('ORIGINAL','CORRECTION')
346: AND (NVL(payment_isir,'N') = 'Y' OR NVL(active_isir,'N') = 'Y')
347: AND ROWNUM < 2;

Line 413: FROM IGF_AP_ISIR_MATCHED_ALL im

409: SELECT 'X'
410: FROM IGF_AP_ISIR_CORR_ALL ic
411: WHERE ic.correction_status = 'BATCHED'
412: AND ic.isir_id IN ( SELECT im.isir_id
413: FROM IGF_AP_ISIR_MATCHED_ALL im
414: WHERE im.base_id = cp_base_id );
415:
416: lv_dummy VARCHAR2(1);
417:

Line 461: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

457:
458:
459: PROCEDURE delete_isir_validations(
460: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
461: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
464: x_return_status OUT NOCOPY VARCHAR2
465: ) IS

Line 489: FROM IGF_AP_ISIR_MATCHED_ALL im

485:
486: -- Cursor to check if internal created correction ISIR exists for the student or not.
487: CURSOR cur_stud_correction_isir( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
488: SELECT 'X'
489: FROM IGF_AP_ISIR_MATCHED_ALL im
490: WHERE im.base_id = cp_base_id
491: AND im.system_record_type = 'CORRECTION';
492:
493: lv_dummy VARCHAR2(1);

Line 574: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

570:
571:
572: PROCEDURE delete_isir(
573: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
574: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
575: x_msg_count OUT NOCOPY NUMBER,
576: x_msg_data OUT NOCOPY VARCHAR2,
577: x_return_status OUT NOCOPY VARCHAR2
578: ) IS

Line 594: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,

590: */
591:
592: -- Cursor to get rowid of the ISIR to be deleted.
593: CURSOR cur_chk_isir_in_ints(
594: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
595: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE,
596: cp_original_ssn igf_ap_isir_matched_all.original_ssn%TYPE,
597: cp_orig_name_id igf_ap_isir_matched_all.orig_name_id%TYPE
598: ) IS

Line 595: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE,

591:
592: -- Cursor to get rowid of the ISIR to be deleted.
593: CURSOR cur_chk_isir_in_ints(
594: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
595: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE,
596: cp_original_ssn igf_ap_isir_matched_all.original_ssn%TYPE,
597: cp_orig_name_id igf_ap_isir_matched_all.orig_name_id%TYPE
598: ) IS
599: SELECT ROWID row_id, si_id

Line 596: cp_original_ssn igf_ap_isir_matched_all.original_ssn%TYPE,

592: -- Cursor to get rowid of the ISIR to be deleted.
593: CURSOR cur_chk_isir_in_ints(
594: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
595: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE,
596: cp_original_ssn igf_ap_isir_matched_all.original_ssn%TYPE,
597: cp_orig_name_id igf_ap_isir_matched_all.orig_name_id%TYPE
598: ) IS
599: SELECT ROWID row_id, si_id
600: FROM igf_ap_isir_ints i

Line 597: cp_orig_name_id igf_ap_isir_matched_all.orig_name_id%TYPE

593: CURSOR cur_chk_isir_in_ints(
594: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
595: cp_transaction_num igf_ap_isir_matched_all.transaction_num%TYPE,
596: cp_original_ssn igf_ap_isir_matched_all.original_ssn%TYPE,
597: cp_orig_name_id igf_ap_isir_matched_all.orig_name_id%TYPE
598: ) IS
599: SELECT ROWID row_id, si_id
600: FROM igf_ap_isir_ints i
601: WHERE batch_year_num = cp_batch_year

Line 609: CURSOR cur_get_rowid_nslds( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

605:
606: rec_chk_isir_in_ints cur_chk_isir_in_ints%ROWTYPE;
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:

Line 617: CURSOR cur_get_rowid_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

613:
614: rec_get_rowid_nslds cur_get_rowid_nslds%ROWTYPE;
615:
616: -- Cursor to get rowid of the ISIR to be deleted.
617: CURSOR cur_get_rowid_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
618: SELECT ROWID row_id, batch_year, transaction_num, original_ssn, orig_name_id, base_id, system_record_type
619: FROM igf_ap_isir_matched_all im
620: WHERE im.isir_id = cp_isir_id;
621:

Line 619: FROM igf_ap_isir_matched_all im

615:
616: -- Cursor to get rowid of the ISIR to be deleted.
617: CURSOR cur_get_rowid_isir( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
618: SELECT ROWID row_id, batch_year, transaction_num, original_ssn, orig_name_id, base_id, system_record_type
619: FROM igf_ap_isir_matched_all im
620: WHERE im.isir_id = cp_isir_id;
621:
622: rec_get_rowid_isir cur_get_rowid_isir%ROWTYPE;
623:

Line 624: CURSOR cur_isir_int ( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

620: WHERE im.isir_id = cp_isir_id;
621:
622: rec_get_rowid_isir cur_get_rowid_isir%ROWTYPE;
623:
624: CURSOR cur_isir_int ( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
625: SELECT i.batch_year, i.transaction_num, i.current_ssn, i.ssn_name_change, i.original_ssn, i.orig_name_id, i.last_name, i.first_name, i.middle_initial,
626: i.perm_mail_add, i.perm_city, i.perm_state, i.perm_zip_code, i.date_of_birth, i.phone_number, i.driver_license_number, i.driver_license_state,
627: i.citizenship_status, i.alien_reg_number, i.s_marital_status, i.s_marital_status_date, i.summ_enrl_status, i.fall_enrl_status, i.winter_enrl_status,
628: i.spring_enrl_status, i.summ2_enrl_status, i.fathers_highest_edu_level, i.mothers_highest_edu_level, i.s_state_legal_residence, i.legal_residence_before_date,

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;

Line 709: FROM IGF_AP_ISIR_MATCHED_ALL

705: cur_isir_int_rec cur_isir_int%ROWTYPE;
706: CURSOR get_isir(cp_base_id NUMBER)
707: IS
708: SELECT 'X'
709: FROM IGF_AP_ISIR_MATCHED_ALL
710: WHERE base_id = cp_base_id;
711:
712: l_isir VARCHAR2(1);
713:

Line 762: igf_ap_isir_matched_pkg.delete_row(rec_get_rowid_isir.row_id);

758: CLOSE cur_get_rowid_isir;
759:
760: -- If the selected record is a Simulation ISIR, then dele the Simulated ISIR from the Matched table.
761: IF rec_get_rowid_isir.system_record_type = 'SIMULATION' THEN
762: igf_ap_isir_matched_pkg.delete_row(rec_get_rowid_isir.row_id);
763: RAISE RETURN_EXP ;
764:
765: ELSE
766: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1812: igf_ap_isir_matched_pkg.delete_row(rec_get_rowid_isir.row_id);

1808: END IF; -- NSLDS
1809:
1810: -- Delete the ISIR Data
1811: IF (rec_get_rowid_isir.row_id IS NOT NULL) THEN
1812: igf_ap_isir_matched_pkg.delete_row(rec_get_rowid_isir.row_id);
1813:
1814: -- Processing TODO Items. If the ISIR delete is the only ISIR present in system,
1815: --Update the status of ISIR todo Item to "REQUESTED"
1816: OPEN get_isir(p_base_id);

Line 2097: FROM igf_ap_isir_matched iim,

2093: */
2094:
2095: CURSOR cur_isir_exists (cp_si_id NUMBER, cp_batch_year NUMBER) IS
2096: SELECT 1
2097: FROM igf_ap_isir_matched iim,
2098: igf_ap_isir_ints_all isir
2099: WHERE iim.original_ssn = isir.original_ssn_txt
2100: AND iim.orig_name_id = isir.orig_name_id_txt
2101: AND iim.system_record_type = 'ORIGINAL'

Line 2189: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE

2185:
2186:
2187: FUNCTION chk_pell_orig (
2188: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
2189: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
2190: ) RETURN VARCHAR2 IS
2191: /*
2192: || Created By : rasahoo
2193: || Created On :

Line 2205: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE

2201:
2202: -- Cursor to check wether the student has any non-simulated awards.
2203: CURSOR cur_pell_orig_chk(
2204: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
2205: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE
2206: ) IS
2207: SELECT
2208: isir.transaction_num isir_trans,
2209: rfms.transaction_num rfms_trans

Line 2210: FROM igf_ap_isir_matched_all isir, igf_gr_rfms_all rfms

2206: ) IS
2207: SELECT
2208: isir.transaction_num isir_trans,
2209: rfms.transaction_num rfms_trans
2210: FROM igf_ap_isir_matched_all isir, igf_gr_rfms_all rfms
2211: WHERE isir.base_id = rfms.base_id
2212: AND isir.base_id = cp_base_id
2213: AND isir.isir_id = cp_isir_id ;
2214:

Line 2266: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE

2262:
2263:
2264: FUNCTION make_awarding_isir (
2265: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
2266: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
2267: ) RETURN VARCHAR2 IS
2268: /*
2269: || Created By : rasahoo
2270: || Created On :

Line 2284: FROM igf_ap_isir_matched m

2280: CURSOR cur_isir_matched (
2281: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
2282: ) IS
2283: SELECT *
2284: FROM igf_ap_isir_matched m
2285: WHERE m.base_id = cp_base_id;
2286:
2287: lv_dummy VARCHAR2(1);
2288:

Line 2317: igf_ap_isir_matched_pkg.update_row_rectype(cur_isir_matched_rec);

2313: cur_isir_matched_rec.active_isir := 'N';
2314: END IF;
2315:
2316: -- Call the Update_row of using rowtype present in the TBH
2317: igf_ap_isir_matched_pkg.update_row_rectype(cur_isir_matched_rec);
2318:
2319: END LOOP;
2320:
2321: RETURN 'Y';

Line 2338: p_message_class IN igf_ap_isir_matched_all.message_class_txt%TYPE

2334: END make_awarding_isir;
2335:
2336:
2337: FUNCTION get_isir_message_class (
2338: p_message_class IN igf_ap_isir_matched_all.message_class_txt%TYPE
2339: ) RETURN VARCHAR2 IS
2340: /*
2341: || Created By : brajendr
2342: || Created On : 04-AUG-2004

Line 2353: cp_message_class igf_ap_isir_matched_all.message_class_txt%TYPE

2349: */
2350:
2351: -- Get
2352: CURSOR get_message_class(
2353: cp_message_class igf_ap_isir_matched_all.message_class_txt%TYPE
2354: ) IS
2355: SELECT tlkp.meaning isir_type_desc, tlkp.lookup_code isir_type
2356: FROM igf_lookups_view mlkp, igf_lookups_view tlkp
2357: WHERE mlkp.enabled_flag = 'Y'

Line 2393: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

2389: END get_isir_message_class;
2390:
2391:
2392: PROCEDURE upd_ant_data_awd_prc_status(
2393: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
2394: p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
2395: p_upd_ant_val IN VARCHAR2,
2396: p_anticip_status OUT NOCOPY VARCHAR2,
2397: p_awd_prc_status OUT NOCOPY VARCHAR2

Line 2394: p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,

2390:
2391:
2392: PROCEDURE upd_ant_data_awd_prc_status(
2393: p_old_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
2394: p_new_active_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE,
2395: p_upd_ant_val IN VARCHAR2,
2396: p_anticip_status OUT NOCOPY VARCHAR2,
2397: p_awd_prc_status OUT NOCOPY VARCHAR2
2398: ) AS

Line 2413: CURSOR cur_isir_data( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS

2409: --Who When What
2410: -------------------------------------------------------------------
2411:
2412: -- Get the ISIR details of the student.
2413: CURSOR cur_isir_data( cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE ) IS
2414: SELECT isir_id, base_id, batch_year, summ_enrl_status, grade_level_in_college, first_house_plan, second_house_plan, third_house_plan,
2415: fourth_house_plan, fifth_house_plan, sixth_house_plan, fedral_schl_code_indicator, primary_efc, primary_alternate_month_1,
2416: primary_alternate_month_2, primary_alternate_month_3, primary_alternate_month_4, primary_alternate_month_5, primary_alternate_month_6,
2417: primary_alternate_month_7, primary_alternate_month_8, primary_alternate_month_10, primary_alternate_month_11, primary_alternate_month_12

Line 2418: FROM igf_ap_isir_matched_all

2414: SELECT isir_id, base_id, batch_year, summ_enrl_status, grade_level_in_college, first_house_plan, second_house_plan, third_house_plan,
2415: fourth_house_plan, fifth_house_plan, sixth_house_plan, fedral_schl_code_indicator, primary_efc, primary_alternate_month_1,
2416: primary_alternate_month_2, primary_alternate_month_3, primary_alternate_month_4, primary_alternate_month_5, primary_alternate_month_6,
2417: primary_alternate_month_7, primary_alternate_month_8, primary_alternate_month_10, primary_alternate_month_11, primary_alternate_month_12
2418: FROM igf_ap_isir_matched_all
2419: WHERE isir_id = cp_isir_id;
2420:
2421: new_active_isir cur_isir_data%ROWTYPE;
2422: old_active_isir cur_isir_data%ROWTYPE;

Line 2436: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,

2432: lc_ant_data c_ant_data%ROWTYPE;
2433:
2434: -- Derive the attendance type fromt he setup with the ISIR data.
2435: CURSOR c_attendance_type(
2436: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2437: cp_summ_enrl_status igf_ap_isir_matched_all.summ_enrl_status%TYPE
2438: ) IS
2439: SELECT atm.attendance_type, atm.ap_att_code
2440: FROM igf_ap_attend_map_v atm, igf_ap_batch_aw_map_all bam

Line 2437: cp_summ_enrl_status igf_ap_isir_matched_all.summ_enrl_status%TYPE

2433:
2434: -- Derive the attendance type fromt he setup with the ISIR data.
2435: CURSOR c_attendance_type(
2436: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2437: cp_summ_enrl_status igf_ap_isir_matched_all.summ_enrl_status%TYPE
2438: ) IS
2439: SELECT atm.attendance_type, atm.ap_att_code
2440: FROM igf_ap_attend_map_v atm, igf_ap_batch_aw_map_all bam
2441: WHERE atm.cal_type = bam.ci_cal_type

Line 2449: CURSOR c_class_standing( cp_grade_level_in_college igf_ap_isir_matched_all.grade_level_in_college%TYPE ) IS

2445:
2446: lc_attendance_type c_attendance_type%ROWTYPE;
2447:
2448: -- Derive the class standing from the ISIR Grade level.
2449: CURSOR c_class_standing( cp_grade_level_in_college igf_ap_isir_matched_all.grade_level_in_college%TYPE ) IS
2450: SELECT class_standing, ap_std_code
2451: FROM igf_ap_class_std_map_v
2452: WHERE ap_std_code = cp_grade_level_in_college;
2453:

Line 2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,

2454: lc_class_standing c_class_standing%ROWTYPE;
2455:
2456: -- Derive the Attendace mode based on the housing code
2457: CURSOR c_attendance_mode(
2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,

Line 2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,

2455:
2456: -- Derive the Attendace mode based on the housing code
2457: CURSOR c_attendance_mode(
2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,

Line 2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,

2456: -- Derive the Attendace mode based on the housing code
2457: CURSOR c_attendance_mode(
2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,

Line 2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,

2457: CURSOR c_attendance_mode(
2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE

Line 2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,

2458: cp_batch_year igf_ap_isir_matched_all.batch_year%TYPE,
2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE
2466: ) IS

Line 2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,

2459: cp_first_house_plan igf_ap_isir_matched_all.first_house_plan%TYPE,
2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE
2466: ) IS
2467: SELECT housing_stat_code, ap_house_plan_code

Line 2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,

2460: cp_second_house_plan igf_ap_isir_matched_all.second_house_plan%TYPE,
2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE
2466: ) IS
2467: SELECT housing_stat_code, ap_house_plan_code
2468: FROM igf_ap_housing_map hm, igf_ap_batch_aw_map_all bam

Line 2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE

2461: cp_third_house_plan igf_ap_isir_matched_all.third_house_plan%TYPE,
2462: cp_fourth_house_plan igf_ap_isir_matched_all.fourth_house_plan%TYPE,
2463: cp_fifth_house_plan igf_ap_isir_matched_all.fifth_house_plan%TYPE,
2464: cp_sixth_house_plan igf_ap_isir_matched_all.sixth_house_plan%TYPE,
2465: cp_fedral_schl_code_indicator igf_ap_isir_matched_all.fedral_schl_code_indicator%TYPE
2466: ) IS
2467: SELECT housing_stat_code, ap_house_plan_code
2468: FROM igf_ap_housing_map hm, igf_ap_batch_aw_map_all bam
2469: WHERE hm.ci_cal_type = bam.ci_cal_type