DBA Data[Home] [Help]

APPS.OKC_CRT_PVT dependencies on OKC_K_HEADERS_V

Line 1002: FROM Okc_K_Headers_V

998: CREATION_DATE,
999: LAST_UPDATED_BY,
1000: LAST_UPDATE_DATE,
1001: LAST_UPDATE_LOGIN
1002: FROM Okc_K_Headers_V
1003: WHERE okc_k_headers_v.id = p_id;
1004: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
1005: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1006: l_row_notfound BOOLEAN := TRUE;

Line 1003: WHERE okc_k_headers_v.id = p_id;

999: LAST_UPDATED_BY,
1000: LAST_UPDATE_DATE,
1001: LAST_UPDATE_LOGIN
1002: FROM Okc_K_Headers_V
1003: WHERE okc_k_headers_v.id = p_id;
1004: l_okc_chrv_pk okc_chrv_pk_csr%ROWTYPE;
1005: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1006: l_row_notfound BOOLEAN := TRUE;
1007: BEGIN

Line 1061: from okc_k_headers_v

1057: where id = p_crtv_rec.chr_id;
1058: cursor amt_chr_csr is
1059: select '!'
1060: -- from okc_k_hdr_rfps_v
1061: from okc_k_headers_v
1062: where id = p_crtv_rec.chr_id;
1063: l_dummy varchar2(1) := '?';
1064: BEGIN
1065: if (p_crtv_rec.crt_type = 'ALN') then