DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_LOOKUP_VALUES

Line 668: IGS_LOOKUP_VALUES lkp

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
672: cft.FEE_TYPE = p_fee_type AND

Line 690: IGS_LOOKUP_VALUES lkp

686: uft.unit_cd code,
687: uft.version_number
688: FROM IGS_FI_UNIT_FEE_TRG uft,
689: IGS_PS_UNIT_VER uv,
690: IGS_LOOKUP_VALUES lkp
691: WHERE uft.FEE_CAT = p_fee_cat AND
692: uft.fee_cal_type = p_fee_cal_type AND
693: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
694: uft.FEE_TYPE = p_fee_type AND

Line 711: IGS_LOOKUP_VALUES lkp

707: SELECT usft.unit_set_cd code, usft.version_number,
708: lkp.lookup_code trigger_type_code
709: FROM IGS_EN_UNITSETFEETRG usft,
710: IGS_EN_UNIT_SET us,
711: IGS_LOOKUP_VALUES lkp
712: WHERE usft.FEE_CAT = p_fee_cat AND
713: usft.fee_cal_type = p_fee_cal_type AND
714: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
715: usft.FEE_TYPE = p_fee_type AND