APPS.IGS_FI_VAL_FT dependencies on IGS_PS_GRP_FEE_TRG

Line 197: p_fee_type IGS_PS_GRP_FEE_TRG.fee_type%TYPE)

193: RETURN FALSE;
194: END;
195: END finpl_get_course_type_trig;
196: FUNCTION finpl_get_course_group_trig(
197: p_fee_type IGS_PS_GRP_FEE_TRG.fee_type%TYPE)
198: RETURN BOOLEAN AS
199: ------------------------------------------------------------------
200: --Change History:
201: --Who When What

Line 204: -- so that the records in table IGS_PS_GRP_FEE_TRG which are logically deleted

200: --Change History:
201: --Who When What
202: --rmaddipa 2-SEP-04 Bug #: 3864296
203: -- Modified the definition of cursor c_crs_grp_fee_trig
204: -- so that the records in table IGS_PS_GRP_FEE_TRG which are logically deleted
205: -- are not considered.
206: -------------------------------------------------------------------
207: BEGIN
208: DECLARE

Line 214: cp_fee_type IGS_PS_GRP_FEE_TRG.fee_type%TYPE) IS

210:
211: -- cursor definition modified by rmaddipa ( Bug #: 3864296)
212: -- records that are deleted should'nt be considered
213: CURSOR c_crs_grp_fee_trig (
214: cp_fee_type IGS_PS_GRP_FEE_TRG.fee_type%TYPE) IS
215: SELECT 'x'
216: FROM IGS_PS_GRP_FEE_TRG cgft
217: WHERE cgft.fee_type = cp_fee_type
218: AND logical_delete_dt IS NULL;

Line 216: FROM IGS_PS_GRP_FEE_TRG cgft

212: -- records that are deleted should'nt be considered
213: CURSOR c_crs_grp_fee_trig (
214: cp_fee_type IGS_PS_GRP_FEE_TRG.fee_type%TYPE) IS
215: SELECT 'x'
216: FROM IGS_PS_GRP_FEE_TRG cgft
217: WHERE cgft.fee_type = cp_fee_type
218: AND logical_delete_dt IS NULL;
219: BEGIN
220: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_GRP_FEE_TRG table.

Line 220: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_GRP_FEE_TRG table.

216: FROM IGS_PS_GRP_FEE_TRG cgft
217: WHERE cgft.fee_type = cp_fee_type
218: AND logical_delete_dt IS NULL;
219: BEGIN
220: -- Check for IGS_PS_COURSE Trigger records in the IGS_PS_GRP_FEE_TRG table.
221: -- If any are found the function should return TRUE otherwise return FALSE.
222: OPEN c_crs_grp_fee_trig(
223: p_fee_type);
224: FETCH c_crs_grp_fee_trig INTO v_dummy;

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