DBA Data[Home] [Help]

APPS.OZF_CLAIM_TAX_PVT dependencies on ZX_DETAIL_TAX_LINES_GT

Line 182: FROM zx_detail_tax_lines_gt

178: p_entity_code IN VARCHAR2, p_event_class_code IN VARCHAR2,
179: p_claim_id IN NUMBER, p_claim_line_id IN NUMBER) IS
180: SELECT SUM(DECODE(tax_amt_included_flag, 'Y',0, tax_amt_tax_curr)),
181: SUM(DECODE(tax_amt_included_flag, 'Y',0, tax_amt_funcl_curr))
182: FROM zx_detail_tax_lines_gt
183: WHERE internal_organization_id = p_org_id
184: AND application_id = p_application_id
185: AND entity_code = p_entity_code
186: AND event_class_code = p_event_class_code