APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_LINES_SUMMARY

Line 1238: FROM zx_lines_summary ls

1234: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1235: AND ail.line_type_lookup_code = 'TAX'
1236: AND NOT EXISTS
1237: (SELECT ls.summary_tax_line_id
1238: FROM zx_lines_summary ls
1239: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1240: AND ls.trx_id = ail.invoice_id
1241: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1242: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1262: FROM zx_lines_summary zl

1258: --summary line should not be allowed to delete if it has frozen distribution
1259: --as checked in above EXISTS hence no further checks needed. bug 10621602
1260: /* AND EXISTS
1261: (SELECT zl.summary_tax_line_id
1262: FROM zx_lines_summary zl
1263: WHERE zl.application_id = 200
1264: AND zl.entity_code = 'AP_INVOICES'
1265: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1266: AND zl.trx_id = ail.invoice_id

Line 1411: FROM zx_lines_summary zls

1407: zls.tax_rate_id, -- tax_rate_id
1408: zls.tax_rate_code, -- tax_rate_code
1409: zls.tax_rate, -- tax_rate
1410: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
1411: FROM zx_lines_summary zls
1412: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
1413: AND nvl(zls.reporting_only_flag, 'N') = 'N'
1414: )
1415: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 1419: FROM zx_lines_summary ls

1415: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1416: AND ail.line_type_lookup_code = 'TAX'
1417: AND EXISTS
1418: (SELECT ls.summary_tax_line_id
1419: FROM zx_lines_summary ls
1420: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1421: AND ls.trx_id = ail.invoice_id
1422: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1423: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1523: FROM zx_lines_summary ls

1519: DELETE ap_invoice_lines_all ail
1520: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1521: AND ail.line_type_lookup_code = 'TAX'
1522: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1523: FROM zx_lines_summary ls
1524: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1525: AND ls.trx_id = ail.invoice_id
1526: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1527: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1965: zx_lines_summary zls,

1961: prepay.pay_awt_group_id)) -- pay_awt_group_id Bug8345264 */
1962: FROM ap_invoices_all ai,
1963: ap_suppliers ap,
1964: ap_supplier_sites_all aps,
1965: zx_lines_summary zls,
1966: ap_invoice_lines_all prepay
1967: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1968: AND ai.vendor_id = ap.vendor_id
1969: AND ai.vendor_site_id = aps.vendor_site_id

Line 2129: FROM zx_lines_summary zls

2125: 0)),
2126: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2127: 'Y', NVL(zls.tax_amt, 0),
2128: 0))
2129: FROM zx_lines_summary zls
2130: WHERE zls.application_id = 200
2131: AND zls.entity_code = 'AP_INVOICES'
2132: AND zls.event_class_code IN
2133: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 10402: FROM zx_lines_summary zls

10398: AND rownum = 1; */
10399:
10400: SELECT 'Tax Only Line Exist'
10401: INTO l_dummy
10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,