APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_DOCS_PAYABLE_ALL

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

Line 3002: FROM ap_document_lines_v apdl, iby_docs_payable_all ibydoc,

2998: ),
2999: IBY_FD_EXTRACT_EXT_PUB.Get_Docline_Ext_Agg(ibydoc.document_payable_id, apdl.line_number)
3000: )
3001: )
3002: FROM ap_document_lines_v apdl, iby_docs_payable_all ibydoc,
3003: iby_pay_service_requests ibypsr
3004: WHERE ibydoc.document_payable_id = p_document_payable_id
3005: AND ibydoc.calling_app_doc_unique_ref1 = apdl.calling_app_doc_unique_ref1
3006: AND nvl(ibydoc.calling_app_doc_unique_ref2,-99) = apdl.calling_app_doc_unique_ref2

Line 3434: FROM iby_docs_payable_all

3430: IS
3431: l_amount_withheld NUMBER;
3432: CURSOR l_pmt_amount_withheld_csr (p_payment_id IN NUMBER) IS
3433: SELECT sum(amount_withheld)
3434: FROM iby_docs_payable_all
3435: WHERE payment_id = p_payment_id;
3436: BEGIN
3437:
3438: OPEN l_pmt_amount_withheld_csr (payment_id);