DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_LOOKUP_VALUES

Line 499: IGS_LOOKUP_VALUES lkp

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

Line 521: IGS_LOOKUP_VALUES lkp

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

Line 542: IGS_LOOKUP_VALUES lkp

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