APPS.OKL_VENDORMERGE_GRP dependencies on OKL_PARTY_PAYMENT_DTLS

Line 161: , OKL_PARTY_PAYMENT_DTLS PPD

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
165: AND PPD.CPL_ID = p_src_cpl_id;

Line 732: --Update OKL_PARTY_PAYMENT_DTLS for references of Vendor and Vendor Site

728: LAST_UPDATE_LOGIN = l_last_update_login
729: WHERE PARTY_OBJECT1_ID1 = TO_CHAR(p_dup_vendor_id)
730: AND PARTY_JTOT_OBJECT1_CODE = 'OKX_VENDOR';
731:
732: --Update OKL_PARTY_PAYMENT_DTLS for references of Vendor and Vendor Site
733: --Passthrough setup update is fine in the case where there is only source
734: --vendor used on the setup.
735: UPDATE OKL_PARTY_PAYMENT_DTLS
736: SET VENDOR_ID = p_vendor_id,

Line 735: UPDATE OKL_PARTY_PAYMENT_DTLS

731:
732: --Update OKL_PARTY_PAYMENT_DTLS for references of Vendor and Vendor Site
733: --Passthrough setup update is fine in the case where there is only source
734: --vendor used on the setup.
735: UPDATE OKL_PARTY_PAYMENT_DTLS
736: SET VENDOR_ID = p_vendor_id,
737: PAY_SITE_ID = p_vendor_site_id,
738: LAST_UPDATED_BY = l_last_updated_by,
739: LAST_UPDATE_DATE = l_last_update_date,