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_PR_GEN_005 dependencies on IGS_PR_S_PRG_CONF

Line 407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;

403: BEGIN -- IGS_PR_get_appeal_alwd
404: -- Determine whether an appeal is permitted on a nominated outcome.
405: DECLARE
406: v_override_appeal_ind igs_pr_ru_ou.override_appeal_ind%TYPE;
407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

Line 408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;

404: -- Determine whether an appeal is permitted on a nominated outcome.
405: DECLARE
406: v_override_appeal_ind igs_pr_ru_ou.override_appeal_ind%TYPE;
407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

Line 409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;

405: DECLARE
406: v_override_appeal_ind igs_pr_ru_ou.override_appeal_ind%TYPE;
407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

Line 410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;

406: v_override_appeal_ind igs_pr_ru_ou.override_appeal_ind%TYPE;
407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

Line 411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

407: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

Line 412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

408: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

Line 413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

409: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

Line 414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

410: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

Line 415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

411: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

Line 416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

412: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

Line 417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

413: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

Line 418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

414: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
422: CURSOR c_pro IS

Line 419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

415: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
422: CURSOR c_pro IS
423: SELECT pro.override_appeal_ind

Line 420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

416: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
422: CURSOR c_pro IS
423: SELECT pro.override_appeal_ind
424: FROM igs_pr_rule_out_v pro

Line 421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

417: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
418: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
419: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
420: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
421: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
422: CURSOR c_pro IS
423: SELECT pro.override_appeal_ind
424: FROM igs_pr_rule_out_v pro
425: WHERE pro.progression_rule_cat = p_progression_rule_cat

Line 488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;

484: BEGIN -- IGS_PR_get_cause_alwd
485: -- Determine whether a show cause is permitted on a nominated outcome.
486: DECLARE
487: v_override_show_cause_ind igs_pr_ru_ou.override_show_cause_ind%TYPE;
488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

Line 489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;

485: -- Determine whether a show cause is permitted on a nominated outcome.
486: DECLARE
487: v_override_show_cause_ind igs_pr_ru_ou.override_show_cause_ind%TYPE;
488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

Line 490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;

486: DECLARE
487: v_override_show_cause_ind igs_pr_ru_ou.override_show_cause_ind%TYPE;
488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

Line 491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;

487: v_override_show_cause_ind igs_pr_ru_ou.override_show_cause_ind%TYPE;
488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

Line 492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

488: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

Line 493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

489: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

Line 494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

490: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

Line 495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

491: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

Line 496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

492: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

Line 497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

493: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

Line 498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

494: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

Line 499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

495: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
503: CURSOR c_pro IS

Line 500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

496: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
503: CURSOR c_pro IS
504: SELECT pro.override_show_cause_ind

Line 501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

497: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
503: CURSOR c_pro IS
504: SELECT pro.override_show_cause_ind
505: FROM igs_pr_rule_out_v pro

Line 502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

498: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
499: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
500: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
501: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
502: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
503: CURSOR c_pro IS
504: SELECT pro.override_show_cause_ind
505: FROM igs_pr_rule_out_v pro
506: WHERE pro.progression_rule_cat = p_progression_rule_cat

Line 673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;

669: cst_eb CONSTANT VARCHAR2 (2) := 'EB';
670: cst_ep CONSTANT VARCHAR2 (2) := 'EP';
671: v_dt_alias VARCHAR2 (10);
672: v_alias_val DATE;
673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

Line 674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;

670: cst_ep CONSTANT VARCHAR2 (2) := 'EP';
671: v_dt_alias VARCHAR2 (10);
672: v_alias_val DATE;
673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

Line 675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;

671: v_dt_alias VARCHAR2 (10);
672: v_alias_val DATE;
673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

Line 676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;

672: v_alias_val DATE;
673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

Line 677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;

673: v_apply_start_dt_alias igs_pr_s_prg_conf.apply_start_dt_alias%TYPE;
674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

Line 678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;

674: v_apply_end_dt_alias igs_pr_s_prg_conf.apply_end_dt_alias%TYPE;
675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

Line 679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;

675: v_end_benefit_dt_alias igs_pr_s_prg_conf.end_benefit_dt_alias%TYPE;
676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

Line 680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;

676: v_end_penalty_dt_alias igs_pr_s_prg_conf.end_penalty_dt_alias%TYPE;
677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

Line 681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;

677: v_show_cause_cutoff_dt_alias igs_pr_s_prg_conf.show_cause_cutoff_dt_alias%TYPE;
678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

Line 682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;

678: v_appeal_cutoff_dt_alias igs_pr_s_prg_conf.appeal_cutoff_dt_alias%TYPE;
679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

Line 683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;

679: v_show_cause_ind igs_pr_s_prg_conf.show_cause_ind%TYPE;
680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

Line 684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;

680: v_apply_before_show_ind igs_pr_s_prg_conf.apply_before_show_ind%TYPE;
681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
688: CURSOR c_dai (cp_dt_alias VARCHAR2) IS

Line 685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;

681: v_appeal_ind igs_pr_s_prg_conf.appeal_ind%TYPE;
682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
688: CURSOR c_dai (cp_dt_alias VARCHAR2) IS
689: SELECT igs_ca_gen_001.calp_get_alias_val (

Line 686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;

682: v_apply_before_appeal_ind igs_pr_s_prg_conf.apply_before_appeal_ind%TYPE;
683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
688: CURSOR c_dai (cp_dt_alias VARCHAR2) IS
689: SELECT igs_ca_gen_001.calp_get_alias_val (
690: dai.dt_alias,

Line 687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;

683: v_count_sus_in_time_ind igs_pr_s_prg_conf.count_sus_in_time_ind%TYPE;
684: v_count_exc_in_time_ind igs_pr_s_prg_conf.count_exc_in_time_ind%TYPE;
685: v_calculate_wam_ind igs_pr_s_prg_conf.calculate_wam_ind%TYPE;
686: v_calculate_gpa_ind igs_pr_s_prg_conf.calculate_gpa_ind%TYPE;
687: v_outcome_check_type igs_pr_s_prg_conf.outcome_check_type%TYPE;
688: CURSOR c_dai (cp_dt_alias VARCHAR2) IS
689: SELECT igs_ca_gen_001.calp_get_alias_val (
690: dai.dt_alias,
691: dai.sequence_number,

Line 781: igs_pr_s_prg_conf spc

777: dai.ci_sequence_number
778: )
779: )
780: FROM igs_ca_da_inst dai,
781: igs_pr_s_prg_conf spc
782: WHERE dai.cal_type = p_prg_cal_type
783: AND dai.ci_sequence_number = p_prg_sequence_number
784: AND dai.dt_alias = spc.encumb_end_dt_alias
785: ORDER BY 1 DESC;