DBA Data[Home] [Help]

APPS.ARP_LOCKBOX_HOOK_PVT dependencies on FND_CURRENCIES

Line 553: from fnd_currencies fc

549: format_amount_app := format_amount_app1;
550:
551: select max(fc.precision)
552: into l_precision
553: from fnd_currencies fc
554: where fc.currency_code =
555: (select max(pi.currency_code)
556: from ar_payments_interface pi,
557: ar_payments_interface pi1

Line 976: FROM fnd_currencies d

972:
973: IF l_error_flag <> 'T' AND l_invoice_currency_code IS NOT NULL THEN
974: SELECT decode(format_amount_app, 'Y', d.precision, 0)
975: INTO l_inv_precision
976: FROM fnd_currencies d
977: WHERE d.currency_code = trim(l_invoice_currency_code);
978: END IF;
979:
980: /* If amount_applied_from is mentioned at both the matching number and resolved number

Line 1079: fnd_currencies d

1075: INTO l_org_id, l_lockbox_number, l_batch_name, l_currency_code, l_precision
1076: FROM ar_payments_interface_all a,
1077: ar_transmissions_all b,
1078: ar_trans_record_formats c,
1079: fnd_currencies d
1080: WHERE a.transmission_request_id = b.transmission_request_id
1081: AND b.requested_trans_format_id = c.transmission_format_id
1082: AND c.record_identifier = a.record_type
1083: AND d.currency_code = a.currency_code