APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGF_AP_FA_BASE_REC

Line 294: CURSOR get_uset_dtls(cp_person_id igf_ap_fa_base_rec.person_id%TYPE,

290: l_athletic_m VARCHAR2(1);
291:
292: --Added the cursor to resolve bug 2296776
293:
294: CURSOR get_uset_dtls(cp_person_id igf_ap_fa_base_rec.person_id%TYPE,
295: cp_course_cd igs_ps_ver.course_cd%TYPE) IS
296: SELECT susa.unit_set_cd,susa.course_cd,susa.us_version_number
297: FROM igs_as_su_setatmpt susa,
298: igs_en_unit_set us ,

Line 315: CURSOR cur_fa_load_awd (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)

311: AND us.unit_set_cat = usc.unit_set_cat;
312:
313: l_uset_rec get_uset_dtls%ROWTYPE;
314:
315: CURSOR cur_fa_load_awd (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
316: IS
317: SELECT sub_cal_type,
318: sub_ci_sequence_number
319: FROM igs_ca_inst_rel,

Line 320: igf_ap_fa_base_rec_all base

316: IS
317: SELECT sub_cal_type,
318: sub_ci_sequence_number
319: FROM igs_ca_inst_rel,
320: igf_ap_fa_base_rec_all base
321: WHERE sup_cal_type = base.ci_cal_type
322: AND sup_ci_sequence_number = base.ci_sequence_number
323: AND base.base_id = p_base_id;
324:

Line 334: CURSOR c_get_base_id (cp_person_id igf_ap_fa_base_rec.person_id%TYPE,

330: FROM igs_en_atd_type_load
331: WHERE cal_type = l_cal_type);
332: l_full_att c_att_type%ROWTYPE;
333:
334: CURSOR c_get_base_id (cp_person_id igf_ap_fa_base_rec.person_id%TYPE,
335: cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
336: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE)
337: IS
338: SELECT base_id

Line 335: cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,

331: WHERE cal_type = l_cal_type);
332: l_full_att c_att_type%ROWTYPE;
333:
334: CURSOR c_get_base_id (cp_person_id igf_ap_fa_base_rec.person_id%TYPE,
335: cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
336: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE)
337: IS
338: SELECT base_id
339: FROM igf_ap_fa_base_rec_all

Line 336: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE)

332: l_full_att c_att_type%ROWTYPE;
333:
334: CURSOR c_get_base_id (cp_person_id igf_ap_fa_base_rec.person_id%TYPE,
335: cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
336: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE)
337: IS
338: SELECT base_id
339: FROM igf_ap_fa_base_rec_all
340: WHERE person_id = cp_person_id

Line 339: FROM igf_ap_fa_base_rec_all

335: cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE,
336: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE)
337: IS
338: SELECT base_id
339: FROM igf_ap_fa_base_rec_all
340: WHERE person_id = cp_person_id
341: AND ci_cal_type = cp_ci_cal_type
342: AND ci_sequence_number = cp_ci_sequence_number;
343: