APPS.PQH_SS_PRINT dependencies on PQH_ATTRIBUTES

Line 991: FUNCTION get_value_from_params_table( p_column_name IN pqh_attributes.column_name%TYPE)

987: --
988: End purge_temp_data;
989: --
990:
991: FUNCTION get_value_from_params_table( p_column_name IN pqh_attributes.column_name%TYPE)
992: RETURN VARCHAR2 IS
993: -- local variables
994: --
995: l_proc varchar2(72) := g_package||'get_value_from_array';

Line 1030: l_key_column pqh_attributes.column_name%TYPE;

1026: l_proc varchar2(72) := g_package||'replace_where_clause_params';
1027: l_atoms_tab PQH_REFRESH_DATA.atoms_tabtype;
1028: -- to hold the where_clause atoms
1029: l_no_atoms number;
1030: l_key_column pqh_attributes.column_name%TYPE;
1031: l_key_val VARCHAR2(8000);
1032: l_where_out pqh_table_route.where_clause%TYPE;
1033: l_atom_length number;
1034: BEGIN

Line 1216: pqh_attributes att,

1212: ptr.where_clause where_clause,
1213: doc.document_category
1214: from pqh_documents_f doc,
1215: pqh_document_attributes_f doa,
1216: pqh_attributes att,
1217: pqh_table_route ptr
1218: where doc.short_name = p_doc_short_name
1219: AND doa.document_id = doc.document_id
1220: AND p_effective_date between doc.effective_start_date and doc.effective_end_date

Line 1230: pqh_attributes att

1226: cursor column_tag_names(p_table_route_id pqh_table_route.table_route_id %TYPE) is
1227: select att.column_name att_column,doa.tag_name doc_tag,att.enable_flag flag
1228: from pqh_documents_f doc,
1229: pqh_document_attributes_f doa,
1230: pqh_attributes att
1231: where doc.short_name = p_doc_short_name
1232: AND doa.document_id = doc.document_id
1233: AND p_effective_date between doc.effective_start_date and doc.effective_end_date
1234: AND p_effective_date between doa.effective_start_date and doa.effective_end_date

Line 1384: pqh_attributes att,

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
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

Line 1429: pqh_attributes att,

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,
1430: pqh_table_route ptr
1431: WHERE steps.step_history_id = atv.step_history_id
1432: AND steps.approval_history_id = atv.approval_history_id
1433: AND (atv.step_history_id,atv.approval_history_id) in