APPS.IGS_EN_GEN_004 dependencies on IGS_PS_UNIT_OFR_OPT

Line 592: CURSOR cur_non_std_usec_ind(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS

588: AND alias_val IS NOT NULL
589: ORDER BY alias_val DESC;
590:
591: -- Cursor to check the Non-Standard Unit Section
592: CURSOR cur_non_std_usec_ind(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
593: SELECT non_std_usec_ind FROM IGS_PS_UNIT_OFR_OPT
594: WHERE uoo_id = p_uoo_id;
595:
596: CURSOR c_recdt_alias_usec_lvl1( cp_uoo_id IGS_EN_NSTD_USEC_DL.uoo_id%TYPE ) IS

Line 593: SELECT non_std_usec_ind FROM IGS_PS_UNIT_OFR_OPT

589: ORDER BY alias_val DESC;
590:
591: -- Cursor to check the Non-Standard Unit Section
592: CURSOR cur_non_std_usec_ind(p_uoo_id IGS_PS_UNIT_OFR_OPT.uoo_id%TYPE) IS
593: SELECT non_std_usec_ind FROM IGS_PS_UNIT_OFR_OPT
594: WHERE uoo_id = p_uoo_id;
595:
596: CURSOR c_recdt_alias_usec_lvl1( cp_uoo_id IGS_EN_NSTD_USEC_DL.uoo_id%TYPE ) IS
597: SELECT enr_dl_date

Line 613: l_non_std_usec_ind IGS_PS_UNIT_OFR_OPT.non_std_usec_ind%TYPE;

609: record_cutoff_dt_alias
610: FROM IGS_EN_CAL_CONF
611: WHERE s_control_num = 1;
612:
613: l_non_std_usec_ind IGS_PS_UNIT_OFR_OPT.non_std_usec_ind%TYPE;
614:
615: BEGIN
616:
617: -- initialize the message parameter with NULL