DBA Data[Home] [Help]

APPS.PQH_DOA_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 32: ,pqh_transaction_categories ptc

28: select pbg.security_group_id
29: from per_business_groups pbg
30: , pqh_document_attributes_f doa
31: ,pqh_txn_category_attributes ptca
32: ,pqh_transaction_categories ptc
33: where doa.document_attribute_id = p_document_attribute_id
34: and doa.attribute_id = ptca.attribute_id
35: and ptca.transaction_category_id = ptc.transaction_category_id
36: and pbg.business_group_id = ptc.business_group_id;

Line 100: ,pqh_transaction_categories ptc

96: select pbg.legislation_code
97: from per_business_groups pbg
98: , pqh_document_attributes_f doa
99: ,pqh_txn_category_attributes ptca
100: ,pqh_transaction_categories ptc
101: where doa.document_attribute_id = p_document_attribute_id
102: and doa.attribute_id = ptca.attribute_id
103: and ptca.transaction_category_id = ptc.transaction_category_id
104: and pbg.business_group_id = ptc.business_group_id;