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_PE_PERS_ENCUMB_PKG dependencies on FND_LOOKUP_VALUES_VL

Line 420: CURSOR check_ext_reference (p_lookup_type fnd_lookup_values_vl.lookup_type%TYPE,

416: WHERE resp.application_id = appl.application_id AND
417: responsibility_id = cp_resp_id;
418:
419: --kumma, 2758856, added the following cursor
420: CURSOR check_ext_reference (p_lookup_type fnd_lookup_values_vl.lookup_type%TYPE,
421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,
422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,
423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS
424: SELECT 'X'

Line 421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,

417: responsibility_id = cp_resp_id;
418:
419: --kumma, 2758856, added the following cursor
420: CURSOR check_ext_reference (p_lookup_type fnd_lookup_values_vl.lookup_type%TYPE,
421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,
422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,
423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS
424: SELECT 'X'
425: FROM fnd_lookup_values_vl

Line 422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,

418:
419: --kumma, 2758856, added the following cursor
420: CURSOR check_ext_reference (p_lookup_type fnd_lookup_values_vl.lookup_type%TYPE,
421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,
422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,
423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS
424: SELECT 'X'
425: FROM fnd_lookup_values_vl
426: WHERE lookup_code = p_lookup_code AND

Line 423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS

419: --kumma, 2758856, added the following cursor
420: CURSOR check_ext_reference (p_lookup_type fnd_lookup_values_vl.lookup_type%TYPE,
421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,
422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,
423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS
424: SELECT 'X'
425: FROM fnd_lookup_values_vl
426: WHERE lookup_code = p_lookup_code AND
427: lookup_type = p_lookup_type AND

Line 425: FROM fnd_lookup_values_vl

421: p_lookup_code fnd_lookup_values_vl.lookup_code%TYPE,
422: p_view_application_id fnd_lookup_values_vl.view_application_id%TYPE,
423: p_security_group_id fnd_lookup_values_vl.security_group_id%TYPE) IS
424: SELECT 'X'
425: FROM fnd_lookup_values_vl
426: WHERE lookup_code = p_lookup_code AND
427: lookup_type = p_lookup_type AND
428: view_application_id = p_view_application_id AND
429: security_group_id = p_security_group_id AND