APPS.FUN_IC_AME_WF_PKG dependencies on FUN_TRX_BATCHES

Line 36: fun_trx_batches btch,

32: THEN
33: SELECT DISTINCT hz.party_name
34: INTO l_return_value
35: FROM hz_parties hz,
36: fun_trx_batches btch,
37: fun_trx_headers head
38: WHERE hz.party_id = btch.initiator_id
39: AND btch.batch_id = head.batch_id
40: AND head.trx_id = p_transaction_id;

Line 47: fun_trx_batches btch,

43: THEN
44: SELECT DISTINCT xla.name
45: INTO l_return_value
46: FROM xle_firstparty_information_v xla,
47: fun_trx_batches btch,
48: fun_trx_headers head
49: WHERE xla.legal_entity_id = btch.from_le_id
50: AND btch.batch_id = head.batch_id
51: AND head.trx_id = p_transaction_id;

Line 58: fun_trx_batches btch,

54: THEN
55: SELECT DISTINCT gl.name
56: INTO l_return_value
57: FROM gl_ledgers gl,
58: fun_trx_batches btch,
59: fun_trx_headers head
60: WHERE gl.ledger_id = btch.from_ledger_id
61: AND btch.batch_id = head.batch_id
62: AND head.trx_id = p_transaction_id;

Line 69: fun_trx_batches btch,

65: THEN
66: SELECT DISTINCT tt.trx_type_name
67: INTO l_return_value
68: FROM fun_trx_types_tl tt,
69: fun_trx_batches btch,
70: fun_trx_headers head
71: WHERE tt.trx_type_id = btch.trx_type_id
72: AND btch.batch_id = head.batch_id
73: AND head.trx_id = p_transaction_id;