DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on AP_AWT_GROUP_TAXES_ALL

Line 5059: AP_AWT_GROUP_TAXES_all awtt,

5055: set asi.AFFECTS_REJECTION_LEVEL= 'Y'
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

Line 5809: AP_AWT_GROUP_TAXES_all awtt,

5805: set asi.AFFECTS_REJECTION_LEVEL= 'Y'
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