APPS.IGS_FI_GEN_001 dependencies on IGS_PS_UNIT_VER

Line 689: IGS_PS_UNIT_VER uv,

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
693: uft.fee_ci_sequence_number = p_fee_ci_sequence_number AND

Line 704: FROM IGS_PS_UNIT_VER uv2

700: uft.unit_cd = uv.unit_cd AND
701: (uft.version_number = uv.version_number OR
702: (uft.version_number IS NULL AND
703: uv.version_number = ( SELECT MAX(uv2.version_number)
704: FROM IGS_PS_UNIT_VER uv2
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