[Home] [Help]
1955: fv_report_definitions frd,
1956: fv_fund_parameters ffp,
1957: fv_treasury_symbols fts,
1958: ap_invoices_all ai,
1959: ap_invoice_distributions_all aid,
1960: ap_invoice_payments_all aip,
1961: ap_payment_hist_dists aphd,
1962: gl_import_references glir,
1963: xla_ae_headers xah,
2068: fv_report_definitions frd,
2069: fv_fund_parameters ffp,
2070: fv_treasury_symbols fts,
2071: ap_invoices_all ai,
2072: ap_invoice_distributions_all aid,
2073: ap_invoice_payments_all aip,
2074: gl_import_references glir,
2075: xla_ae_headers xah,
2076: xla_ae_lines xal,
2177: gl_code_combinations gcc,
2178: fv_report_definitions frd,
2179: fv_fund_parameters ffp,
2180: fv_treasury_symbols fts,
2181: ap_invoice_distributions_all aid,
2182: ap_invoice_payments_all aip,
2183: ap_payment_hist_dists aphd,
2184: gl_import_references glir,
2185: xla_ae_headers xah,
5194:
5195: RETURN DATE IS
5196: l_obligation_date DATE;
5197: l_module_name VARCHAR2(100);
5198: l_po_dist_id ap_invoice_distributions_all.po_distribution_id%TYPE;
5199: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
5200: BEGIN
5201: l_module_name := g_module_name || 'get_void_check_obligation_date';
5202: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5209: ------------- modified for bug 5454445
5210: SELECT NVL(max(po_distribution_id),0),
5211: NVL(max(parent_invoice_id),0)
5212: INTO l_po_dist_id, l_parent_invoice_id
5213: FROM ap_invoice_distributions_all
5214: WHERE invoice_id = p_invoice_id ;
5215: --AND distribution_line_number = p_inv_dist_num;
5216: --------------
5217: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5459: FROM
5460: ap_checks_all apc,
5461: ap_invoice_payments_all apip,
5462: ap_invoices_all api,
5463: ap_invoice_distributions_all apid
5464: WHERE apip.set_of_books_id = l_set_of_books_id
5465: AND apip.set_of_books_id = api.set_of_books_id
5466: AND api.set_of_books_id = apid.set_of_books_id
5467: AND apc.org_id = l_org_id
5482: WHERE invoice_payment_id = apip.invoice_payment_id)
5483: AND EXISTS (SELECT 1
5484: FROM gl_je_lines gljl,
5485: gl_je_headers gljh,
5486: ap_invoice_distributions_all apid
5487: WHERE gljl.ledger_id = apid.set_of_books_id
5488: AND gljl.status = 'P'
5489: AND gljh.je_header_id = gljl.je_header_id
5490: AND gljh.je_from_sla_flag = 'N'
5497: gl_je_headers gljh,
5498: gl_import_references glir,
5499: xla_ae_lines xal,
5500: xla_distribution_links xdl,
5501: ap_invoice_distributions_all apid
5502: WHERE gljl.ledger_id = apid.set_of_books_id
5503: AND glir.je_batch_id = gljh.je_batch_id
5504: AND glir.je_header_id = gljh.je_header_id
5505: AND glir.je_line_num = gljl.je_line_num