DBA Data[Home] [Help]

APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on OKC_ROLE_SOURCES

Line 100: okc_role_sources rs

96: from_table FROM_CLAUSE,
97: where_clause WHERE_CLAUSE,
98: order_by_clause ORDER_BY_CLAUSE
99: from jtf_objects_b job,
100: okc_role_sources rs
101: where job.object_code = rs.jtot_object_code
102: and nvl(job.start_date_active,sysdate) <= sysdate
103: and nvl(job.end_date_active,sysdate + 1) > sysdate
104: and rs.rle_code = p_role_code

Line 918: okc_role_sources rs

914: from_table FROM_CLAUSE,
915: where_clause WHERE_CLAUSE,
916: order_by_clause ORDER_BY_CLAUSE
917: from jtf_objects_b job,
918: okc_role_sources rs
919: where job.object_code = rs.jtot_object_code
920: and nvl(job.start_date_active,sysdate) <= sysdate
921: and nvl(job.end_date_active,sysdate + 1) > sysdate
922: and rs.rle_code = p_role_code