DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on HR_API_TRANSACTION_VALUES

Line 234: FROM hr_api_transaction_values atv

230: -- 'P_SELECTED_EMP_ID, P_PASSED_ASSIGNMENT_ID removed from list as current
231: --manager not obtained from base table but from transaction table.
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

Line 1381: , hr_api_transaction_values atv,

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,
1385: pqh_table_route ptr