APPS.IGS_FI_VAL_FT dependencies on IGS_PS_FEE_TRG

Line 243: -- so that the records in table IGS_PS_FEE_TRG which are logically deleted

239: --rmaddipa 22-SEP-04 Bug #:3864296 removed calls to functions finpl_get_course_type_trig() and
240: -- finpl_get_course_group_trig() since they are being called from finp_val_ft_trig().
241: --rmaddipa 31-AUG-04 Bug #: 3864296
242: -- Modified the definition of cursor c_crs_fee_trig
243: -- so that the records in table IGS_PS_FEE_TRG which are logically deleted
244: -- are not considered.
245: -------------------------------------------------------------------
246: BEGIN
247: DECLARE

Line 253: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE) IS

249:
250: -- cursor definition modified by rmaddipa ( Bug #: 3864296)
251: -- records that are deleted should'nt be considered
252: CURSOR c_crs_fee_trig (
253: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE) IS
254: SELECT 'x'
255: FROM IGS_PS_FEE_TRG cft
256: WHERE cft.fee_type = cp_fee_type
257: AND logical_delete_dt IS NULL;

Line 255: FROM IGS_PS_FEE_TRG cft

251: -- records that are deleted should'nt be considered
252: CURSOR c_crs_fee_trig (
253: cp_fee_type IGS_PS_FEE_TRG.fee_type%TYPE) IS
254: SELECT 'x'
255: FROM IGS_PS_FEE_TRG cft
256: WHERE cft.fee_type = cp_fee_type
257: AND logical_delete_dt IS NULL;
258:
259: BEGIN

Line 261: -- IGS_PS_GRP_FEE_TRG OR IGS_PS_FEE_TRG tables. If any are found

257: AND logical_delete_dt IS NULL;
258:
259: BEGIN
260: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_TYPE_FEE_TRG,
261: -- IGS_PS_GRP_FEE_TRG OR IGS_PS_FEE_TRG tables. If any are found
262: -- the function should return TRUE otherwise return FALSE.
263: OPEN c_crs_fee_trig (p_fee_type);
264: FETCH c_crs_fee_trig INTO v_dummy;
265: IF(c_crs_fee_trig%FOUND) THEN