APPS.CSP_PART_SEARCH_PVT dependencies on JTF_CAL_EXCEPTION_ASSIGN

Line 1904: FROM jtf_cal_exception_assign jcea,

1900: AND TRUNC(NVL(jcsc.end_date_active,sysdate+flvv.lookup_code))
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)