DBA Data[Home] [Help]

APPS.PQH_TCD_BUS dependencies on PQH_TRANSACTION_CATEGORIES

Line 35: , pqh_transaction_categories tct

31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , pqh_txn_category_documents tcd
35: , pqh_transaction_categories tct
36: where tcd.document_id = p_document_id
37: and tcd.transaction_category_id = p_transaction_category_id
38: and pbg.business_group_id = tct.business_group_id
39: and tcd.transaction_category_id = tct.transaction_category_id;

Line 116: , pqh_transaction_categories tct

112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , pqh_txn_category_documents tcd
116: , pqh_transaction_categories tct
117: where tcd.document_id = p_document_id
118: and tcd.transaction_category_id = p_transaction_category_id
119: and pbg.business_group_id = tct.business_group_id
120: and tcd.transaction_category_id = tct.transaction_category_id;