APPS.OKC_CNH_PVT dependencies on OKC_CONDITION_HEADERS_BH

Line 131: FROM OKC_CONDITION_HEADERS_BH B

127: );
128: DELETE FROM OKC_CONDITION_HEADERS_TLH T
129: WHERE NOT EXISTS (
130: SELECT NULL
131: FROM OKC_CONDITION_HEADERS_BH B
132: WHERE B.ID = T.ID
133: AND B.MAJOR_VERSION = T.MAJOR_VERSION
134: );
135: UPDATE OKC_CONDITION_HEADERS_TLH T SET (

Line 5315: INSERT INTO okc_condition_headers_bh

5311:
5312: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5313:
5314: BEGIN
5315: INSERT INTO okc_condition_headers_bh
5316: (
5317: major_version,
5318: id,
5319: acn_id,

Line 5507: FROM okc_condition_headers_bh

5503: last_update_login,
5504: name
5505: FROM okc_condition_headers_tlh
5506: WHERE id in (SELECT id
5507: FROM okc_condition_headers_bh
5508: WHERE dnz_chr_id = p_chr_id)
5509: AND major_version = p_major_version;
5510:
5511: ------------------------------------------

Line 5601: FROM okc_condition_headers_bh

5597: task_owner_id,
5598: application_id,
5599: seeded_flag,
5600: last_rundate
5601: FROM okc_condition_headers_bh
5602: WHERE dnz_chr_id = p_chr_id
5603: AND major_version = p_major_version;
5604:
5605: RETURN l_return_status;