[Home] [Help]
1514: * bug#4310278 get input_tax_classification_code from
1515: * zx_lines_det_factors
1516: CURSOR sel_input_tax_cls_cd IS
1517: SELECT tc.lookup_code
1518: FROM fnd_lookups tc,
1519: po_line_locations ll
1520: WHERE ll.line_location_id = p_line_location_id
1521: AND tc.lookup_code = ll.tax_code_id -- replace with classification_code
1522: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1692: END IF;
1693:
1694: IF l_tax_classification_code IS NOT NULL THEN
1695: --
1696: -- check if tax_classification_code is valid in fnd_lookups
1697: --
1698: validate_tax_classif_code(l_tax_classification_code,
1699: l_count);
1700:
1842: END IF;
1843:
1844: IF l_tax_classification_code IS NOT NULL THEN
1845: --
1846: -- check if tax_classification_code is valid in fnd_lookups
1847: --
1848: validate_tax_classif_code(l_tax_classification_code,
1849: l_count);
1850:
2734: l_tax_classification_code VARCHAR2(30);
2735:
2736: CURSOR sel_item_tax IS
2737: SELECT si.purchasing_tax_code
2738: FROM fnd_lookups tc,
2739: mtl_system_items si
2740: WHERE si.inventory_item_id = p_item_id
2741: AND si.organization_id = nvl(p_ship_to_loc_org_id, p_item_org_id)
2742: AND tc.lookup_code = si.purchasing_tax_code
3655: CURSOR chk_tax_classification_code
3656: (c_tax_classification_code VARCHAR2)
3657: IS
3658: SELECT count(1)
3659: FROM fnd_lookups
3660: WHERE lookup_code = c_tax_classification_code
3661: AND lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
3662: AND nvl(enabled_flag,'Y') = 'Y';
3663: