DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on JTF_CAL_EXCEPTIONS_B

Line 1905: jtf_cal_exceptions_b jceb

1901: and jcsc.unit_of_time_value = to_char(sysdate+flvv.lookup_code,'D')
1902: and not exists
1903: (SELECT 'x'
1904: FROM jtf_cal_exception_assign jcea,
1905: jtf_cal_exceptions_b jceb
1906: where jcea.calendar_id = jcb.calendar_id
1907: and sysdate+flvv.lookup_code
1908: between trunc(jceb.start_date_time) and trunc(jceb.end_date_time+1)
1909: and sysdate+flvv.lookup_code