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_GEN_007 dependencies on IGS_LOOKUPS_VIEW

Line 12: v_s_reference_cd_type IGS_LOOKUPS_VIEW.lookup_code%TYPE;

8: BEGIN
9: -- crsp_get_rct_srct
10: -- This module returns the system reference code type
11: DECLARE
12: v_s_reference_cd_type IGS_LOOKUPS_VIEW.lookup_code%TYPE;
13: CURSOR c_rct_srct IS
14: SELECT srct.lookup_code
15: FROM IGS_GE_REF_CD_TYPE rct,
16: IGS_LOOKUPS_VIEW srct

Line 16: IGS_LOOKUPS_VIEW srct

12: v_s_reference_cd_type IGS_LOOKUPS_VIEW.lookup_code%TYPE;
13: CURSOR c_rct_srct IS
14: SELECT srct.lookup_code
15: FROM IGS_GE_REF_CD_TYPE rct,
16: IGS_LOOKUPS_VIEW srct
17: WHERE rct.reference_cd_type = p_reference_cd_type AND
18: rct.closed_ind = 'N' AND
19: srct.lookup_code = rct.s_reference_cd_type AND
20: srct.lookup_type = 'REFERENCE_CD_TYPE' AND