DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_EN_NSTD_USEC_DL

Line 20: prraj 11-Dec-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V

16: Nishikant 07OCT2002 UK Enhancement build. Bug#2580731. Five new parameters p_start_day, p_start_month,
17: p_end_day, p_end_month, p_selection_date added in the procedure enrp_ins_btch_prenrl.
18: Nishikant 16DEC2002 ENCR030(UK Enh) - Bug#2708430. One more parameter p_completion_date added in the procedure
19: enrp_ins_btch_prenrl.
20: prraj 11-Dec-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V
21: with base table IGS_EN_NSTD_USEC_DL Bug# 2750716
22: knaraset 05-Mar-2003 Modified the date comparison in function enrp_get_ua_del_alwd,
23: such that it returns N, when the first unit discontinuation date is
24: less than or equal to the given effective date. Bug 2833794

Line 21: with base table IGS_EN_NSTD_USEC_DL Bug# 2750716

17: p_end_day, p_end_month, p_selection_date added in the procedure enrp_ins_btch_prenrl.
18: Nishikant 16DEC2002 ENCR030(UK Enh) - Bug#2708430. One more parameter p_completion_date added in the procedure
19: enrp_ins_btch_prenrl.
20: prraj 11-Dec-2003 Replaced reference to view IGS_EN_NSTD_USEC_DL_V
21: with base table IGS_EN_NSTD_USEC_DL Bug# 2750716
22: knaraset 05-Mar-2003 Modified the date comparison in function enrp_get_ua_del_alwd,
23: such that it returns N, when the first unit discontinuation date is
24: less than or equal to the given effective date. Bug 2833794
25: myoganat 23-May-2003 Created cursor cur_no_assesment_ind in ENRP_VAL_CHG_CP to

Line 712: FROM igs_en_nstd_usec_dl

708: -- at the unit level for the logged on person and for the uoo_id passed
709: CURSOR cur_en_nstd_usec_dl
710: IS
711: SELECT enr_dl_date
712: FROM igs_en_nstd_usec_dl
713: WHERE uoo_id = p_uoo_id
714: AND function_name='VARIATION_CUTOFF'
715: ORDER BY enr_dl_date;
716:

Line 2295: FROM igs_en_nstd_usec_dl

2291: -- Cursor for getting different grading schemas defined at the Unit Level
2292: CURSOR cur_en_nstd_usec
2293: IS
2294: SELECT enr_dl_date alias_val
2295: FROM igs_en_nstd_usec_dl
2296: WHERE function_name = 'GRADING_SCHEMA'
2297: AND uoo_id = p_uoo_id
2298: ORDER BY 1;
2299:

Line 2526: FROM igs_en_nstd_usec_dl

2522: --Check if deadline has passed for cp change at usec level
2523: CURSOR cur_en_nstd_usec
2524: IS
2525: SELECT enr_dl_date alias_val
2526: FROM igs_en_nstd_usec_dl
2527: WHERE function_name = 'GRADING_SCHEMA'
2528: AND uoo_id = p_uoo_id
2529: ORDER BY 1;
2530: