DBA Data[Home] [Help]

APPS.FUN_IC_AME_WF_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 46: FROM xle_firstparty_information_v xla,

42: ELSIF p_attribute_name = 'BATCH_FROM_LE_NAME'
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

Line 97: FROM xle_firstparty_information_v xla,

93: ELSIF p_attribute_name = 'HEADER_TO_LE_NAME'
94: THEN
95: SELECT DISTINCT xla.name
96: INTO l_return_value
97: FROM xle_firstparty_information_v xla,
98: fun_trx_headers head
99: WHERE xla.legal_entity_id = head.to_le_id
100: AND head.trx_id = p_transaction_id;
101: