APPS.FUN_WF_AUTHORIZATION_LIMIT dependencies on FUN_TRX_BATCHES

Line 8: l_gl_date FUN_TRX_BATCHES.GL_DATE%TYPE;

4: FUNCTION get_conv_rate(p_trx_id NUMBER) RETURN NUMBER
5: IS
6:
7: l_precision NUMBER;
8: l_gl_date FUN_TRX_BATCHES.GL_DATE%TYPE;
9: l_currency_code FUN_TRX_BATCHES.CURRENCY_CODE%TYPE;
10: l_exchange_rate_type FUN_TRX_BATCHES.EXCHANGE_RATE_TYPE%TYPE;
11: l_to_ledger_id FUN_TRX_HEADERS.TO_LEDGER_ID%TYPE;
12:

Line 9: l_currency_code FUN_TRX_BATCHES.CURRENCY_CODE%TYPE;

5: IS
6:
7: l_precision NUMBER;
8: l_gl_date FUN_TRX_BATCHES.GL_DATE%TYPE;
9: l_currency_code FUN_TRX_BATCHES.CURRENCY_CODE%TYPE;
10: l_exchange_rate_type FUN_TRX_BATCHES.EXCHANGE_RATE_TYPE%TYPE;
11: l_to_ledger_id FUN_TRX_HEADERS.TO_LEDGER_ID%TYPE;
12:
13: BEGIN

Line 10: l_exchange_rate_type FUN_TRX_BATCHES.EXCHANGE_RATE_TYPE%TYPE;

6:
7: l_precision NUMBER;
8: l_gl_date FUN_TRX_BATCHES.GL_DATE%TYPE;
9: l_currency_code FUN_TRX_BATCHES.CURRENCY_CODE%TYPE;
10: l_exchange_rate_type FUN_TRX_BATCHES.EXCHANGE_RATE_TYPE%TYPE;
11: l_to_ledger_id FUN_TRX_HEADERS.TO_LEDGER_ID%TYPE;
12:
13: BEGIN
14:

Line 22: FUN_TRX_BATCHES TRXB

18: TRXH.TO_LEDGER_ID
19: INTO l_gl_date, l_currency_code,
20: l_exchange_rate_type, l_to_ledger_id
21: FROM FUN_TRX_HEADERS TRXH,
22: FUN_TRX_BATCHES TRXB
23: WHERE TRXB.BATCH_ID = TRXH.BATCH_ID
24: AND TRXH.TRX_ID = p_trx_id;
25:
26: return GL_CURRENCY_API.Get_Rate_Sql(l_to_ledger_id,