DBA Data[Home] [Help]

APPS.AP_ALLOCATION_RULES_PKG dependencies on AP_ETAX_PKG

Line 2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

2262: ap_invoice_lines apl
2263: WHERE apl.invoice_id = x_invoice_id
2264: AND apl.line_number = x_chrg_line_number
2265: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

Line 2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE

2263: WHERE apl.invoice_id = x_invoice_id
2264: AND apl.line_number = x_chrg_line_number
2265: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2271: AND zxl.trx_id = apl.invoice_id

Line 2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

2264: AND apl.line_number = x_chrg_line_number
2265: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2271: AND zxl.trx_id = apl.invoice_id
2272: AND NVL(zxl.reporting_only_flag, 'N') = 'N'

Line 2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

2265: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2271: AND zxl.trx_id = apl.invoice_id
2272: AND NVL(zxl.reporting_only_flag, 'N') = 'N'
2273: GROUP BY zxl.trx_line_number;

Line 2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

2266: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2267: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2268: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2269: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2270: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2271: AND zxl.trx_id = apl.invoice_id
2272: AND NVL(zxl.reporting_only_flag, 'N') = 'N'
2273: GROUP BY zxl.trx_line_number;
2274: