DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on JTF_OBJECTS_B

Line 135: from jtf_objects_b job,

131: job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
132: from_table FROM_CLAUSE,
133: where_clause WHERE_CLAUSE,
134: order_by_clause ORDER_BY_CLAUSE
135: from jtf_objects_b job,
136: okc_role_sources rs
137: where job.object_code = rs.jtot_object_code
138: and nvl(job.start_date_active,sysdate) <= sysdate
139: and nvl(job.end_date_active,sysdate + 1) > sysdate

Line 612: from jtf_objects_b job,

608: job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
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