DBA Data[Home] [Help]

APPS.IGS_FI_GEN_005 dependencies on IGS_EN_UNITSETFEETRG

Line 446: FROM IGS_EN_UNITSETFEETRG usft

442:
443: SELECT usft.unit_set_cd,
444: usft.version_number,
445: usft.fee_trigger_group_number
446: FROM IGS_EN_UNITSETFEETRG usft
447: WHERE usft.FEE_CAT = p_fee_cat AND
448: usft.fee_cal_type = p_fee_cal_type AND
449: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
450: usft.FEE_TYPE = p_fee_type AND

Line 540: FROM IGS_EN_UNITSETFEETRG usft,

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

Line 582: FROM IGS_EN_UNITSETFEETRG usft

578: IGS_AS_SU_SETATMPT.us_version_number%TYPE) IS
579: SELECT usft.unit_set_cd,
580: usft.version_number,
581: usft.fee_trigger_group_number
582: FROM IGS_EN_UNITSETFEETRG usft
583: WHERE usft.FEE_CAT = p_fee_cat AND
584: usft.fee_cal_type = p_fee_cal_type AND
585: usft.fee_ci_sequence_number = p_fee_ci_sequence_number AND
586: usft.FEE_TYPE = p_fee_type AND