APPS.IGS_EN_GEN_004 dependencies on IGS_EN_NSTD_USEC_DL

Line 6: -- prraj 10-Jan-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V

2: /* $Header: IGSEN04B.pls 120.2 2006/08/09 06:56:55 amuthu noship $ */
3:
4: --Changes History:
5: -- knaraset 14-May-2003 Modified call to call_fee_ass to add uoo_id, as part of MUS build bug 2829262
6: -- prraj 10-Jan-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V
7: -- with base table IGS_EN_NSTD_USEC_DL Bug# 2750716
8: -- prraj 06-Jan-2003 Changed message for record cutoff in function Enrp_Get_Rec_Window
9: -- as part of Bug# 2730025
10: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

Line 7: -- with base table IGS_EN_NSTD_USEC_DL Bug# 2750716

3:
4: --Changes History:
5: -- knaraset 14-May-2003 Modified call to call_fee_ass to add uoo_id, as part of MUS build bug 2829262
6: -- prraj 10-Jan-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V
7: -- with base table IGS_EN_NSTD_USEC_DL Bug# 2750716
8: -- prraj 06-Jan-2003 Changed message for record cutoff in function Enrp_Get_Rec_Window
9: -- as part of Bug# 2730025
10: -- pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.

Line 596: CURSOR c_recdt_alias_usec_lvl1( cp_uoo_id IGS_EN_NSTD_USEC_DL.uoo_id%TYPE ) IS

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
598: FROM IGS_EN_NSTD_USEC_DL
599: WHERE function_name = 'RECORD_CUTOFF'
600: AND uoo_id = cp_uoo_id;

Line 598: FROM IGS_EN_NSTD_USEC_DL

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
598: FROM IGS_EN_NSTD_USEC_DL
599: WHERE function_name = 'RECORD_CUTOFF'
600: AND uoo_id = cp_uoo_id;
601:
602: CURSOR c_recdt_alias_usec_lvl2 IS