APPS.PQH_SS_PRINT dependencies on PQH_SS_STEP_HISTORY

Line 1425: FROM pqh_ss_step_history steps

1421: pqh_ss_utility.get_desc (
1422: decode(atv.value,null,null,
1423: att.decode_function_name||'('''||atv.value||''')' ) )) value,
1424: att.enable_flag
1425: FROM pqh_ss_step_history steps
1426: , pqh_ss_value_history atv,
1427: pqh_documents_f doc,
1428: pqh_document_attributes_f doa,
1429: pqh_attributes att,

Line 1436: from pqh_ss_step_history

1432: AND steps.approval_history_id = atv.approval_history_id
1433: AND (atv.step_history_id,atv.approval_history_id) in
1434: (
1435: Select step_history_id, approval_history_id
1436: from pqh_ss_step_history
1437: where transaction_history_id=p_transaction_id
1438: and approval_history_id = (
1439: Select max(approval_history_id) from pqh_ss_step_history
1440: where transaction_history_id=p_transaction_id)

Line 1439: Select max(approval_history_id) from pqh_ss_step_history

1435: Select step_history_id, approval_history_id
1436: from pqh_ss_step_history
1437: where transaction_history_id=p_transaction_id
1438: and approval_history_id = (
1439: Select max(approval_history_id) from pqh_ss_step_history
1440: where transaction_history_id=p_transaction_id)
1441: )
1442: AND steps.transaction_history_id =p_transaction_id
1443: AND doc.short_name = l_pdf_short_name