DBA Data[Home] [Help]

APPS.IBY_DBCCARD_PVT dependencies on IBY_PAYEE

Line 1114: iby_payee b

1110: -- DECODE(a.trxntypeid, 2, 0, 1) factor, -- Bug 3458221
1111: DECODE(a.trxntypeid, 8, 0, 9, 0, 1) factor,
1112: COUNT(*) total_trxn
1113: FROM iby_trxn_summaries_all a,
1114: iby_payee b
1115: WHERE TRUNC(updatedate) >= l_date
1116: AND trxntypeid IN (2,3,5,8,9,10,11)
1117: AND instrtype IN (C_INSTRTYPE_CREDITCARD,C_INSTRTYPE_PURCHASECARD)
1118: AND a.payeeid = b.payeeid