eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AV_VAL_ASU dependencies on IGS_AV_ADV_STANDING

Line 46: cp_exempt_inst igs_av_adv_standing.exemption_institution_cd%TYPE

42: gv_other_detail VARCHAR2 (255);
43: BEGIN
44: DECLARE
45: CURSOR c_adv_stnd_exempt_inst_v (
46: cp_exempt_inst igs_av_adv_standing.exemption_institution_cd%TYPE
47: ) IS
48: SELECT ihp.oss_org_unit_cd exemption_institution_cd
49: FROM igs_pe_hz_parties ihp
50: WHERE ihp.inst_org_ind = 'I'

Line 200: -- Validate that IGS_AV_ADV_STANDING related dates are not

196: RETURN BOOLEAN IS
197: gv_other_detail VARCHAR2 (255);
198: BEGIN
199: -- advp_val_as_dates
200: -- Validate that IGS_AV_ADV_STANDING related dates are not
201: -- greater than the current date.
202: DECLARE
203: v_ret_val BOOLEAN := TRUE;
204: BEGIN

Line 590: v_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;

586: v_external_adv_stnd_total NUMBER;
587: v_internal_adv_stnd_total NUMBER;
588: -- 16-Oct-2002; kdande; Bug# 2627933
589: -- Changed the data type to column%TYPE to avoid value error.
590: v_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
591: v_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
592: v_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
593: v_add_in_totals BOOLEAN;
594: v_adv_stnd c_adv_stnd_unit_details%ROWTYPE;

Line 591: v_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;

587: v_internal_adv_stnd_total NUMBER;
588: -- 16-Oct-2002; kdande; Bug# 2627933
589: -- Changed the data type to column%TYPE to avoid value error.
590: v_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
591: v_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
592: v_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
593: v_add_in_totals BOOLEAN;
594: v_adv_stnd c_adv_stnd_unit_details%ROWTYPE;
595: v_credits NUMBER;

Line 592: v_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;

588: -- 16-Oct-2002; kdande; Bug# 2627933
589: -- Changed the data type to column%TYPE to avoid value error.
590: v_total_exmptn_approved igs_av_adv_standing_all.total_exmptn_approved%TYPE;
591: v_total_exmptn_granted igs_av_adv_standing_all.total_exmptn_granted%TYPE;
592: v_total_exmptn_perc_grntd igs_av_adv_standing_all.total_exmptn_perc_grntd%TYPE;
593: v_add_in_totals BOOLEAN;
594: v_adv_stnd c_adv_stnd_unit_details%ROWTYPE;
595: v_credits NUMBER;
596: v_inst_credits NUMBER;