DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on PQH_SS_STEP_HISTORY

Line 137: FROM pqh_ss_step_history sh,

133: SELECT step_history_id, datatype, name, value
134: FROM pqh_ss_value_history
135: WHERE (step_history_id,approval_history_id) IN (
136: SELECT sh.step_history_id, ah.approval_history_id
137: FROM pqh_ss_step_history sh,
138: pqh_ss_approval_history ah
139: WHERE ah.transaction_history_id = sh.transaction_history_id
140: AND sh.api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API'
141: AND ah.transaction_history_id = p_txnId