APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_K_HEADERS_ALL_B

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

1098: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1099: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1100: a.scs_code, c.ste_code source_ste_code, b.period_start,
1101: b.period_type, b.price_uom, a.billed_at_source
1102: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1103: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1104:
1105: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1106:

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

1130: l_billed_at_source VARCHAR2
1131: )
1132: IS
1133: SELECT a.ID
1134: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1135: WHERE a.ID = l_target_chr_id
1136: AND a.ID = b.chr_id
1137: AND a.sts_code= c.code --Bug fix 5614310
1138: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 6609: UPDATE okc_k_headers_all_b

6605:
6606: l_hdr_date_renewed :=
6607: oks_ib_util_pvt.check_renewed_lines (l_source_line_id);
6608:
6609: UPDATE okc_k_headers_all_b
6610: SET date_renewed = l_hdr_date_renewed
6611: WHERE ID = (SELECT dnz_chr_id
6612: FROM okc_k_lines_b
6613: WHERE ID = l_source_line_id)

Line 8518: From Okc_k_headers_all_b

8514:
8515: Cursor l_hdr_sts_csr(p_hdr_id Number)
8516: Is
8517: Select sts_code
8518: From Okc_k_headers_all_b
8519: WHere id = p_hdr_id;
8520:
8521: l_hdr_status Varchar2(240);
8522:

Line 13906: From Okc_k_headers_all_b

13902:
13903: Cursor l_hdr_sts_csr(p_hdr_id Number)
13904: Is
13905: Select sts_code
13906: From Okc_k_headers_all_b
13907: WHere id = p_hdr_id;
13908:
13909: l_hdr_status Varchar2(240);
13910:

Line 16936: FROM okc_k_headers_all_b

16932:
16933: CURSOR get_contract_number
16934: IS
16935: SELECT contract_number || ' ' || contract_number_modifier
16936: FROM okc_k_headers_all_b
16937: WHERE ID = p_contract_id;
16938:
16939: l_return_status VARCHAR2 (10);
16940: l_msg_data VARCHAR2 (2000);