DBA Data[Home] [Help]

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 117: FROM zx_output_classifications_v l,

113: c_org_id NUMBER) IS
114: SELECT p.output_tax_code,
115: p.retention_tax_code
116: -- FROM fnd_lookups l, pa_projects p bug#4574838
117: FROM zx_output_classifications_v l,
118: pa_projects p
119: WHERE p.project_id = c_project_id
120: AND l.lookup_code = decode(c_retention_flag,'TRUE',p.retention_tax_code,p.output_tax_code)
121: AND l.org_id IN (c_org_id, -99)

Line 236: FROM zx_output_classifications_v l,

232: (c_expenditure_item_id NUMBER,
233: c_org_id NUMBER,
234: c_trx_date DATE) IS
235: SELECT l.lookup_code
236: FROM zx_output_classifications_v l,
237: -- fnd_lookups l, bug#4574838
238: pa_expenditure_type_ous_all type,
239: pa_expenditure_items_all item
240: WHERE item.expenditure_item_id = c_expenditure_item_id

Line 960: from zx_output_classifications_v

956: cursor c_chk_tax_classif_code( c_tax_code in VARCHAR2,
957: c_org_id in NUMBER,
958: c_trx_date DATE) is
959: select lookup_code
960: from zx_output_classifications_v
961: where lookup_code = c_tax_code
962: AND org_id IN (c_org_id, -99)
963: AND enabled_flag = 'Y'
964: AND (start_date_active <= c_trx_date OR

Line 1534: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l

1530: c_org_id NUMBER,
1531: c_trx_date date)
1532: IS
1533: SELECT su.tax_code
1534: FROM HZ_CUST_SITE_USES_ALL su, ZX_OUTPUT_CLASSIFICATIONS_V l
1535: WHERE su.site_use_id = c_site_use_id
1536: AND su.org_id = c_org_id
1537: AND l.lookup_code = su.tax_code
1538: AND l.org_id IN (c_org_id, -99)

Line 1667: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l

1663: c_org_id NUMBER,
1664: c_trx_date DATE)
1665: IS
1666: SELECT c.tax_code
1667: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l
1668: WHERE c.cust_account_id = c_customer_id
1669: AND c.org_id = c_org_id
1670: AND l.lookup_code = c.tax_code
1671: AND l.org_id IN (c_org_id, -99)

Line 1797: FROM zx_output_classifications_v l, AR_MEMO_LINES m

1793: c_org_id NUMBER)
1794: IS
1795: SELECT m.tax_code
1796: -- FROM fnd_lookups l, AR_MEMO_LINES M bug#4574838
1797: FROM zx_output_classifications_v l, AR_MEMO_LINES m
1798: WHERE m.memo_line_id = c_memo_line_id
1799: AND l.lookup_code = m.tax_code
1800: AND l.org_id IN (c_org_id, -99)
1801: AND l.enabled_flag = 'Y'

Line 1818: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i

1814: c_org_id NUMBER)
1815: IS
1816: SELECT i.tax_code
1817: -- FROM fnd_lookups l, MTL_SYSTEM_ITEMS bug#4574838
1818: FROM zx_output_classifications_v l, MTL_SYSTEM_ITEMS i
1819: WHERE i.inventory_item_id = c_item_id
1820: AND i.organization_id = c_organization_id
1821: AND l.lookup_code = i.tax_code
1822: AND l.org_id IN (c_org_id, -99)