APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_XML_FD_DOC_1_0_V

Line 2731: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl

2727: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableCount';
2728: /* Performance Fix : 9184059
2729: CURSOR l_pmt_docpayablecount_csr (p_payment_id IN NUMBER) IS
2730: SELECT count(payment_id)
2731: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl
2732: WHERE xml_doc_lvl.formatting_payment_id = p_payment_id; --bug 7006504
2733: */
2734: /* Perf Function : 9184059*/
2735: CURSOR l_pmt_docpayablecount_csr (p_payment_id IN NUMBER) IS

Line 2745: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl

2741:
2742: /* Performance Fix : 9184059
2743: CURSOR l_docpayablecount_ppr_rpt_csr (p_payment_id IN NUMBER) IS
2744: SELECT count(payment_id)
2745: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl
2746: WHERE xml_doc_lvl.payment_id = p_payment_id; --bug 7459662
2747: */
2748: CURSOR l_docpayablecount_ppr_rpt_csr (p_payment_id IN NUMBER) IS
2749: SELECT count(payment_id)

Line 3447: FROM iby_xml_fd_doc_1_0_v

3443: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
3444:
3445: CURSOR l_docpayable_csr (p_payment_id IN NUMBER) IS
3446: SELECT XMLAgg(doc_payable)
3447: FROM iby_xml_fd_doc_1_0_v
3448: WHERE formatting_payment_id = p_payment_id --bug 7006504
3449: AND document_status <> 'REMOVED';
3450:
3451: -- bug 11839898

Line 3455: FROM iby_xml_fd_doc_1_0_v

3451: -- bug 11839898
3452: -- void by overflow documents should be printed under the real paying check
3453: CURSOR l_docpayable_sra_csr (p_payment_id IN NUMBER) IS
3454: SELECT XMLAgg(doc_payable)
3455: FROM iby_xml_fd_doc_1_0_v
3456: WHERE payment_id = p_payment_id
3457: AND document_status <> 'REMOVED';
3458:
3459: -- for ppr report we need to filter the docs by MOAC accessibility check

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

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

Line 3471: FROM iby_xml_fd_doc_1_0_v

3467: AND xml_doc.document_status <> 'REMOVED';
3468:
3469: CURSOR l_docpayable_amex_csr (p_payment_id IN NUMBER) IS
3470: SELECT XMLAgg(doc_payable)
3471: FROM iby_xml_fd_doc_1_0_v
3472: WHERE formatting_payment_id = p_payment_id
3473: AND document_status = 'PAYMENT_CREATED';
3474:
3475: BEGIN

Line 4739: FROM iby_xml_fd_doc_1_0_v

4735: l_docpayable_agg XMLTYPE;
4736:
4737: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS
4738: SELECT XMLAgg(doc_payable)
4739: FROM iby_xml_fd_doc_1_0_v
4740: WHERE payment_service_request_id = p_payment_service_request_id
4741: AND payment_id is null;
4742: -- AND document_status in ('REJECTED', 'FAILED_VALIDATION');
4743:

Line 4761: FROM iby_xml_fd_doc_1_0_v

4757: l_docpayable_count NUMBER;
4758:
4759: CURSOR l_baddoc_count_csr (p_payment_service_request_id IN NUMBER) IS
4760: SELECT count(document_payable_id)
4761: FROM iby_xml_fd_doc_1_0_v
4762: WHERE payment_service_request_id = p_payment_service_request_id
4763: AND payment_id is null;
4764: -- AND document_status in ('REJECTED', 'FAILED_VALIDATION');
4765: