APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_XML_FD_DOC_1_0_V

Line 1961: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl

1957: l_pmt_docpayablecount NUMBER;
1958: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableCount';
1959: CURSOR l_pmt_docpayablecount_csr (p_payment_id IN NUMBER) IS
1960: SELECT count(payment_id)
1961: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl
1962: WHERE xml_doc_lvl.formatting_payment_id = p_payment_id; --bug 7006504
1963:
1964: CURSOR l_docpayablecount_ppr_rpt_csr (p_payment_id IN NUMBER) IS
1965: SELECT count(payment_id)

Line 1966: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl

1962: WHERE xml_doc_lvl.formatting_payment_id = p_payment_id; --bug 7006504
1963:
1964: CURSOR l_docpayablecount_ppr_rpt_csr (p_payment_id IN NUMBER) IS
1965: SELECT count(payment_id)
1966: FROM iby_xml_fd_doc_1_0_v xml_doc_lvl
1967: WHERE xml_doc_lvl.payment_id = p_payment_id; --bug 7459662
1968: BEGIN
1969: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1970: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,

Line 2577: FROM iby_xml_fd_doc_1_0_v

2573: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_Pmt_DocPayableAgg';
2574:
2575: CURSOR l_docpayable_csr (p_payment_id IN NUMBER) IS
2576: SELECT XMLAgg(doc_payable)
2577: FROM iby_xml_fd_doc_1_0_v
2578: WHERE formatting_payment_id = p_payment_id --bug 7006504
2579: AND document_status <> 'REMOVED';
2580:
2581: -- for ppr report we need to filter the docs by MOAC accessibility check

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 3500: FROM iby_xml_fd_doc_1_0_v

3496: l_docpayable_agg XMLTYPE;
3497:
3498: CURSOR l_baddoc_csr (p_payment_service_request_id IN NUMBER) IS
3499: SELECT XMLAgg(doc_payable)
3500: FROM iby_xml_fd_doc_1_0_v
3501: WHERE payment_service_request_id = p_payment_service_request_id
3502: AND payment_id is null;
3503: -- AND document_status in ('REJECTED', 'FAILED_VALIDATION');
3504:

Line 3522: FROM iby_xml_fd_doc_1_0_v

3518: l_docpayable_count NUMBER;
3519:
3520: CURSOR l_baddoc_count_csr (p_payment_service_request_id IN NUMBER) IS
3521: SELECT count(document_payable_id)
3522: FROM iby_xml_fd_doc_1_0_v
3523: WHERE payment_service_request_id = p_payment_service_request_id
3524: AND payment_id is null;
3525: -- AND document_status in ('REJECTED', 'FAILED_VALIDATION');
3526: