DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on PQH_TXN_CATEGORY_DOCUMENTS

Line 147: pqh_txn_category_documents catDocs,

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
151: and cats.transaction_category_id = catDocs.transaction_category_id

Line 158: from pqh_txn_category_documents

154: --
155: --
156: Cursor csr_valid_grp_documents(p_short_name varchar2) IS
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)