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_AS_SS_DOC_REQUEST dependencies on IGS_PS_VER

Line 595: igs_ps_ver_all pv

591: cp_course_type igs_ps_type.course_type%TYPE
592: ) IS
593: SELECT spa.commencement_dt
594: FROM igs_en_stdnt_ps_att_all spa,
595: igs_ps_ver_all pv
596: WHERE spa.person_id = cp_person_id
597: AND pv.course_type = cp_course_type
598: AND spa.course_cd = pv.course_cd
599: AND spa.version_number = pv.version_number

Line 609: igs_ps_ver_all pv

605: cp_course_type igs_ps_type.course_type%TYPE
606: ) IS
607: SELECT spa.course_rqrmnts_complete_dt
608: FROM igs_en_stdnt_ps_att_all spa,
609: igs_ps_ver_all pv
610: WHERE spa.person_id = cp_person_id
611: AND pv.course_type = cp_course_type
612: AND spa.course_cd = pv.course_cd
613: AND spa.version_number = pv.version_number

Line 3333: FUNCTION get_latest_yop (p_person_id hz_parties.party_id%TYPE, p_course_cd igs_ps_ver.course_cd%TYPE)

3329: retcode := 2; --l_RETURN_STATUS;
3330: RETURN;
3331: END bulk_order_job;
3332:
3333: FUNCTION get_latest_yop (p_person_id hz_parties.party_id%TYPE, p_course_cd igs_ps_ver.course_cd%TYPE)
3334: RETURN VARCHAR2 IS
3335: CURSOR c_susa IS
3336: SELECT susa.unit_set_cd
3337: FROM igs_as_su_setatmpt susa