APPS.OKC_CNL_PVT dependencies on OKC_CONDITION_LINES_BH

Line 112: FROM OKC_CONDITION_LINES_BH B

108: );
109: DELETE FROM OKC_CONDITION_LINES_TLH T
110: WHERE NOT EXISTS (
111: SELECT NULL
112: FROM OKC_CONDITION_LINES_BH B
113: WHERE B.ID = T.ID
114: AND B.MAJOR_VERSION = T.MAJOR_VERSION
115: );
116:

Line 5452: INSERT INTO okc_condition_lines_bh

5448:
5449: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
5450:
5451: BEGIN
5452: INSERT INTO okc_condition_lines_bh
5453: (
5454: major_version,
5455: id,
5456: cnh_id,

Line 5634: FROM okc_condition_lines_bh

5630: last_update_date,
5631: last_update_login
5632: FROM okc_condition_lines_tlh
5633: WHERE id in (SELECT id
5634: FROM okc_condition_lines_bh
5635: WHERE dnz_chr_id = p_chr_id)
5636: AND major_version = p_major_version;
5637:
5638: -------------------------------------

Line 5730: FROM okc_condition_lines_bh

5726: attribute14,
5727: attribute15,
5728: application_id,
5729: seeded_flag
5730: FROM okc_condition_lines_bh
5731: WHERE dnz_chr_id = p_chr_id
5732: AND major_version = p_major_version;
5733:
5734: RETURN l_return_status;