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.OTA_PLE_BUS dependencies on OTA_PRICE_LISTS

Line 118: select 1 from ota_price_lists

114: )
115: is
116: -------------
117: cursor csr_tpl is
118: select 1 from ota_price_lists
119: where price_list_id = p_tpl_id;
120: --
121: l_parent_exists boolean;
122: -------------

Line 367: from ota_price_lists

363: --*** Price list entry's start date must be >= Price list's start date
364: ---------------------
365: cursor csr_tpl_date is
366: select start_date
367: from ota_price_lists
368: where price_list_id = p_tpl_id;
369: --
370: l_tpl_startdate date;
371: --

Line 471: from ota_price_lists

467: --*** Price list entry's end date must be <= Price list's end date
468: ---------------------
469: cursor csr_tpl_date is
470: select end_date
471: from ota_price_lists
472: where price_list_id = p_tpl_id;
473: --
474: l_tpl_enddate date;
475: --

Line 1489: from ota_price_lists

1485: --
1486: l_proc varchar2(72) := g_package||'consider_leap_years';
1487: cursor c1 is
1488: select start_date
1489: from ota_price_lists
1490: where price_list_id = p_old_tpl_id;
1491: l_old_start_date date;
1492: l_days number := 0;
1493: Begin