DBA Data[Home] [Help]

APPS.OKL_INTERNAL_BILLING_PVT dependencies on OKC_K_HEADERS_B

Line 321: FROM okc_k_headers_b

317: AND org_id = p_org_id;
318:
319: CURSOR org_id_csr(p_khr_id NUMBER) IS
320: SELECT authoring_org_id
321: FROM okc_k_headers_b
322: WHERE id = p_khr_id;
323:
324: --gkhuntet added for Manual Invoices 06-07-2007 start
325: --Cursor to get TRY_ID for the BILLING.

Line 1114: FROM okc_k_headers_b

1110:
1111: -- to get inventory_org_id bug 4890024 begin
1112: CURSOR inv_org_id_csr(p_contract_id NUMBER) IS
1113: SELECT NVL(inv_organization_id, -99)
1114: FROM okc_k_headers_b
1115: WHERE id = p_contract_id;
1116:
1117: begin
1118: -- Set API savepoint

Line 3035: FROM okc_k_headers_b

3031: l_contract_nbr VARCHAR2(200);
3032:
3033: CURSOR c_get_khr_nbr(p_khr_id NUMBER) IS
3034: SELECT contract_number
3035: FROM okc_k_headers_b
3036: WHERE id = p_khr_id;
3037: begin
3038: -- Set API savepoint
3039: SAVEPOINT CREATE_BILLING_TRX;