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