DBA Data[Home] [Help]

APPS.AP_R11_PREPAY_PKG dependencies on FND_CURRENCIES

Line 650: FROM fnd_currencies

646: ---------------------------------------------------------------------
647: debug_info := 'Get min_unit and precision for the prepayment';
648: SELECT minimum_accountable_unit, nvl(precision,0)
649: INTO X_min_unit, X_precision
650: FROM fnd_currencies
651: WHERE currency_code = C_currency_code;
652:
653:
654: ---------------------------------------------------------------------

Line 660: FROM fnd_currencies

656: ---------------------------------------------------------------------
657: debug_info := 'Get C_min_unit and C_precision for the prepayment';
658: SELECT minimum_accountable_unit, nvl(precision,0)
659: INTO C_min_unit, C_precision
660: FROM fnd_currencies
661: WHERE currency_code = C_currency_code;
662:
663:
664: ---------------------------------------------------------------------

Line 670: FROM FND_CURRENCIES

666: ---------------------------------------------------------------------
667: debug_info :='Get min_unit and precision from base_currency';
668: SELECT MINIMUM_ACCOUNTABLE_UNIT, nvl(PRECISION,0)
669: INTO X_base_min_unit , X_base_precision
670: FROM FND_CURRENCIES
671: WHERE CURRENCY_CODE = ( SELECT BASE_CURRENCY_CODE
672: FROM AP_SYSTEM_PARAMETERS);
673:
674:

Line 683: FROM fnd_currencies

679: SELECT minimum_accountable_unit, nvl(precision,0),
680: minimum_accountable_unit, nvl(precision,0)
681: INTO X_pay_curr_min_unit, X_pay_curr_precision,
682: C_pay_curr_min_unit, C_pay_curr_precision
683: FROM fnd_currencies
684: WHERE currency_code = ( SELECT payment_currency_code
685: FROM ap_invoices
686: WHERE invoice_id = X_prepay_id);
687: