DBA Data[Home] [Help]

APPS.POS_SUPPLIER_PUB_JOB_PKG dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 98: iby_external_payees_all payee,

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
102: AND instr.last_update_date BETWEEN l_from_date AND l_to_date

Line 105: FROM iby_external_payees_all payee,

101: AND payee.payee_party_id = ap.party_id
102: AND instr.last_update_date BETWEEN l_from_date AND l_to_date
103: UNION
104: SELECT ap.party_id
105: FROM iby_external_payees_all payee,
106: ap_suppliers ap
107: WHERE payee.payee_party_id = ap.party_id
108: AND payee.last_update_date BETWEEN l_from_date AND l_to_date
109: UNION