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_DATES

Line 51: FROM jl_br_local_holiday_dates a,

47: WHILE local_flag_exit = 0 LOOP
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

Line 161: FROM jl_br_local_holiday_dates a,

157: WHILE local_flag_exit = 0 LOOP
158: BEGIN
159: SELECT a.local_holiday_type, b.disable_date
160: INTO x_type, x_disable_date
161: FROM jl_br_local_holiday_dates a,
162: jl_br_local_holiday_sets b
163: WHERE b.local_holiday_set_name = p_city -- Bug 801019
164: AND nvl(b.state,'$') = nvl(p_state,'$') -- Bug 2319552
165: AND a.local_holiday_set_id = b.local_holiday_set_id