DBA Data[Home] [Help]

APPS.IGS_EN_PRC_LOAD dependencies on IGS_PS_TCH_RESP_OVRD

Line 821: FROM IGS_PS_TCH_RESP_OVRD

817: SELECT tr.percentage
818: FROM IGS_PS_UNIT_OFR_OPT uoo, IGS_PS_TCH_RESP tr
819: WHERE uoo.uoo_id = p_uoo_id
820: AND NOT EXISTS ( SELECT unit_cd
821: FROM IGS_PS_TCH_RESP_OVRD
822: WHERE uoo_id = uoo.uoo_id )
823: AND tr.unit_cd = uoo.unit_cd
824: AND tr.version_number = uoo.version_number
825: UNION ALL

Line 827: FROM IGS_PS_TCH_RESP_OVRD tro

823: AND tr.unit_cd = uoo.unit_cd
824: AND tr.version_number = uoo.version_number
825: UNION ALL
826: SELECT tro.percentage
827: FROM IGS_PS_TCH_RESP_OVRD tro
828: WHERE tro.uoo_id = p_uoo_id;
829: CURSOR c_ud IS
830: SELECT ud.percentage
831: FROM IGS_PS_UNIT_DSCP ud