APPS.PQH_DOC_BUS dependencies on PQH_DOCUMENTS_F

Line 30: , pqh_documents_f doc

26: --
27: cursor csr_sec_grp is
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

Line 98: , pqh_documents_f doc

94: --
95: cursor csr_leg_code is
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

Line 418: FROM pqh_documents_f

414: l_proc varchar2(72) := g_package||'insert_validate';
415: --
416: CURSOR cur_is_duplicate_name(p_short_name varchar2) IS
417: SELECT 'X'
418: FROM pqh_documents_f
419: WHERE short_name = p_short_name;
420: --
421: l_short_name varchar2(10);
422: Begin

Line 458: FROM pqh_documents_f

454: l_proc varchar2(72) := g_package||'update_validate';
455: --
456: CURSOR cur_is_duplicate_name(p_short_name varchar2) IS
457: SELECT 'X'
458: FROM pqh_documents_f
459: WHERE document_id <> p_rec.document_id
460: and p_effective_date between effective_start_date and
461: effective_end_date
462: and short_name = p_short_name;