DBA Data[Home] [Help]

APPS.IGS_FI_PRC_DISC_SUA dependencies on IGS_EN_DCNT_REASONCD_ALL

Line 85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all

81:
82: -- Cursor for validation of the Discontinuation Reason Code
83: CURSOR cur_dcnt_reason_cd(cp_dcnt_reason_cd IN VARCHAR2) IS
84: SELECT description
85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all
86: FROM igs_en_dcnt_reasoncd_all
87: WHERE discontinuation_reason_cd = cp_dcnt_reason_cd
88: AND closed_ind = g_no_ind
89: AND dcnt_unit_ind = g_yes_ind;

Line 86: FROM igs_en_dcnt_reasoncd_all

82: -- Cursor for validation of the Discontinuation Reason Code
83: CURSOR cur_dcnt_reason_cd(cp_dcnt_reason_cd IN VARCHAR2) IS
84: SELECT description
85: -- Bug#5018036: Replaced igs_en_dcnt_reasoncd_v by igs_en_dcnt_reasoncd_all
86: FROM igs_en_dcnt_reasoncd_all
87: WHERE discontinuation_reason_cd = cp_dcnt_reason_cd
88: AND closed_ind = g_no_ind
89: AND dcnt_unit_ind = g_yes_ind;
90: