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
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