DBA Data[Home] [Help]

APPS.IGS_FI_GEN_001 dependencies on IGS_EN_UNITSETFEETRG

Line 632: FROM IGS_EN_UNITSETFEETRG usft

628: CURSOR c_usft IS
629: SELECT usft.unit_set_cd,
630: usft.version_number,
631: usft.fee_trigger_group_number
632: FROM IGS_EN_UNITSETFEETRG usft
633: WHERE usft.FEE_CAT = p_fee_cat AND
634: usft.fee_cal_type = p_fee_cal_type AND
635: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
636: usft.FEE_TYPE = p_fee_type AND

Line 709: FROM IGS_EN_UNITSETFEETRG usft,

705: WHERE uv2.unit_cd = uv.unit_cd)));
706: CURSOR c_ftgv_unitset IS
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

Line 752: FROM IGS_EN_UNITSETFEETRG usft

748: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
749: SELECT usft.unit_set_cd,
750: usft.version_number,
751: usft.fee_trigger_group_number
752: FROM IGS_EN_UNITSETFEETRG usft
753: WHERE usft.FEE_CAT = p_fee_cat AND
754: usft.fee_cal_type = p_fee_cal_type AND
755: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
756: usft.FEE_TYPE = p_fee_type AND