DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKC_K_HEADERS_V

Line 1338: FROM okc_k_headers_v

1334: ------------------------------------------------------------
1335: --added for rules migration
1336: CURSOR cust_id_csr(p_khr_id NUMBER) IS
1337: SELECT cust_acct_id
1338: FROM okc_k_headers_v
1339: WHERE id = p_khr_id;
1340:
1341: --added for rules migration
1342: CURSOR cust_acct_csr (p_khr_id NUMBER) IS

Line 1345: FROM okc_k_headers_v khr

1341: --added for rules migration
1342: CURSOR cust_acct_csr (p_khr_id NUMBER) IS
1343: SELECT cs.cust_acct_site_id
1344: , cp.standard_terms payment_term_id
1345: FROM okc_k_headers_v khr
1346: , okx_cust_site_uses_v cs
1347: , hz_customer_profiles cp
1348: WHERE khr.id = p_khr_id
1349: AND khr.bill_to_site_use_id = cs.id1