DBA Data[Home] [Help]

APPS.AP_ALLOCATION_RULES_PKG dependencies on AP_ETAX_PKG

Line 2264: AND zxl.application_id = AP_ETAX_PKG.AP_APPLICATION_ID

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)

Line 2265: AND zxl.entity_code = AP_ETAX_PKG.AP_ENTITY_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

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

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'

Line 2267: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

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;

Line 2268: AP_ETAX_PKG.AP_ER_EVENT_CLASS_CODE)

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: