DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_FI_UNIT_FEE_TRG

Line 399: FROM IGS_FI_UNIT_FEE_TRG uft

395: uft.ci_sequence_number,
396: uft.location_cd,
397: uft.UNIT_CLASS,
398: uft.fee_trigger_group_number
399: FROM IGS_FI_UNIT_FEE_TRG uft
400: WHERE uft.FEE_CAT = p_fee_cat AND
401: uft.fee_cal_type = p_fee_cal_type AND
402: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
403: uft.FEE_TYPE = p_fee_type AND

Line 519: FROM IGS_FI_UNIT_FEE_TRG uft,

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

Line 565: FROM IGS_FI_UNIT_FEE_TRG uft

561: uft.ci_sequence_number,
562: uft.location_cd,
563: uft.UNIT_CLASS,
564: uft.fee_trigger_group_number
565: FROM IGS_FI_UNIT_FEE_TRG uft
566: WHERE uft.FEE_CAT = p_fee_cat AND
567: uft.fee_cal_type = p_fee_cal_type AND
568: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
569: uft.FEE_TYPE = p_fee_type AND