DBA Data[Home] [Help]

APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on OKC_ROLE_SOURCES

Line 136: okc_role_sources rs

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
140: and rs.rle_code = p_role_code