DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 6134: FROM okc_condition_headers_b

6130: AND G_COPY_HISTORY_YN = 'Y';
6131: ---------------------------------------------------
6132: CURSOR c_cnhv IS
6133: SELECT id
6134: FROM okc_condition_headers_b
6135: WHERE dnz_chr_id = p_chr_id
6136: AND g_copy_history_yn = 'N'
6137: UNION ALL
6138: SELECT id

Line 6139: FROM okc_condition_headers_bH

6135: WHERE dnz_chr_id = p_chr_id
6136: AND g_copy_history_yn = 'N'
6137: UNION ALL
6138: SELECT id
6139: FROM okc_condition_headers_bH
6140: WHERE dnz_chr_id = p_chr_id
6141: AND major_version = G_FROM_VERSION_NUMBER
6142: AND G_COPY_HISTORY_YN = 'Y';
6143: ---------------------------------------------------

Line 9989: FROM okc_condition_headers_b

9985:
9986: CURSOR c_cnh(p_id IN NUMBER) IS
9987: SELECT dnz_chr_id,
9988: template_yn
9989: FROM okc_condition_headers_b
9990: WHERE id = p_id;
9991:
9992: CURSOR c_isev_rel(p_id IN NUMBER) IS
9993: SELECT START_PARENT_DATE,