DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 6133: FROM okc_condition_headers_b

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

Line 6138: FROM okc_condition_headers_bH

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

Line 9988: FROM okc_condition_headers_b

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