APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGF_AP_FA_BASE_REC_ALL

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 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: