APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_EN_NSU_DLSTP_ALL

Line 8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details

8966:
8967: Known limitations,enhancements,remarks:
8968: Change History
8969: Who When What
8970: Sommukhe 13-Jan-2006 Bug #4926548 replaced igs_en_nsu_dlstp with igs_en_nsu_dlstp_all for cursor cur_dead_details
8971: in proccedure Assign_defaults
8972: ***********************************************************************************************/
8973: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
8974: l_n_non_std_usec_dls_id igs_en_nsu_dlstp.non_std_usec_dls_id%TYPE;

Line 9136: FROM igs_en_nsu_dlstp_all

9132: l_c_org_unit_cd igs_ps_unit_ofr_opt_all.owner_org_unit_cd%TYPE;
9133:
9134: CURSOR cur_dead_details (cp_org_unit_cd IN VARCHAR2,cp_function_name IN VARCHAR2) IS
9135: SELECT formula_method,round_method,offset_duration,non_std_usec_dls_id,offset_dt_code,org_unit_code,definition_code
9136: FROM igs_en_nsu_dlstp_all
9137: WHERE ((org_unit_code = cp_org_unit_cd AND definition_code = 'ORGANIZATIONAL_UNIT') OR definition_code = 'INSTITUTION')
9138: AND function_name = cp_function_name;
9139: l_cur_dead_details cur_dead_details%ROWTYPE;
9140: