APPS.IGS_FI_GEN_005 dependencies on IGS_PS_UNIT_VER

Line 520: IGS_PS_UNIT_VER uv,

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

Line 535: FROM IGS_PS_UNIT_VER uv2

531: uft.unit_cd = uv.unit_cd AND
532: (uft.version_number = uv.version_number OR
533: (uft.version_number IS NULL AND
534: uv.version_number = ( SELECT MAX(uv2.version_number)
535: FROM IGS_PS_UNIT_VER uv2
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