DBA Data[Home] [Help]

APPS.ARP_BAL_UTIL dependencies on FND_CURRENCIES

Line 297: l_base_curr_code fnd_currencies.currency_code%type;

293: ) IS
294:
295: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
296: l_exchange_rate ra_customer_trx.exchange_rate%type;
297: l_base_curr_code fnd_currencies.currency_code%type;
298: l_base_precision fnd_currencies.precision%type;
299: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
300:
301: l_line_original NUMBER;

Line 298: l_base_precision fnd_currencies.precision%type;

294:
295: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
296: l_exchange_rate ra_customer_trx.exchange_rate%type;
297: l_base_curr_code fnd_currencies.currency_code%type;
298: l_base_precision fnd_currencies.precision%type;
299: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
300:
301: l_line_original NUMBER;
302: l_line_remaining NUMBER;

Line 299: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

295: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
296: l_exchange_rate ra_customer_trx.exchange_rate%type;
297: l_base_curr_code fnd_currencies.currency_code%type;
298: l_base_precision fnd_currencies.precision%type;
299: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
300:
301: l_line_original NUMBER;
302: l_line_remaining NUMBER;
303: l_tax_original NUMBER;

Line 457: FROM fnd_currencies fc,

453: minimum_accountable_unit
454: INTO l_base_curr_code,
455: l_base_precision,
456: l_base_min_acc_unit
457: FROM fnd_currencies fc,
458: gl_sets_of_books sob
459: WHERE sob.set_of_books_id = arp_global.set_of_books_id
460: AND sob.currency_code = fc.currency_code;
461:

Line 1871: l_currency_code fnd_currencies.currency_code%type;

1867: RETURN NUMBER IS
1868:
1869: l_commitment_bal number;
1870: l_commitment_class ra_cust_trx_types.type%type;
1871: l_currency_code fnd_currencies.currency_code%type;
1872: /* 1580737 - holds subsequent_trx_type_id */
1873: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1874: /* 1483656 - holds the allocation flag */
1875: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;

Line 2430: l_base_curr_code fnd_currencies.currency_code%type;

2426: l_base_tax_adjustments NUMBER;
2427: l_base_freight_adjustments NUMBER;
2428: l_base_total_adjustments NUMBER;
2429:
2430: l_base_curr_code fnd_currencies.currency_code%type;
2431: l_base_precision fnd_currencies.precision%type;
2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2433:
2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;

Line 2431: l_base_precision fnd_currencies.precision%type;

2427: l_base_freight_adjustments NUMBER;
2428: l_base_total_adjustments NUMBER;
2429:
2430: l_base_curr_code fnd_currencies.currency_code%type;
2431: l_base_precision fnd_currencies.precision%type;
2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2433:
2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2435: BEGIN

Line 2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;

2428: l_base_total_adjustments NUMBER;
2429:
2430: l_base_curr_code fnd_currencies.currency_code%type;
2431: l_base_precision fnd_currencies.precision%type;
2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2433:
2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2435: BEGIN
2436:

Line 2457: FROM fnd_currencies fc,

2453: minimum_accountable_unit
2454: INTO l_base_curr_code,
2455: l_base_precision,
2456: l_base_min_acc_unit
2457: FROM fnd_currencies fc,
2458: gl_sets_of_books sob
2459: WHERE sob.set_of_books_id = arp_global.set_of_books_id
2460: AND sob.currency_code = fc.currency_code;
2461: