APPS.OKC_OKS_PUB dependencies on OKC_K_HEADERS_B

Line 32: FROM okc_k_headers_b hdr,

28: --Modified cursor for bug 4104671
29: CURSOR l_get_contracts_csr
30: IS
31: SELECT hdr.id, contract_number
32: FROM okc_k_headers_b hdr,
33: okc_k_party_roles_b pty
34: WHERE hdr.id=pty.chr_id
35: AND pty.rle_code='CUSTOMER'
36: AND pty.object1_id1= to_char(p_to_id)

Line 123: l_mod okc_k_headers_b.contract_number_modifier%TYPE;

119:
120: l_can_renew boolean := true;
121: l_hdr_status VARCHAR2(30);
122: l_k VARCHAR2(255);
123: l_mod okc_k_headers_b.contract_number_modifier%TYPE;
124:
125: -- Bug 3280617
126: CURSOR c_chr(p_chr_id number) is
127: select contract_number, contract_number_modifier

Line 128: from okc_k_headers_b

124:
125: -- Bug 3280617
126: CURSOR c_chr(p_chr_id number) is
127: select contract_number, contract_number_modifier
128: from okc_k_headers_b
129: where id = p_chr_id;
130:
131: cursor get_source_status(l_chr_id number) is
132: select a.sts_code

Line 133: from okc_k_headers_b a, okc_statuses_b b

129: where id = p_chr_id;
130:
131: cursor get_source_status(l_chr_id number) is
132: select a.sts_code
133: from okc_k_headers_b a, okc_statuses_b b
134: where a.id = l_chr_id and a.sts_code = b.code
135: and b.ste_code in ('ACTIVE','EXPIRED','SIGNED');
136:
137: -- Gets all the sublines of the source contract.

Line 242: from okc_k_headers_b

238: l_return_flag varchar2(1) := OKC_API.G_TRUE;
239:
240: cursor check_contr_type(l_chr_id number) is
241: select id
242: from okc_k_headers_b
243: where scs_code in ('WARRANTY', 'SERVICE', 'SUBSCRIPTION') and id = l_chr_id;
244:
245:
246: cursor get_subscr_toplines(l_chr_id number) is