DBA Data[Home] [Help]

APPS.ARP_BAL_UTIL dependencies on FND_CURRENCIES

Line 355: l_base_curr_code fnd_currencies.currency_code%type;

351: ) IS
352:
353: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
354: l_exchange_rate ra_customer_trx.exchange_rate%type;
355: l_base_curr_code fnd_currencies.currency_code%type;
356: l_base_precision fnd_currencies.precision%type;
357: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
358:
359: l_line_original NUMBER;

Line 356: l_base_precision fnd_currencies.precision%type;

352:
353: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
354: l_exchange_rate ra_customer_trx.exchange_rate%type;
355: l_base_curr_code fnd_currencies.currency_code%type;
356: l_base_precision fnd_currencies.precision%type;
357: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
358:
359: l_line_original NUMBER;
360: l_line_remaining NUMBER;

Line 357: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

353: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
354: l_exchange_rate ra_customer_trx.exchange_rate%type;
355: l_base_curr_code fnd_currencies.currency_code%type;
356: l_base_precision fnd_currencies.precision%type;
357: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
358:
359: l_line_original NUMBER;
360: l_line_remaining NUMBER;
361: l_tax_original NUMBER;

Line 521: FROM fnd_currencies fc,

517: minimum_accountable_unit
518: INTO l_base_curr_code,
519: l_base_precision,
520: l_base_min_acc_unit
521: FROM fnd_currencies fc,
522: gl_sets_of_books sob
523: WHERE sob.set_of_books_id = arp_global.set_of_books_id
524: AND sob.currency_code = fc.currency_code;
525:

Line 1958: l_currency_code fnd_currencies.currency_code%type;

1954: RETURN NUMBER IS
1955:
1956: l_commitment_bal number;
1957: l_commitment_class ra_cust_trx_types.type%type;
1958: l_currency_code fnd_currencies.currency_code%type;
1959: /* 1580737 - holds subsequent_trx_type_id */
1960: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1961: /* 1483656 - holds the allocation flag */
1962: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;

Line 2517: l_base_curr_code fnd_currencies.currency_code%type;

2513: l_base_tax_adjustments NUMBER;
2514: l_base_freight_adjustments NUMBER;
2515: l_base_total_adjustments NUMBER;
2516:
2517: l_base_curr_code fnd_currencies.currency_code%type;
2518: l_base_precision fnd_currencies.precision%type;
2519: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2520:
2521: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;

Line 2518: l_base_precision fnd_currencies.precision%type;

2514: l_base_freight_adjustments NUMBER;
2515: l_base_total_adjustments NUMBER;
2516:
2517: l_base_curr_code fnd_currencies.currency_code%type;
2518: l_base_precision fnd_currencies.precision%type;
2519: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2520:
2521: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2522: BEGIN

Line 2519: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

2515: l_base_total_adjustments NUMBER;
2516:
2517: l_base_curr_code fnd_currencies.currency_code%type;
2518: l_base_precision fnd_currencies.precision%type;
2519: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2520:
2521: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2522: BEGIN
2523:

Line 2544: FROM fnd_currencies fc,

2540: minimum_accountable_unit
2541: INTO l_base_curr_code,
2542: l_base_precision,
2543: l_base_min_acc_unit
2544: FROM fnd_currencies fc,
2545: gl_sets_of_books sob
2546: WHERE sob.set_of_books_id = arp_global.set_of_books_id
2547: AND sob.currency_code = fc.currency_code;
2548: