DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on CE_SECURITY_PROFILES_V

Line 2584: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp

2580:
2581: -- for ppr report we need to filter the docs by MOAC accessibility check
2582: CURSOR l_docpayable_ppr_rpt_csr (p_payment_id IN NUMBER) IS
2583: SELECT XMLAgg(doc_payable)
2584: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp
2585: WHERE xml_doc.payment_id = p_payment_id --bug 7459662
2586: AND xml_doc.document_payable_id = doc.document_payable_id
2587: AND ce_sp.organization_type = doc.org_type
2588: AND ce_sp.organization_id = doc.org_id