DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_FI_UNIT_FEE_TRG

Line 595: FROM IGS_FI_UNIT_FEE_TRG uft

591: uft.ci_sequence_number,
592: uft.location_cd,
593: uft.UNIT_CLASS,
594: uft.fee_trigger_group_number
595: FROM IGS_FI_UNIT_FEE_TRG uft
596: WHERE uft.FEE_CAT = p_fee_cat AND
597: uft.fee_cal_type = p_fee_cal_type AND
598: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
599: uft.FEE_TYPE = p_fee_type AND

Line 688: FROM IGS_FI_UNIT_FEE_TRG uft,

684: CURSOR c_ftgv_unit IS
685: SELECT lkp.lookup_code trigger_type_code,
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

Line 735: FROM IGS_FI_UNIT_FEE_TRG uft

731: uft.ci_sequence_number,
732: uft.location_cd,
733: uft.UNIT_CLASS,
734: uft.fee_trigger_group_number
735: FROM IGS_FI_UNIT_FEE_TRG uft
736: WHERE uft.FEE_CAT = p_fee_cat AND
737: uft.fee_cal_type = p_fee_cal_type AND
738: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
739: uft.FEE_TYPE = p_fee_type AND