APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 3755: FROM okc_k_party_roles_b

3751: -- fix for GSR.
3752: --
3753: CURSOR c_cplv IS
3754: SELECT id
3755: FROM okc_k_party_roles_b
3756: WHERE cle_id = p_from_cle_id
3757: AND rle_code <> 'LICENCEE_ACCT'
3758: and dnz_chr_id = p_from_chr_id;
3759:

Line 6120: FROM okc_k_party_roles_b

6116: WHERE document_type=p_doc_type AND document_id=p_doc_id;
6117: ---------------------------------------------------
6118: CURSOR c_cplv IS
6119: SELECT id
6120: FROM okc_k_party_roles_b
6121: WHERE dnz_chr_id = p_chr_id
6122: and cle_id is NULL
6123: AND g_copy_history_yn = 'N'
6124: UNION ALL

Line 6126: FROM okc_k_party_roles_bH

6122: and cle_id is NULL
6123: AND g_copy_history_yn = 'N'
6124: UNION ALL
6125: SELECT id
6126: FROM okc_k_party_roles_bH
6127: WHERE dnz_chr_id = p_chr_id and cle_id is NULL
6128: AND major_version = G_FROM_VERSION_NUMBER
6129: AND G_COPY_HISTORY_YN = 'Y';
6130: ---------------------------------------------------