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

Line 514: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS

510:
511: l_panel_type_Code igs_ad_intvw_pnls.panel_type_Code%TYPE;
512:
513: -- Cursor to get the meaning for lookup code
514: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
515: SELECT meaning
516: FROM igs_lookups_view
517: WHERE lookup_type = cp_lookup_type
518: AND lookup_code = cp_lookup_code;

Line 516: FROM igs_lookups_view

512:
513: -- Cursor to get the meaning for lookup code
514: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
515: SELECT meaning
516: FROM igs_lookups_view
517: WHERE lookup_type = cp_lookup_type
518: AND lookup_code = cp_lookup_code;
519:
520: l_class_meaning igs_lookups_view.meaning%TYPE;

Line 520: l_class_meaning igs_lookups_view.meaning%TYPE;

516: FROM igs_lookups_view
517: WHERE lookup_type = cp_lookup_type
518: AND lookup_code = cp_lookup_code;
519:
520: l_class_meaning igs_lookups_view.meaning%TYPE;
521: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
522: l_dec_type igs_ad_code_classes.class%TYPE;
523:
524: BEGIN

Line 521: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;

517: WHERE lookup_type = cp_lookup_type
518: AND lookup_code = cp_lookup_code;
519:
520: l_class_meaning igs_lookups_view.meaning%TYPE;
521: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
522: l_dec_type igs_ad_code_classes.class%TYPE;
523:
524: BEGIN
525: IF NVL(p_inserting,FALSE) THEN