APPS.OKC_REPORT_PVT dependencies on OKC_K_HEADERS_B

Line 816: select '!' from okc_k_headers_b

812: -- SQL statements use okc_tree_index.get_root_id as Contact Id
813: --
814: procedure set_env(p_kid varchar2) is
815: cursor c1 is
816: select '!' from okc_k_headers_b
817: where id=p_kid;
818: l_dummy varchar2(1) := '?';
819: cursor c2 (p_xid number) is
820: select '!'

Line 919: select to_char(id) from okc_k_headers_b

915: -- besides it sets okc_tree_index.set_root_id(p_kid):
916: --
917: procedure set_env(p_array in JTF_VARCHAR2_TABLE_2000) is
918: cursor c1(p_kn varchar2) is
919: select to_char(id) from okc_k_headers_b
920: where contract_number = p_kn;
921: kid varchar2(40);
922: k_ind number;
923: k_ind1 number;

Line 2159: from okc_k_headers_b

2155: select
2156: Contract_number||
2157: decode(Contract_number_modifier,NULL,NULL,' - ')||
2158: Contract_number_modifier
2159: from okc_k_headers_b
2160: where id = k;
2161:
2162: cursor c2(x varchar2) is
2163: select

Line 2305: from okc_k_headers_b

2301: cursor c1(k number) is
2302: select
2303: Contract_number
2304: ,Contract_number_modifier
2305: from okc_k_headers_b
2306: where id = k;
2307:
2308: l_n varchar2(200);
2309: l_m varchar2(200);