APPS.IGS_FI_GEN_001 dependencies on IGS_PS_VER

Line 551: IGS_PS_VER cv

547: WHERE ft.FEE_TYPE = p_fee_type;
548: CURSOR c_ctft IS
549: SELECT ctft.COURSE_TYPE
550: FROM IGS_PS_TYPE_FEE_TRG ctft,
551: IGS_PS_VER cv
552: WHERE ctft.FEE_CAT = p_fee_cat AND
553: ctft.fee_cal_type = p_fee_cal_type AND
554: ctft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
555: ctft.FEE_TYPE = p_fee_type AND

Line 667: IGS_PS_VER crv,

663: SELECT lkp.lookup_code trigger_type_code,
664: cft.course_cd code,
665: cft.version_number
666: FROM IGS_PS_FEE_TRG cft,
667: IGS_PS_VER crv,
668: IGS_LOOKUP_VALUES lkp
669: WHERE cft.FEE_CAT = p_fee_cat AND
670: cft.fee_cal_type = p_fee_cal_type AND
671: cft.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 682: FROM IGS_PS_VER crv2

678: cft.course_cd = crv.course_cd AND
679: (cft.version_number = crv.version_number OR
680: (cft.version_number IS NULL AND
681: crv.version_number = ( SELECT MAX(crv2.version_number)
682: FROM IGS_PS_VER crv2
683: WHERE crv2.course_cd = crv.course_cd)));
684: CURSOR c_ftgv_unit IS
685: SELECT lkp.lookup_code trigger_type_code,
686: uft.unit_cd code,