[Home] [Help]
3458:
3459: -- for ppr report we need to filter the docs by MOAC accessibility check
3460: CURSOR l_docpayable_ppr_rpt_csr (p_payment_id IN NUMBER) IS
3461: SELECT XMLAgg(doc_payable)
3462: FROM iby_xml_fd_doc_1_0_v xml_doc, iby_docs_payable_all doc, ce_security_profiles_v ce_sp
3463: WHERE xml_doc.payment_id = p_payment_id --bug 7459662
3464: AND xml_doc.document_payable_id = doc.document_payable_id
3465: AND ce_sp.organization_type = doc.org_type
3466: AND ce_sp.organization_id = doc.org_id