APPS.IGF_AP_ISIR_MATCHED_PKG dependencies on IGF_AP_FA_BASE_REC

Line 1429: CURSOR c_get_person_id (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

1425: || Who When What
1426: || (reverse chronological order - newest change first)
1427: */
1428:
1429: CURSOR c_get_person_id (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1430: SELECT person_id
1431: FROM igf_ap_fa_base_rec_all
1432: WHERE base_id = p_base_id;
1433:

Line 1431: FROM igf_ap_fa_base_rec_all

1427: */
1428:
1429: CURSOR c_get_person_id (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1430: SELECT person_id
1431: FROM igf_ap_fa_base_rec_all
1432: WHERE base_id = p_base_id;
1433:
1434: CURSOR c_get_object_id(p_school_code igf_ap_isir_matched_all.first_college%TYPE) IS
1435: SELECT hz.party_id party_id

Line 4119: CURSOR cur_fa_base( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

4115: || (reverse chronological order - newest change first)
4116: */
4117:
4118: -- fetch the student details
4119: CURSOR cur_fa_base( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
4120: SELECT *
4121: FROM igf_ap_fa_base_rec
4122: WHERE base_id = cp_base_id
4123: FOR UPDATE NOWAIT ;

Line 4121: FROM igf_ap_fa_base_rec

4117:
4118: -- fetch the student details
4119: CURSOR cur_fa_base( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
4120: SELECT *
4121: FROM igf_ap_fa_base_rec
4122: WHERE base_id = cp_base_id
4123: FOR UPDATE NOWAIT ;
4124:
4125: lcur_fa_base_rec cur_fa_base%ROWTYPE;