APPS.IGS_FI_GEN_008 dependencies on IGS_EN_DCNT_REASONCD

Line 1202: FUNCTION chk_unit_prg_transfer(p_v_disc_reason_code IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE) RETURN VARCHAR2 AS

1198: END Mask_Card_Number;
1199:
1200: -- Function to check if the Unit in context (UOO_ID) has been part of a Program Transfer or not.
1201: -- Returns Y or N
1202: FUNCTION chk_unit_prg_transfer(p_v_disc_reason_code IN igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE) RETURN VARCHAR2 AS
1203: /***********************************************************************************************
1204: Created By : abshriva
1205: Date Created : 17-May-2006
1206: Purpose : Fuction to check if the unit dropped was due to program transfer or not.

Line 1215: CURSOR cur_chk_transfer(cp_v_disc_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE) IS

1211: ***********************************************************************************************/
1212:
1213: -- Cursor to find out if the unit has been dropped due to a Program Transfer, in which case Retention
1214: -- calculation needs to be skipped for the unit drop.
1215: CURSOR cur_chk_transfer(cp_v_disc_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE) IS
1216: SELECT 'x'
1217: FROM igs_en_dcnt_reasoncd
1218: WHERE s_discontinuation_reason_type = 'UNIT_TRANS'
1219: AND discontinuation_reason_cd = cp_v_disc_reason_cd;

Line 1217: FROM igs_en_dcnt_reasoncd

1213: -- Cursor to find out if the unit has been dropped due to a Program Transfer, in which case Retention
1214: -- calculation needs to be skipped for the unit drop.
1215: CURSOR cur_chk_transfer(cp_v_disc_reason_cd igs_en_dcnt_reasoncd.discontinuation_reason_cd%TYPE) IS
1216: SELECT 'x'
1217: FROM igs_en_dcnt_reasoncd
1218: WHERE s_discontinuation_reason_type = 'UNIT_TRANS'
1219: AND discontinuation_reason_cd = cp_v_disc_reason_cd;
1220:
1221: l_v_transferred VARCHAR2(1);