DBA Data[Home] [Help]

APPS.OKL_VP_JTF_PARTY_NAME_PVT dependencies on JTF_OBJECTS_B

Line 99: from jtf_objects_b job,

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

Line 627: from jtf_objects_b job,

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

Line 917: from jtf_objects_b job,

913: ''''|| job.object_code ||''''|| ' JTOT_OBJECT_CODE' SELECT_CLAUSE,
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

Line 983: from jtf_objects_b job,

979: ''''|| job.object_code ||''''|| ' JTOT_OBJECT_CODE' SELECT_CLAUSE,
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