DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on OKX_TIMEZONES_V

Line 3140: OKX_TIMEZONES_V tmz

3136: Select
3137: tmz.NAME TimeZone
3138: From
3139: OKS_COVERAGE_TIMEZONES cvr,
3140: OKX_TIMEZONES_V tmz
3141: Where
3142: cvr.CLE_ID = to_number(p_bus_proc_ID_arg)
3143: and tmz.TIMEZONE_ID = cvr.TIMEZONE_ID
3144: -- and rownum < 2;

Line 3161: okx_timezones_v OkxTimeZones,

3157: CovTImes.Thursday_YN Thr,
3158: CovTImes.Friday_YN Fri,
3159: CovTImes.Saturday_YN Sat
3160: from oks_coverage_timeZones CovTimeZones,
3161: okx_timezones_v OkxTimeZones,
3162: oks_coverage_times CovTimes
3163: where CovTimeZones.timezone_id = OkxTimeZones.timezone_id
3164: and CovTimeZones.cle_id = to_number(p_bus_proc_ID_arg)
3165: and CovTImes.COV_TZE_LINE_ID=CovTimeZones.id