APPS.IGS_FI_VAL_FT dependencies on IGS_FI_FEE_RET_SCHD

Line 42: cp_fee_type IGS_FI_FEE_RET_SCHD.fee_type%TYPE) IS

38: -- when related fee_rentention_schedule records exist.
39: DECLARE
40: v_dummy VARCHAR2(1);
41: CURSOR c_fee_retention_schedule (
42: cp_fee_type IGS_FI_FEE_RET_SCHD.fee_type%TYPE) IS
43: SELECT 'x'
44: FROM IGS_FI_FEE_RET_SCHD frs
45: WHERE frs.fee_type = cp_fee_type;
46: -- Removed reference to IGS_FI_FEE_ENCMB(c_fee_encumbrance cursor) table asthe table is obseleted as part of bug 2126091 sykrishn -30112001

Line 44: FROM IGS_FI_FEE_RET_SCHD frs

40: v_dummy VARCHAR2(1);
41: CURSOR c_fee_retention_schedule (
42: cp_fee_type IGS_FI_FEE_RET_SCHD.fee_type%TYPE) IS
43: SELECT 'x'
44: FROM IGS_FI_FEE_RET_SCHD frs
45: WHERE frs.fee_type = cp_fee_type;
46: -- Removed reference to IGS_FI_FEE_ENCMB(c_fee_encumbrance cursor) table asthe table is obseleted as part of bug 2126091 sykrishn -30112001
47:
48: --cursor to check whether any retention schedule exists at teaching period level for a given fee type.

Line 64: -- IGS_FI_FEE_RET_SCHD

60: p_message_name := NULL;
61: Return TRUE;
62: END IF;
63: -- Check if the optional_payment_ind is set to 'Y' if it is look for related
64: -- IGS_FI_FEE_RET_SCHD
65: IF(p_optional_payment_ind = 'Y') THEN
66: -- Check for Fee Retention Schedules related to the Fee Type
67: OPEN c_fee_retention_schedule(
68: p_fee_type);

Line 464: -- IGS_FI_FEE_RET_SCHD

460: -- rule_sequence_number set.
461: -- If changing to INSTITUTN from anything else ensure there are no
462: -- related records at FCFL level for the following:
463: -- IGS_FI_FEE_PAY_SCHD
464: -- IGS_FI_FEE_RET_SCHD
465: -- IGS_FI_FEE_ENCMB - Removed reference from this package-
466: -- IGS_FI_CHG_MTH_APP
467: -- IGS_FI_FEE_AS_RATE
468: -- IGS_FI_ELM_RANGE

Line 480: FROM IGS_FI_FEE_RET_SCHD

476: rul_sequence_number IS NOT NULL);
477:
478: CURSOR c_fee_retention_schedule (cp_fee_type IGS_FI_FEE_TYPE.fee_type%TYPE) IS
479: SELECT 'x'
480: FROM IGS_FI_FEE_RET_SCHD
481: WHERE FEE_TYPE = cp_fee_type AND
482: s_relation_type = 'FCFL';
483:
484: -- Removed reference to IGS_FI_FEE_ENCMB table asthe table is obseleted as part of bug 2126091 sykrishn -30112001