DBA Data[Home] [Help]

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 737: FROM OKC_K_HEADERS_ALL_B okck,

733:
734: /*start of bug8345674*/
735: CURSOR c_old_sts is
736: SELECT STS_CODE
737: FROM OKC_K_HEADERS_ALL_B okck,
738: OKC_STATUSES_B sts
739: WHERE id = p_chr_id
740: AND sts.code = okck.sts_code;
741:

Line 1678: FROM okc_k_headers_all_b

1674: )
1675: IS
1676: SELECT contract_number,
1677: contract_number_modifier
1678: FROM okc_k_headers_all_b
1679: WHERE ID = p_chr_id;
1680:
1681: CURSOR l_userres_csr (
1682: p_user_id NUMBER