DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 7907: iBy_ext_Party_pmt_mthds pmtmthdAssignmentseo

7903: Cursor get_iby_pay_dtls_csr(p_ext_payee_id NUMBER) is
7904: SELECT pmtmthdAssignmentseo.Payment_Method_Code,
7905: pmtmthdAssignmentseo.InActive_Date
7906: FROM iBy_Payment_Methods_vl pmthds,
7907: iBy_ext_Party_pmt_mthds pmtmthdAssignmentseo
7908: WHERE pmthds.Payment_Method_Code = pmtmthdAssignmentseo.Payment_Method_Code (+)
7909: AND pmtmthdAssignmentseo.Payment_Flow = 'DISBURSEMENTS'
7910: AND Nvl(pmthds.InActive_Date,Trunc(SYSDATE + 1)) > Trunc(SYSDATE)
7911: AND Nvl(pmtmthdAssignmentseo.InActive_Date,Trunc(SYSDATE + 1)) > Trunc(SYSDATE) /* Bug9763027 */