DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_TAX_CODES_ALL

Line 5060: ap_tax_codes_all awtc

5056: where asi.checkrun_id = l_checkrun_id
5057: and exists ( select 'ATLEAST ONE RANGE BASED PAY TIME AWT'
5058: from ap_invoice_distributions_all aid,
5059: AP_AWT_GROUP_TAXES_all awtt,
5060: ap_tax_codes_all awtc
5061: where aid.invoice_id = asi.invoice_id
5062: and aid.pay_awt_group_id is not null
5063: and awtt.group_id = aid.pay_awt_group_id
5064: and awtt.tax_name = awtc.name

Line 5810: ap_tax_codes_all awtc

5806: where asi.checkrun_id = p_checkrun_id
5807: and exists ( select 'ATLEAST ONE RANGE BASED PAY TIME AWT'
5808: from ap_invoice_distributions_all aid,
5809: AP_AWT_GROUP_TAXES_all awtt,
5810: ap_tax_codes_all awtc
5811: where aid.invoice_id = asi.invoice_id
5812: and aid.pay_awt_group_id is not null
5813: and awtt.group_id = aid.pay_awt_group_id
5814: and awtt.tax_name = awtc.name