APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_EN_NSD_DLSTP_ALL

Line 9538: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsd_dlstp with igs_en_nsd_dlstp_all for cursor cur_disc_details

9534:
9535: Known limitations,enhancements,remarks:
9536: Change History
9537: Who When What
9538: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsd_dlstp with igs_en_nsd_dlstp_all for cursor cur_disc_details
9539: in proccedure Assign_defaults
9540: ***********************************************************************************************/
9541: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
9542: l_n_non_std_disc_dl_stp_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;

Line 9716: FROM igs_en_nsd_dlstp_all

9712: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9713:
9714: CURSOR cur_disc_details (cp_org_unit_cd IN VARCHAR2,cp_administrative_unit_status IN VARCHAR2) IS
9715: SELECT formula_method,round_method,offset_duration,non_std_disc_dl_stp_id,offset_dt_code,org_unit_code,definition_code
9716: FROM igs_en_nsd_dlstp_all
9717: WHERE ((org_unit_code = cp_org_unit_cd AND definition_code = 'ORGANIZATIONAL_UNIT') OR definition_code = 'INSTITUTION')
9718: AND administrative_unit_status = cp_administrative_unit_status;
9719: l_cur_disc_details cur_disc_details%ROWTYPE;
9720: