APPS.AP_VENDOR_PUB_PKG dependencies on IBY_EXT_PARTY_PMT_MTHDS

Line 7032: l_primary_flag iby_ext_party_pmt_mthds.primary_flag%TYPE;

7028: -- Bug#7506443 start
7029: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7030: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7031: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7032: l_primary_flag iby_ext_party_pmt_mthds.primary_flag%TYPE;
7033: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7034: -- Bug#7506443 start
7035:
7036: l_sync_return_status VARCHAR2(50);

Line 7055: iBy_ext_Party_pmt_mthds pmtmthdAssignmentseo,

7051: pmtmthdAssignmentseo.InActive_Date,
7052: pmtmthdAssignmentseo.Primary_Flag,
7053: iep.exclusive_payment_flag
7054: FROM iBy_Payment_Methods_vl pmthds,
7055: iBy_ext_Party_pmt_mthds pmtmthdAssignmentseo,
7056: iBy_External_Payees_All iep
7057: WHERE pmthds.Payment_Method_Code = pmtmthdAssignmentseo.Payment_Method_Code (+)
7058: AND pmtmthdAssignmentseo.Payment_Flow = 'DISBURSEMENTS'
7059: AND Nvl(pmthds.InActive_Date,Trunc(SYSDATE + 1)) > Trunc(SYSDATE)