DBA Data[Home] [Help]

APPS.OKL_CONTRACT_PARTY_PVT dependencies on OKC_K_HEADERS_B

Line 707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS

703: SELECT dnz_chr_id
704: FROM okc_k_party_roles_v
705: WHERE id = p_cplv_rec.id;
706:
707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
708: SELECT okl_vp_jtf_party_name_pub.get_party_name(pr.rle_code,chr.buy_or_sell,pr.object1_id1,pr.object1_id2) party_name
709: FROM okc_k_party_roles_b pr
710: ,okc_k_headers_b chr
711: ,okc_rules_b rule

Line 710: ,okc_k_headers_b chr

706:
707: CURSOR c_party_share_exist_csr(cp_chr_id okc_k_headers_b.id%TYPE, cp_cpl_id okc_k_party_roles_b.id%TYPE)IS
708: SELECT okl_vp_jtf_party_name_pub.get_party_name(pr.rle_code,chr.buy_or_sell,pr.object1_id1,pr.object1_id2) party_name
709: FROM okc_k_party_roles_b pr
710: ,okc_k_headers_b chr
711: ,okc_rules_b rule
712: WHERE pr.id = cp_cpl_id
713: AND rule.rule_information1 = pr.id
714: AND rule.rule_information_category = 'VGLRSP'