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_004 dependencies on IGS_PE_PERSON_IMAGE

Line 67: -- for a IGS_PE_PERSON from the IGS_PE_PERSON image table.

63: RETURN DATE AS
64:
65: BEGIN -- enrp_get_pei_dt
66: -- This module finds the date of the latest image
67: -- for a IGS_PE_PERSON from the IGS_PE_PERSON image table.
68: DECLARE
69: v_image_dt IGS_PE_PERSON_IMAGE.image_dt%TYPE;
70: CURSOR c_pei IS
71: SELECT pei.image_dt

Line 69: v_image_dt IGS_PE_PERSON_IMAGE.image_dt%TYPE;

65: BEGIN -- enrp_get_pei_dt
66: -- This module finds the date of the latest image
67: -- for a IGS_PE_PERSON from the IGS_PE_PERSON image table.
68: DECLARE
69: v_image_dt IGS_PE_PERSON_IMAGE.image_dt%TYPE;
70: CURSOR c_pei IS
71: SELECT pei.image_dt
72: FROM IGS_PE_PERSON_IMAGE pei
73: WHERE pei.person_id = p_person_id AND

Line 72: FROM IGS_PE_PERSON_IMAGE pei

68: DECLARE
69: v_image_dt IGS_PE_PERSON_IMAGE.image_dt%TYPE;
70: CURSOR c_pei IS
71: SELECT pei.image_dt
72: FROM IGS_PE_PERSON_IMAGE pei
73: WHERE pei.person_id = p_person_id AND
74: pei.PERSON_IMAGE IS NOT NULL
75: ORDER BY pei.image_dt DESC;
76: BEGIN