2260: ap_invoice_lines apl
2261: WHERE apl.invoice_id = x_invoice_id
2262: AND apl.line_number = x_chrg_line_number
2263: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2266: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2261: WHERE apl.invoice_id = x_invoice_id
2262: AND apl.line_number = x_chrg_line_number
2263: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2266: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2269: AND zxl.trx_id = apl.invoice_id
2262: AND apl.line_number = x_chrg_line_number
2263: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2266: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2269: AND zxl.trx_id = apl.invoice_id
2270: AND NVL(zxl.reporting_only_flag, 'N') = 'N'
2263: AND apl.summary_tax_line_id = zxl.summary_tax_line_id
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2266: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2269: AND zxl.trx_id = apl.invoice_id
2270: AND NVL(zxl.reporting_only_flag, 'N') = 'N'
2271: GROUP BY zxl.trx_line_number;
2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2266: AND zxl.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,
2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)
2269: AND zxl.trx_id = apl.invoice_id
2270: AND NVL(zxl.reporting_only_flag, 'N') = 'N'
2271: GROUP BY zxl.trx_line_number;
2272: