eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_BR_WORKDAY_CALENDAR dependencies on JL_BR_LOCAL_HOLIDAY_SETS

Line 52: jl_br_local_holiday_sets b

48: BEGIN
49: SELECT a.local_holiday_type, b.disable_date
50: INTO x_type, x_disable_date
51: FROM jl_br_local_holiday_dates a,
52: jl_br_local_holiday_sets b
53: WHERE b.local_holiday_set_name = p_city -- Bug 801019
54: AND a.local_holiday_set_id = b.local_holiday_set_id
55: AND a.local_holiday_date = x_date
56: AND nvl(b.disable_date,sysdate + 1) > sysdate;

Line 163: jl_br_local_holiday_sets b

159: BEGIN
160: SELECT a.local_holiday_type, b.disable_date
161: INTO x_type, x_disable_date
162: FROM jl_br_local_holiday_dates a,
163: jl_br_local_holiday_sets b
164: WHERE b.local_holiday_set_name = p_city -- Bug 801019
165: AND nvl(b.state,'$') = nvl(p_state,'$') -- Bug 2319552
166: AND a.local_holiday_set_id = b.local_holiday_set_id
167: AND a.local_holiday_date = x_date