APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_PARTY_ROLES_B

Line 3756: FROM okc_k_party_roles_b

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

Line 6121: FROM okc_k_party_roles_b

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

Line 6127: FROM okc_k_party_roles_bH

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