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
503: cft.FEE_TYPE = p_fee_type AND
517: uft.unit_cd code,
518: uft.version_number
519: FROM IGS_FI_UNIT_FEE_TRG uft,
520: IGS_PS_UNIT_VER uv,
521: IGS_LOOKUP_VALUES lkp
522: WHERE uft.FEE_CAT = p_fee_cat AND
523: uft.fee_cal_type = p_fee_cal_type AND
524: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
525: uft.FEE_TYPE = p_fee_type AND
538: SELECT usft.unit_set_cd code, usft.version_number,
539: lkp.lookup_code trigger_type_code
540: FROM IGS_EN_UNITSETFEETRG usft,
541: IGS_EN_UNIT_SET us,
542: IGS_LOOKUP_VALUES lkp
543: WHERE usft.FEE_CAT = p_fee_cat AND
544: usft.fee_cal_type = p_fee_cal_type AND
545: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
546: usft.FEE_TYPE = p_fee_type AND