APPS.ARP_PROGRAM_BR_REMIT dependencies on IBY_TRXN_SUMMARIES_ALL

Line 1206: FROM iby_trxn_summaries_all summ,

1202:
1203: Begin
1204: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
1205: into l_auth_flag
1206: FROM iby_trxn_summaries_all summ,
1207: iby_fndcpt_tx_operations op
1208: WHERE summ.transactionid = op.transactionid
1209: AND reqtype = 'ORAPMTREQ'
1210: AND status IN(0, 100)

Line 1215: FROM iby_trxn_summaries_all

1211: AND trxntypeid IN(2, 3, 20)
1212: AND op.trxn_extension_id = l_trxn_entity_id
1213: AND summ.trxnmid =
1214: (SELECT MAX(trxnmid)
1215: FROM iby_trxn_summaries_all
1216: WHERE transactionid = summ.transactionid
1217: AND reqtype = 'ORAPMTREQ'
1218: AND status IN(0, 100)
1219: AND trxntypeid IN(2, 3, 20));