APPS.JE_IL_TAX_PKG dependencies on AP_CHECKS_ALL

Line 45: ap_checks_all ac

41: 'SELECT aag.name awt_group_name, ''A'' awt_flag
42: FROM ap_invoices_all ai,
43: ap_invoice_payments_all aip,
44: ap_awt_groups aag,
45: ap_checks_all ac
46: WHERE ac.check_id = :check_id
47: AND ac.check_id = aip.check_id
48: AND aip.invoice_id = ai.invoice_id
49: AND aag.group_id = nvl(ai.awt_group_id, ai.pay_awt_group_id)

Line 419: ap_checks_all ac,

415: ELSE 1
416: END) countv
417: FROM ap_invoices_all ai,
418: ap_invoice_distributions_all aid,
419: ap_checks_all ac,
420: ap_invoice_payments_all aip,
421: po_vendors pvend,
422: po_vendor_sites_all pvs,
423: (SELECT distinct person_id,

Line 463: ,ap_checks_all ac

459: END ) countv,
460: COUNT(distinct(ac.vendor_site_id)) countt
461: FROM ap_invoices_all ai
462: ,ap_invoice_distributions_all aid
463: ,ap_checks_all ac
464: ,ap_invoice_payments_all aip
465: WHERE ai.invoice_id = aid.invoice_id
466: AND ac.check_id=aip.check_id
467: AND aip.invoice_id=ai.invoice_id

Line 486: ,AP_CHECKS_ALL ac1

482: ELSE 1
483: END ) countv,
484: COUNT(distinct(ac1.vendor_site_id)) countt
485: FROM AP_INVOICE_PAYMENTS_ALL aip1
486: ,AP_CHECKS_ALL ac1
487: ,PO_VENDORS pvend1
488: ,PO_VENDOR_SITES_ALL pvs1
489: WHERE aip1.check_id = ac1.check_id
490: AND aip1.set_of_books_id= ' || l_primary_ledger_id || '

Line 695: FROM AP_CHECKS_ALL ac

691: GROUP BY xdln.event_id;
692:
693: CURSOR c_get_bank_awt IS
694: SELECT TO_NUMBER(ac.global_attribute1) bank_wht_amount
695: FROM AP_CHECKS_ALL ac
696: ,PO_VENDORS pv
697: ,PO_VENDOR_SITES_ALL pvs
698: WHERE ac.check_id =pn_check_id
699: AND ac.vendor_id = pv.vendor_id

Line 904: FROM AP_CHECKS_ALL ac

900:
901: BEGIN
902: --- Verify if the check is related to Bank AWT
903: SELECT count(1) INTO l_bank_awt_check
904: FROM AP_CHECKS_ALL ac
905: WHERE ac.check_id= pn_check_id
906: AND ac.global_attribute_category='JE.IL.APXPAWKB.CHECKS'
907: AND NVL(ac.global_attribute1,0) > 0;
908:

Line 1077: REM column of ap_checks_all table.

1073: REM Description: This function is called from XML queries Q_PAYMENTS,Q_BY_PERIODS
1074: REM This functions fetches the Withholding Amount for
1075: REM a given Ledger ID from SLA tables excluding the
1076: REM withholding amount paid by bank present in global attribute1
1077: REM column of ap_checks_all table.
1078: REM Parameters: InvoiceID, Accounting Start and End Date, Payment Void or Not
1079: REM +======================================================================+
1080: */
1081: FUNCTION Get_Awt_Amt( Pn_Invoice_Id IN NUMBER

Line 1148: FROM AP_CHECKS_ALL ac

1144: RETURN NUMBER
1145: IS
1146: CURSOR c_get_bank_awt IS
1147: SELECT TO_NUMBER(ac.global_attribute1) bank_wht_amount
1148: FROM AP_CHECKS_ALL ac
1149: ,PO_VENDORS pv
1150: ,PO_VENDOR_SITES_ALL pvs
1151: WHERE ac.check_id =pn_check_id
1152: AND ac.vendor_id = pv.vendor_id