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.IGW_PROP dependencies on FND_LOOKUPS

Line 151: v_lookup_meaning fnd_lookups.meaning%TYPE;

147:
148: FUNCTION get_lookup_meaning( p_lookup_type varchar2, p_lookup_code varchar2 )
149: RETURN varchar2 IS
150:
151: v_lookup_meaning fnd_lookups.meaning%TYPE;
152:
153: BEGIN
154:
155: SELECT meaning

Line 157: FROM fnd_lookups

153: BEGIN
154:
155: SELECT meaning
156: INTO v_lookup_meaning
157: FROM fnd_lookups
158: WHERE lookup_type = p_lookup_type
159: AND lookup_code = p_lookup_code;
160:
161: RETURN v_lookup_meaning;

Line 217: FROM fnd_lookups l,

213: BEGIN
214:
215: SELECT l.meaning
216: INTO v_major_subdivision
217: FROM fnd_lookups l,
218: igw_org_details o
219: WHERE o.organization_id = p_organization_id
220: AND l.lookup_type = 'IGW_NIH_MAJOR_SUBDIVISION'
221: AND l.lookup_code = o.nih_subdivision_code;