DBA Data[Home] [Help]

APPS.OKS_CONTRACTS_PUB dependencies on OKC_K_PARTY_ROLES_B

Line 111: Select Id From OKC_K_PARTY_ROLES_B

107: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
108: l_cplv_tbl_out okc_contract_party_pub.cplv_tbl_type;
109:
110: Cursor l_party_csr Is
111: Select Id From OKC_K_PARTY_ROLES_B
112: Where dnz_chr_id = p_chrid
113: And cle_id Is Null
114: And rle_code = p_rle_code;
115:

Line 116: Cursor l_lparty_csr Is Select Id From OKC_K_PARTY_ROLES_B

112: Where dnz_chr_id = p_chrid
113: And cle_id Is Null
114: And rle_code = p_rle_code;
115:
116: Cursor l_lparty_csr Is Select Id From OKC_K_PARTY_ROLES_B
117: Where dnz_chr_id = p_chrid
118: And cle_id = p_cleid
119: And rle_code = p_rle_code;
120: