DBA Data[Home] [Help]

APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on OKC_CONTACT_SOURCES

Line 628: okc_contact_sources rs

624: from_table FROM_CLAUSE,
625: where_clause WHERE_CLAUSE,
626: order_by_clause ORDER_BY_CLAUSE
627: from jtf_objects_b job,
628: okc_contact_sources rs
629: where job.object_code = rs.jtot_object_code
630: and nvl(job.start_date_active,sysdate) <= sysdate
631: and nvl(job.end_date_active,sysdate + 1) > sysdate
632: and rs.rle_code = p_rle_code

Line 984: okc_contact_sources rs

980: from_table FROM_CLAUSE,
981: where_clause WHERE_CLAUSE,
982: order_by_clause ORDER_BY_CLAUSE
983: from jtf_objects_b job,
984: okc_contact_sources rs
985: where job.object_code = rs.jtot_object_code
986: and nvl(job.start_date_active,sysdate) <= sysdate
987: and nvl(job.end_date_active,sysdate + 1) > sysdate
988: and rs.rle_code = c_rle_code