APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_DCNT_REASONCD

Line 928: FROM igs_en_dcnt_reasoncd

924:
925: -- Get the discontinuation reason code.
926: CURSOR c_drop_reason IS
927: SELECT DISCONTINUATION_REASON_CD
928: FROM igs_en_dcnt_reasoncd
929: WHERE S_DISCONTINUATION_REASON_TYPE = 'SWAP'
930: AND SYS_DFLT_IND = 'Y'
931: AND ROWNUM < 2 ;
932:

Line 944: l_c_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;

940: AND sua.uoo_id = cp_n_uoo_id;
941:
942: TYPE c_ref_cursor IS REF CURSOR;
943: c_ref_cur_coreq_prereq c_ref_cursor;
944: l_c_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE;
945: l_uoo_ids varchar2(32000);
946: pos number;
947: l_cur_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE; -- current uoo_id
948: l_start_index NUMBER;