APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 1142: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1138: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1139: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1140: a.scs_code, c.ste_code source_ste_code, b.period_start,
1141: b.period_type, b.price_uom, a.billed_at_source
1142: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1143: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1144:
1145: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1146:

Line 1174: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1170: l_billed_at_source VARCHAR2
1171: )
1172: IS
1173: SELECT a.ID
1174: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1175: WHERE a.ID = l_target_chr_id
1176: AND a.ID = b.chr_id
1177: AND a.sts_code= c.code --Bug fix 5614310
1178: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 2305: FROM okc_k_headers_all_b

2301:
2302: /*spingali - bugfix for bug12747411*/
2303: CURSOR get_k_auth_org(p_k_id NUMBER)IS
2304: SELECT authoring_org_id
2305: FROM okc_k_headers_all_b
2306: WHERE id=p_k_id;
2307: l_auth_org_id NUMBER;
2308: l_okc_org_id NUMBER;
2309: /*spingali end of bugfix for bug12747411*/

Line 3909: FROM okc_k_headers_all_b

3905:
3906: /*spingali - bugfix for bug12747411*/
3907: CURSOR get_k_inv_org(p_k_id NUMBER)IS
3908: SELECT inv_organization_id
3909: FROM okc_k_headers_all_b
3910: WHERE id=p_k_id;
3911: l_inv_org_id NUMBER;
3912: /*spingali end of bugfix for bug12747411*/
3913:

Line 6777: UPDATE okc_k_headers_all_b

6773:
6774: l_hdr_date_renewed :=
6775: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);
6776:
6777: UPDATE okc_k_headers_all_b
6778: SET date_renewed = l_hdr_date_renewed
6779: WHERE ID = (SELECT dnz_chr_id
6780: FROM okc_k_lines_b
6781: WHERE ID = l_source_line_id)

Line 8749: From Okc_k_headers_all_b

8745:
8746: Cursor l_hdr_sts_csr(p_hdr_id Number)
8747: Is
8748: Select sts_code
8749: From Okc_k_headers_all_b
8750: WHere id = p_hdr_id;
8751:
8752: l_hdr_status Varchar2(240);
8753:

Line 14191: From Okc_k_headers_all_b

14187:
14188: Cursor l_hdr_sts_csr(p_hdr_id Number)
14189: Is
14190: Select sts_code
14191: From Okc_k_headers_all_b
14192: WHere id = p_hdr_id;
14193:
14194: l_hdr_status Varchar2(240);
14195:

Line 17234: FROM okc_k_headers_all_b

17230:
17231: CURSOR get_contract_number
17232: IS
17233: SELECT contract_number || ' ' || contract_number_modifier
17234: FROM okc_k_headers_all_b
17235: WHERE ID = p_contract_id;
17236:
17237: l_return_status VARCHAR2 (10);
17238: l_msg_data VARCHAR2 (2000);