3702: WHERE cle_id = p_from_cle_id
3703: AND G_COPY_HISTORY_YN = 'N'
3704: UNION ALL
3705: SELECT id
3706: FROM okc_k_sales_credits_hv
3707: WHERE cle_id = p_from_cle_id
3708: AND major_version = G_FROM_VERSION_NUMBER
3709: AND G_COPY_HISTORY_YN = 'Y';
3710:
5331: AND cle_id IS NULL
5332: AND G_COPY_HISTORY_YN = 'N'
5333: UNION ALL
5334: SELECT id
5335: FROM okc_k_sales_credits_hv
5336: WHERE dnz_chr_id = p_from_chr_id
5337: AND cle_id IS NULL
5338: AND major_version = G_FROM_VERSION_NUMBER
5339: AND G_COPY_HISTORY_YN = 'Y';