DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OKC_K_HEADERS_V

Line 818: FROM okc_k_headers_v

814:
815: CURSOR l_hdr_csr
816: IS
817: SELECT ID chr_id
818: FROM okc_k_headers_v
819: WHERE attribute1 = p_object_id AND end_date = p_enddate;
820: BEGIN
821: IF p_type = 'ORDER'
822: THEN

Line 1834: FROM okc_k_headers_v

1830: IS
1831: CURSOR l_hdr_csr
1832: IS
1833: SELECT start_date, end_date
1834: FROM okc_k_headers_v
1835: WHERE ID = p_chr_id;
1836:
1837: l_hdr_csr_rec l_hdr_csr%ROWTYPE;
1838: BEGIN

Line 1978: FROM okc_k_headers_v

1974: IS
1975: CURSOR l_hdr_csr
1976: IS
1977: SELECT contract_number
1978: FROM okc_k_headers_v
1979: WHERE ID = p_hdrid;
1980:
1981: l_contract_number VARCHAR2 (120);
1982: BEGIN

Line 2249: FROM okc_statuses_b, okc_k_headers_v kh

2245: --status code
2246: CURSOR l_sts_csr (p_chr_id NUMBER)
2247: IS
2248: SELECT ste_code
2249: FROM okc_statuses_b, okc_k_headers_v kh
2250: WHERE code = kh.sts_code AND kh.ID = p_chr_id;
2251:
2252: --Check for vendor object_code
2253: CURSOR object_code_csr (p_code VARCHAR2)