APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_K_HEADERS_V

Line 858: FROM okc_k_headers_v

854:
855: CURSOR l_hdr_csr
856: IS
857: SELECT ID chr_id
858: FROM okc_k_headers_v
859: WHERE attribute1 = p_object_id AND end_date = p_enddate;
860: BEGIN
861: IF p_type = 'ORDER'
862: THEN

Line 1874: FROM okc_k_headers_v

1870: IS
1871: CURSOR l_hdr_csr
1872: IS
1873: SELECT start_date, end_date
1874: FROM okc_k_headers_v
1875: WHERE ID = p_chr_id;
1876:
1877: l_hdr_csr_rec l_hdr_csr%ROWTYPE;
1878: BEGIN

Line 2018: FROM okc_k_headers_v

2014: IS
2015: CURSOR l_hdr_csr
2016: IS
2017: SELECT contract_number
2018: FROM okc_k_headers_v
2019: WHERE ID = p_hdrid;
2020:
2021: l_contract_number VARCHAR2 (120);
2022: BEGIN

Line 2289: FROM okc_statuses_b, okc_k_headers_v kh

2285: --status code
2286: CURSOR l_sts_csr (p_chr_id NUMBER)
2287: IS
2288: SELECT ste_code
2289: FROM okc_statuses_b, okc_k_headers_v kh
2290: WHERE code = kh.sts_code AND kh.ID = p_chr_id;
2291:
2292: --Check for vendor object_code
2293: CURSOR object_code_csr (p_code VARCHAR2)