DBA Data[Home] [Help]

APPS.PQH_DOC_BUS dependencies on PQH_TXN_CATEGORY_DOCUMENTS

Line 32: , pqh_txn_category_documents pcd

28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_documents_f doc
31: , pqh_transaction_categories ptc
32: , pqh_txn_category_documents pcd
33: where doc.document_id = p_document_id
34: and pbg.business_group_id = ptc.business_group_id
35: and pcd.document_id = doc.document_id
36: and pcd.transaction_category_id = ptc.transaction_category_id;

Line 100: , pqh_txn_category_documents pcd

96: select pbg.legislation_code
97: from per_business_groups pbg
98: , pqh_documents_f doc
99: , pqh_transaction_categories ptc
100: , pqh_txn_category_documents pcd
101: where doc.document_id = p_document_id
102: and pbg.business_group_id = ptc.business_group_id
103: and pcd.document_id = doc.document_id
104: and pcd.transaction_category_id = ptc.transaction_category_id;