APPS.IGS_EN_WORKFLOW dependencies on IGS_EN_DCNT_REASONCD

Line 383: FROM igs_en_dcnt_reasoncd

379: -- Getting the Discontinuation Reason for a Discontinuation Type
380:
381: CURSOR cur_discontinue_reason IS
382: SELECT s_discontinuation_reason_type
383: FROM igs_en_dcnt_reasoncd
384: WHERE discontinuation_reason_cd = p_discontincd;
385:
386: l_cur_prof_value cur_prof_value%ROWTYPE;
387: l_cur_user_id cur_user_id%ROWTYPE;

Line 1372: CURSOR c_discon_rsn (cp_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE) IS

1368: FROM igs_pe_person_base_v
1369: WHERE person_id = cp_person_id;
1370:
1371: -- Get the description of discontinuation reason code
1372: CURSOR c_discon_rsn (cp_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE) IS
1373: SELECT description
1374: FROM IGS_EN_DCNT_REASONCD
1375: WHERE DISCONTINUATION_REASON_CD = cp_discon_rsn_cd;
1376:

Line 1374: FROM IGS_EN_DCNT_REASONCD

1370:
1371: -- Get the description of discontinuation reason code
1372: CURSOR c_discon_rsn (cp_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE) IS
1373: SELECT description
1374: FROM IGS_EN_DCNT_REASONCD
1375: WHERE DISCONTINUATION_REASON_CD = cp_discon_rsn_cd;
1376:
1377: -- Get the description of discontinuation reason type
1378: CURSOR c_discon_type (cp_discon_rsn_type igs_lookup_values.lookup_code%TYPE) IS

Line 1388: l_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE;

1384: l_c_discon_rsn c_discon_rsn%ROWTYPE;
1385: l_c_discon_type c_discon_type%ROWTYPE;
1386: l_c_full_name c_full_name%ROWTYPE;
1387:
1388: l_discon_rsn_cd IGS_EN_DCNT_REASONCD.DISCONTINUATION_REASON_CD%TYPE;
1389: l_discon_rsn_type igs_lookup_values.lookup_code%TYPE;
1390:
1391: BEGIN
1392: