APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_LGCY_LVL_INT

Line 337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,

333: +===========================================================================*/
334: l_n_rec_count NUMBER :=0 ;
335:
336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,
337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
340: cp_person_id igs_pe_person.person_id%TYPE,
341: cp_institution_code igs_av_acad_history_v.institution_code%TYPE

Line 338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,

334: l_n_rec_count NUMBER :=0 ;
335:
336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,
337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
340: cp_person_id igs_pe_person.person_id%TYPE,
341: cp_institution_code igs_av_acad_history_v.institution_code%TYPE
342: ) IS

Line 339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,

335:
336: CURSOR c_unit_details_id ( cp_unit igs_ad_term_unitdtls.unit%TYPE,
337: cp_prev_term igs_av_lgcy_lvl_int.prev_term%TYPE,
338: cp_start_date igs_av_lgcy_lvl_int.start_date%TYPE,
339: cp_end_date igs_av_lgcy_lvl_int.end_date%TYPE,
340: cp_person_id igs_pe_person.person_id%TYPE,
341: cp_institution_code igs_av_acad_history_v.institution_code%TYPE
342: ) IS
343: SELECT ahv.unit_details_id