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_EN_GEN_008 dependencies on IGS_PS_OFR_UNIT_SET

Line 614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,

610: p_person_id IN NUMBER )
611: RETURN VARCHAR2 AS
612: BEGIN -- enrp_get_us_title
613: -- This routine will get the IGS_EN_UNIT_SET title from either the
614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,
615: -- taking the lowest level which is set.
616: DECLARE
617: v_override_title igs_as_su_setatmpt.override_title%TYPE;
618: v_cous_override_title igs_ps_ofr_unit_set.override_title%TYPE;

Line 618: v_cous_override_title igs_ps_ofr_unit_set.override_title%TYPE;

614: -- IGS_AS_SU_SETATMPT, IGS_PS_OFR_UNIT_SET or IGS_EN_UNIT_SET table,
615: -- taking the lowest level which is set.
616: DECLARE
617: v_override_title igs_as_su_setatmpt.override_title%TYPE;
618: v_cous_override_title igs_ps_ofr_unit_set.override_title%TYPE;
619: v_us_title igs_en_unit_set.title%TYPE;
620: CURSOR c_susa IS
621: SELECT susa.override_title
622: FROM igs_as_su_setatmpt susa

Line 631: igs_ps_ofr_unit_set cous

627: CURSOR c_us_cous IS
628: SELECT cous.override_title,
629: us.title
630: FROM igs_en_unit_set us,
631: igs_ps_ofr_unit_set cous
632: WHERE us.unit_set_cd = p_unit_set_cd AND
633: us.version_number = p_us_version_number AND
634: cous.unit_set_cd(+) = us.unit_set_cd AND
635: cous.us_version_number(+) = us.version_number AND