APPS.PQH_SS_PRINT dependencies on PQH_DOCUMENT_ATTRIBUTES_F

Line 1215: pqh_document_attributes_f doa,

1211: ptr.from_clause from_clause,
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

Line 1229: pqh_document_attributes_f doa,

1225: -- This curosr selects the column names and tag anme that need to be queried to form a dynamic sql query
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

Line 1383: pqh_document_attributes_f doa,

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
1386: -- Bug Fix 2945716,Added Select Stmt to retrieve max step_id
1387: WHERE atv.transaction_step_id in (Select max(transaction_step_id)

Line 1428: pqh_document_attributes_f doa,

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