DBA Data[Home] [Help]

APPS.PA_OUTPUT_TAX dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 1750: FROM zx_output_classifications_v fnd_lk

1746: l_meaning varchar2(50);
1747: BEGIN
1748: BEGIN
1749: SELECT fnd_lk.meaning into l_meaning
1750: FROM zx_output_classifications_v fnd_lk
1751: WHERE fnd_lk.lookup_code = x_output_tax_class_code
1752: AND fnd_lk.org_id = x_org_id
1753: AND x_inv_date BETWEEN fnd_lk.start_date_active AND NVL(fnd_lk.end_date_active,x_inv_date);
1754:

Line 1760: FROM zx_output_classifications_v fnd_lk

1756:
1757: WHEN NO_DATA_FOUND THEN
1758:
1759: SELECT fnd_lk.meaning into l_meaning
1760: FROM zx_output_classifications_v fnd_lk
1761: WHERE fnd_lk.lookup_code = x_output_tax_class_code
1762: AND fnd_lk.org_id = -99
1763: AND x_inv_date BETWEEN fnd_lk.start_date_active AND NVL(fnd_lk.end_date_active,x_inv_date);
1764: