DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on PQH_TRANSACTION_CATEGORIES

Line 146: from pqh_transaction_categories cats,

142: --
143: --
144: Cursor csr_check_grp_existency(p_short_name varchar2, p_eff_date date) IS
145: Select count(*)
146: from pqh_transaction_categories cats,
147: pqh_txn_category_documents catDocs,
148: pqh_documents_f docs
149: where form_name like 'PQH_GROUPS'
150: and cats.short_name like p_short_name

Line 161: from pqh_transaction_categories

157: Select count(*)
158: from pqh_txn_category_documents
159: where transaction_category_id = (
160: Select transaction_category_id
161: from pqh_transaction_categories
162: where short_name =p_short_name)
163: and type_code in ( p_type_code, 'BOTH');
164: --
165: --