APPS.OKS_AUTO_REMINDER dependencies on OKC_K_HEADERS_ALL_B

Line 661: FROM okc_k_headers_all_b k,

657: := 'update_contract_status';
658: -- bug 5161013 check STE_CODE for the contract
659: CURSOR csr_k_ste_code IS
660: SELECT s.ste_code
661: FROM okc_k_headers_all_b k,
662: okc_statuses_b s
663: WHERE k.sts_code = s.code
664: AND k.id = p_chr_id;
665:

Line 1601: FROM okc_k_headers_all_b

1597: )
1598: IS
1599: SELECT contract_number,
1600: contract_number_modifier
1601: FROM okc_k_headers_all_b
1602: WHERE ID = p_chr_id;
1603:
1604: CURSOR l_userres_csr (
1605: p_user_id NUMBER