APPS.IGS_AD_PANEL_DTLS_PKG dependencies on IGS_LOOKUPS_VIEW

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

566:
567: rec_dflt_panl_cd cur_dflt_panl_cd%ROWTYPE;
568:
569: -- Cursor to get the meaning for lookup code
570: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
571: SELECT meaning
572: FROM igs_lookups_view
573: WHERE lookup_type = cp_lookup_type
574: AND lookup_code = cp_lookup_code;

Line 572: FROM igs_lookups_view

568:
569: -- Cursor to get the meaning for lookup code
570: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
571: SELECT meaning
572: FROM igs_lookups_view
573: WHERE lookup_type = cp_lookup_type
574: AND lookup_code = cp_lookup_code;
575:
576: l_class_meaning igs_lookups_view.meaning%TYPE;

Line 576: l_class_meaning igs_lookups_view.meaning%TYPE;

572: FROM igs_lookups_view
573: WHERE lookup_type = cp_lookup_type
574: AND lookup_code = cp_lookup_code;
575:
576: l_class_meaning igs_lookups_view.meaning%TYPE;
577: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
578:
579: -- Cursor to check for panel level.
580: CURSOR c_panel_level_code IS

Line 577: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;

573: WHERE lookup_type = cp_lookup_type
574: AND lookup_code = cp_lookup_code;
575:
576: l_class_meaning igs_lookups_view.meaning%TYPE;
577: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
578:
579: -- Cursor to check for panel level.
580: CURSOR c_panel_level_code IS
581: SELECT panel_level_code

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

946:
947: rec_panel_membrs c_get_panel_membrs%ROWTYPE;
948:
949: -- Cursor to get the meaning for lookup code
950: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
951: SELECT meaning
952: FROM igs_lookups_view
953: WHERE lookup_type = cp_lookup_type
954: AND lookup_code = cp_lookup_code;

Line 952: FROM igs_lookups_view

948:
949: -- Cursor to get the meaning for lookup code
950: CURSOR c_lkup_cd_mean(cp_lookup_type igs_lookups_view.lookup_type%TYPE, cp_lookup_code igs_lookups_view.lookup_code%TYPE) IS
951: SELECT meaning
952: FROM igs_lookups_view
953: WHERE lookup_type = cp_lookup_type
954: AND lookup_code = cp_lookup_code;
955:
956: l_class_meaning igs_lookups_view.meaning%TYPE;

Line 956: l_class_meaning igs_lookups_view.meaning%TYPE;

952: FROM igs_lookups_view
953: WHERE lookup_type = cp_lookup_type
954: AND lookup_code = cp_lookup_code;
955:
956: l_class_meaning igs_lookups_view.meaning%TYPE;
957: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
958:
959: l_history_date igs_ad_pnl_his_dtls.history_date%TYPE;
960:

Line 957: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;

953: WHERE lookup_type = cp_lookup_type
954: AND lookup_code = cp_lookup_code;
955:
956: l_class_meaning igs_lookups_view.meaning%TYPE;
957: l_sys_stat_meaning igs_lookups_view.meaning%TYPE;
958:
959: l_history_date igs_ad_pnl_his_dtls.history_date%TYPE;
960:
961: CURSOR c_panel_type IS