APPS.PQH_SS_PRINT dependencies on HR_API_TRANSACTION_STEPS

Line 236: From hr_api_transaction_steps

232: Cursor obtain_param_values is
233: SELECT atv.name column_name,atv.datatype column_type,atv.varchar2_value|| Atv.Number_value||FND_DATE.date_to_canonical(Atv.date_value) column_value
234: FROM hr_api_transaction_values atv
235: WHERE atv.transaction_step_id in (Select max(transaction_step_id)
236: From hr_api_transaction_steps
237: where transaction_id = p_Transaction_Id
238: group by api_name
239: )
240: AND atv.name in ('P_PERSON_ID','P_ASSIGNMENT_ID','P_QUALIFICATION_ID','P_SELECTED_PERSON_ID');

Line 1380: FROM hr_api_transaction_steps steps

1376: null,null,
1377: att.decode_function_name||'('''||atv.varchar2_value|| Atv.Number_value
1378: ||FND_DATE.date_to_canonical(Atv.date_value)||''')' ) )) value,
1379: att.enable_flag
1380: FROM hr_api_transaction_steps steps
1381: , hr_api_transaction_values atv,
1382: pqh_documents_f doc,
1383: pqh_document_attributes_f doa,
1384: pqh_attributes att,

Line 1388: From hr_api_transaction_steps

1384: pqh_attributes att,
1385: pqh_table_route ptr
1386: -- Bug Fix 2945716,Added Select Stmt to retrieve max step_id
1387: WHERE atv.transaction_step_id in (Select max(transaction_step_id)
1388: From hr_api_transaction_steps
1389: where transaction_id = p_Transaction_Id
1390: group by api_name
1391: )
1392: AND atv.transaction_step_id = steps.transaction_step_id