DBA Data[Home] [Help]

APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on IBY_PMT_INSTR_USES_ALL

Line 97: FROM iby_pmt_instr_uses_all instr,

93: WHERE pbca.vendor_id = ap.vendor_id
94: AND pbca.last_update_date BETWEEN l_from_date AND l_to_date
95: UNION
96: SELECT ap.party_id
97: FROM iby_pmt_instr_uses_all instr,
98: iby_external_payees_all payee,
99: ap_suppliers ap
100: WHERE instr.ext_pmt_party_id = payee.ext_payee_id
101: AND payee.payee_party_id = ap.party_id