DBA Data[Home] [Help]

APPS.OKL_VENDORMERGE_GRP dependencies on OKL_PARTY_PAYMENT_HDR

Line 160: FROM OKL_PARTY_PAYMENT_HDR PPH

156: --Contract or Line level for the source/merged vendor
157: CURSOR chk_passthrough_csr (p_chr_id NUMBER, p_cle_id NUMBER, p_src_cpl_id NUMBER)
158: IS
159: SELECT 1
160: FROM OKL_PARTY_PAYMENT_HDR PPH
161: , OKL_PARTY_PAYMENT_DTLS PPD
162: WHERE DNZ_CHR_ID = p_chr_id
163: AND NVL(CLE_ID, -1) = NVL(p_cle_id, NVL(CLE_ID, -1))
164: AND PPH.ID = PPD.PAYMENT_HDR_ID