APPS.FUN_WF_AUTHORIZATION_LIMIT dependencies on FUN_TRX_HEADERS

Line 11: l_to_ledger_id FUN_TRX_HEADERS.TO_LEDGER_ID%TYPE;

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:
15: SELECT TRXB.GL_DATE,

Line 21: FROM FUN_TRX_HEADERS TRXH,

17: TRXB.EXCHANGE_RATE_TYPE,
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:

Line 92: FROM GL_AUTHORIZATION_LIMITS GAL, FUN_TRX_HEADERS TRXH

88: aname => 'BATCH_NUMBER');
89: l_authorization_error := 'Batch Number:'||l_batch_number||', recipients of the Approval Hierarchy do not have the required authorization limits';
90: SELECT nvl(min(authorization_limit), -1)
91: INTO l_limit
92: FROM GL_AUTHORIZATION_LIMITS GAL, FUN_TRX_HEADERS TRXH
93: WHERE employee_id = (SELECT EMPLOYEE_ID
94: FROM FND_USER
95: WHERE USER_ID = fnd_global.user_id)
96: AND GAL.ledger_id = TRXH.TO_LEDGER_ID

Line 101: FROM FUN_TRX_HEADERS

97: AND TRXH.TRX_ID = l_transaction_id;
98:
99: SELECT ABS(NVL(INIT_AMOUNT_DR, 0) - NVL(INIT_AMOUNT_CR, 0))
100: INTO l_trx_amount
101: FROM FUN_TRX_HEADERS
102: WHERE TRX_ID = l_transaction_id;
103:
104: IF (l_trx_amount * get_conv_rate(l_transaction_id) <= l_limit) THEN
105: l_result := 'Y';

Line 171: FROM GL_AUTHORIZATION_LIMITS GAL, FUN_TRX_HEADERS TRXH

167: itemkey => itemkey,
168: aname => 'TRX_ID');
169: SELECT nvl(min(authorization_limit), -1)
170: INTO l_limit
171: FROM GL_AUTHORIZATION_LIMITS GAL, FUN_TRX_HEADERS TRXH
172: WHERE employee_id = (SELECT EMPLOYEE_ID
173: FROM FND_USER
174: WHERE USER_ID = fnd_global.user_id)
175: AND GAL.ledger_id = TRXH.TO_LEDGER_ID

Line 180: FROM FUN_TRX_HEADERS

176: AND TRXH.TRX_ID = l_transaction_id;
177:
178: SELECT ABS(NVL(INIT_AMOUNT_DR, 0) - NVL(INIT_AMOUNT_CR, 0))
179: INTO l_trx_amount
180: FROM FUN_TRX_HEADERS
181: WHERE TRX_ID = l_transaction_id;
182:
183: IF (l_trx_amount * get_conv_rate(l_transaction_id) <= l_limit) THEN
184: l_result := 'Y';

Line 211: p_trx_id IN FUN_TRX_HEADERS.TRX_ID%TYPE)

207: END CHECK_AUTHORIZATION_LIMIT_F;
208:
209: PROCEDURE HAS_VALID_EXCHANGE_RATE(
210: x_return_status OUT NOCOPY VARCHAR2,
211: p_trx_id IN FUN_TRX_HEADERS.TRX_ID%TYPE)
212: IS
213:
214: l_rate NUMBER;
215: