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_PS_CAL_RSR_VAL dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,

98:
99: CURSOR cur_uoo1( p_cal_type VARCHAR2,
100: p_ci_sequence_number NUMBER) IS
101: SELECT uoov.*,uoov.rowid row_id,uc.unit_mode,loc.description location_description
102: FROM igs_ps_unit_ofr_opt_all uoov,igs_as_unit_class_all uc, igs_ad_location_all loc,
103: igs_ps_unit_ver_all uv,
104: igs_ps_unit_stat st
105: WHERE uoov.cal_type = p_cal_type AND
106: uoov.ci_sequence_number = p_ci_sequence_number AND

Line 471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

467: uv.unit_status = us.unit_status AND
468: us.s_unit_status <> 'INACTIVE' AND
469: uop.delete_flag='N';
470:
471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,

Line 472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,

468: us.s_unit_status <> 'INACTIVE' AND
469: uop.delete_flag='N';
470:
471: CURSOR cur_ps_unit_ofr_opt_enroll( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
472: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
473: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
474: SELECT uoov.cal_type,
475: uoov.ci_sequence_number,
476: ci.start_dt

Line 487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

483: uoov.version_number = p_version_number
484: ORDER BY ci.start_dt DESC;
485: cur_ps_unit_ofr_opt_enroll_rec cur_ps_unit_ofr_opt_enroll%ROWTYPE;
486:
487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,

Line 488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,

484: ORDER BY ci.start_dt DESC;
485: cur_ps_unit_ofr_opt_enroll_rec cur_ps_unit_ofr_opt_enroll%ROWTYPE;
486:
487: CURSOR cur_ps_unit_ofr_opt_offer( p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
488: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE,
489: p_start_date IGS_CA_INST_ALL.start_dt%TYPE ) IS
490: SELECT uoov.cal_type,
491: uoov.ci_sequence_number,
492: ci.start_dt

Line 515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

511: teach_ci_sequence_number = p_teach_sequence_number
512: ORDER BY load_start_dt DESC;
513: cur_teach_to_load_rec cur_teach_to_load%ROWTYPE;
514:
515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
517: SELECT ci.start_dt start_date
518: FROM igs_ps_unit_ver uv,igs_ca_inst ci
519: WHERE uv.unit_cd = p_unit_cd AND

Line 516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS

512: ORDER BY load_start_dt DESC;
513: cur_teach_to_load_rec cur_teach_to_load%ROWTYPE;
514:
515: CURSOR cur_unit_ver_enroll(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
516: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
517: SELECT ci.start_dt start_date
518: FROM igs_ps_unit_ver uv,igs_ca_inst ci
519: WHERE uv.unit_cd = p_unit_cd AND
520: uv.version_number = p_version_number AND

Line 525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,

521: uv.cal_type_enrol_load_cal = ci.cal_type AND
522: uv.sequence_num_enrol_load_cal = ci.sequence_number;
523: cur_unit_ver_enroll_rec cur_unit_ver_enroll%ROWTYPE;
524:
525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
527: SELECT ci.start_dt start_date
528: FROM igs_ps_unit_ver uv,igs_ca_inst ci
529: WHERE uv.unit_cd = p_unit_cd AND

Line 526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS

522: uv.sequence_num_enrol_load_cal = ci.sequence_number;
523: cur_unit_ver_enroll_rec cur_unit_ver_enroll%ROWTYPE;
524:
525: CURSOR cur_unit_ver_offer(p_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE,
526: p_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE) IS
527: SELECT ci.start_dt start_date
528: FROM igs_ps_unit_ver uv,igs_ca_inst ci
529: WHERE uv.unit_cd = p_unit_cd AND
530: uv.version_number = p_version_number AND