APPS.OKC_PRICE_ADJUSTMENT_PVT dependencies on OKC_PRICE_ADJ_ASSOCS_V

Line 108: OKC_PRICE_ADJ_ASSOCS_V B

104: --cursor to fetch the child lines
105: CURSOR l_padj_csr IS
106: SELECT A.id,A.chr_id,A.cle_id
107: FROM OKC_PRICE_ADJUSTMENTS_V A,
108: OKC_PRICE_ADJ_ASSOCS_V B
109: WHERE B.pat_id_from = p_patv_rec.id
110: AND A.ID = B.PAT_ID
111: AND (A.chr_id = p_patv_rec.chr_id
112: OR A.cle_id = p_patv_rec.cle_id);

Line 116: FROM OKC_PRICE_ADJ_ASSOCS_V

112: OR A.cle_id = p_patv_rec.cle_id);
113: --
114: CURSOR l_assoc_csr IS
115: SELECT id
116: FROM OKC_PRICE_ADJ_ASSOCS_V
117: WHERE pat_id_from = p_patv_rec.id;
118: --
119:
120: CURSOR l_attrib_csr IS

Line 163: -- Delete related records from OKC_PRICE_ADJ_ASSOCS_V

159: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
160: For assoc_rec In l_assoc_csr Loop
161: l_pacv_rec.id := assoc_rec.id;
162:
163: -- Delete related records from OKC_PRICE_ADJ_ASSOCS_V
164: OKC_PRICE_ADJUSTMENT_PUB.delete_price_adj_assoc(
165: p_api_version => p_api_version,
166: p_init_msg_list => p_init_msg_list,
167: x_return_status => x_return_status,