APPS.IBY_AR_UTILS dependencies on IBY_FNDCPT_TX_OPERATIONS

Line 332: (p_trxn_extension_id IN iby_fndcpt_tx_operations.trxn_extension_id%TYPE,

328: END get_line_tax_rate;
329:
330: -- Return: The Authorization Flag for the given Transaction Extension Id
331: PROCEDURE get_authorization_status
332: (p_trxn_extension_id IN iby_fndcpt_tx_operations.trxn_extension_id%TYPE,
333: x_auth_flag OUT NOCOPY VARCHAR2)
334: IS
335: BEGIN
336: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG

Line 339: , iby_fndcpt_tx_operations op

335: BEGIN
336: SELECT decode(summ.status, NULL, 'N', 'Y') AUTHORIZED_FLAG
337: into x_auth_flag
338: FROM iby_trxn_summaries_all summ
339: , iby_fndcpt_tx_operations op
340: WHERE summ.transactionid = op.transactionid
341: AND reqtype = 'ORAPMTREQ'
342: AND status IN(0, 100)
343: AND trxntypeid IN(2, 3, 20)

Line 347: , iby_fndcpt_tx_operations op1

343: AND trxntypeid IN(2, 3, 20)
344: AND op.trxn_extension_id = p_trxn_extension_id
345: AND summ.trxnmid = (SELECT MAX(trxnmid)
346: FROM iby_trxn_summaries_all summ1
347: , iby_fndcpt_tx_operations op1
348: WHERE summ1.transactionid = op1.transactionid
349: AND summ1.reqtype = 'ORAPMTREQ'
350: AND summ1.status IN(0, 100)
351: AND summ1.trxntypeid IN(2, 3, 20)