APPS.IGS_FI_GEN_005 dependencies on IGS_PS_VER

Line 349: IGS_PS_VER cv

345: CURSOR c_ctft IS
346:
347: SELECT ctft.COURSE_TYPE
348: FROM IGS_PS_TYPE_FEE_TRG ctft,
349: IGS_PS_VER cv
350: WHERE ctft.FEE_CAT = p_fee_cat AND
351: ctft.fee_cal_type = p_fee_cal_type AND
352: ctft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
353: ctft.FEE_TYPE = p_fee_type AND

Line 498: IGS_PS_VER crv,

494: SELECT lkp.lookup_code trigger_type_code,
495: cft.course_cd code,
496: cft.version_number
497: FROM IGS_PS_FEE_TRG cft,
498: IGS_PS_VER crv,
499: IGS_LOOKUP_VALUES lkp
500: WHERE cft.FEE_CAT = p_fee_cat AND
501: cft.fee_cal_type = p_fee_cal_type AND
502: cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 513: FROM IGS_PS_VER crv2

509: cft.course_cd = crv.course_cd AND
510: (cft.version_number = crv.version_number OR
511: (cft.version_number IS NULL AND
512: crv.version_number = ( SELECT MAX(crv2.version_number)
513: FROM IGS_PS_VER crv2
514: WHERE crv2.course_cd = crv.course_cd)));
515: CURSOR c_ftgv_unit IS
516: SELECT lkp.lookup_code trigger_type_code,
517: uft.unit_cd code,