DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on PQH_SS_TRANSACTION_HISTORY

Line 1085: FROM pqh_ss_transaction_history history,

1081: cursor c_AMETxnDetails(c_offerId in varchar2) is
1082: SELECT history.transaction_history_id
1083: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMETranType')
1084: ,irc_xml_util.valueOf(histstate.transaction_document,'/Transaction/TransCtx/pAMEAppId')
1085: FROM pqh_ss_transaction_history history,
1086: pqh_ss_trans_state_history histstate
1087: WHERE history.transaction_identifier = 'OFFER'
1088: AND history.transaction_history_id = ( SELECT min(transaction_history_id)
1089: FROM pqh_ss_step_history