APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AD_TERM_DETAILS

Line 345: igs_ad_term_details td

341: cp_institution_code igs_av_acad_history_v.institution_code%TYPE
342: ) IS
343: SELECT ahv.unit_details_id
344: FROM igs_av_acad_history_v ahv,
345: igs_ad_term_details td
346: WHERE ahv.term_details_id = td.term_details_id
347: AND ahv.term=td.term
348: AND td.term = cp_prev_term
349: AND trunc(td.start_date) = cp_start_date

Line 387: l_start_dt igs_ad_term_details.start_date%TYPE;

383:
384: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE :=null;
385:
386: l_count NUMBER := 0;
387: l_start_dt igs_ad_term_details.start_date%TYPE;
388: l_end_dt igs_ad_term_details.end_date%TYPE;
389: l_return_status VARCHAR2(1000);
390:
391: BEGIN

Line 388: l_end_dt igs_ad_term_details.end_date%TYPE;

384: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE :=null;
385:
386: l_count NUMBER := 0;
387: l_start_dt igs_ad_term_details.start_date%TYPE;
388: l_end_dt igs_ad_term_details.end_date%TYPE;
389: l_return_status VARCHAR2(1000);
390:
391: BEGIN
392: p_s_adv_stnd_type := 'UNIT'; -- initialise