DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_CONTACT_SOURCES

Line 613: okc_contact_sources cs

609: from_table FROM_CLAUSE,
610: where_clause WHERE_CLAUSE,
611: order_by_clause ORDER_BY_CLAUSE
612: from jtf_objects_b job,
613: okc_contact_sources cs
614: where job.object_code = cs.jtot_object_code
615: and nvl(job.start_date_active,sysdate) <= sysdate
616: and nvl(job.end_date_active,sysdate + 1) > sysdate
617: and cs.cro_code = p_contact_code