10: G_REQUEST_ID NUMBER;
11: PG_DEBUG NUMBER(2);
12:
13: g_base_currency_code gl_sets_of_books.currency_code%TYPE;
14: g_base_precision fnd_currencies.precision%type;
15: g_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
16:
17: FUNCTION GET_CREDIT_LIMIT(p_party_id IN NUMBER,
18: p_cust_account_id IN NUMBER,
11: PG_DEBUG NUMBER(2);
12:
13: g_base_currency_code gl_sets_of_books.currency_code%TYPE;
14: g_base_precision fnd_currencies.precision%type;
15: g_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
16:
17: FUNCTION GET_CREDIT_LIMIT(p_party_id IN NUMBER,
18: p_cust_account_id IN NUMBER,
19: p_customer_site_use_id IN NUMBER,
431: select gll.currency_code, c.precision, c.minimum_accountable_unit
432: INTO g_base_currency_code,g_base_precision,g_base_min_acc_unit
433: from ar_system_parameters sp,
434: gl_ledgers_public_v gll,
435: fnd_currencies c
436: where
437: gll.ledger_id = sp.set_of_books_id
438: and gll.currency_code = c.currency_code;
439: