[Home] [Help]
1502: * bug#4310278 get input_tax_classification_code from
1503: * zx_lines_det_factors
1504: CURSOR sel_input_tax_cls_cd IS
1505: SELECT tc.lookup_code
1506: FROM fnd_lookups tc,
1507: po_line_locations ll
1508: WHERE ll.line_location_id = p_line_location_id
1509: AND tc.lookup_code = ll.tax_code_id -- replace with classification_code
1510: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1680: END IF;
1681:
1682: IF l_tax_classification_code IS NOT NULL THEN
1683: --
1684: -- check if tax_classification_code is valid in fnd_lookups
1685: --
1686: validate_tax_classif_code(l_tax_classification_code,
1687: l_count);
1688:
1830: END IF;
1831:
1832: IF l_tax_classification_code IS NOT NULL THEN
1833: --
1834: -- check if tax_classification_code is valid in fnd_lookups
1835: --
1836: validate_tax_classif_code(l_tax_classification_code,
1837: l_count);
1838:
2142: l_tax_classification_code VARCHAR2(30);
2143:
2144: CURSOR sel_item_tax IS
2145: SELECT si.purchasing_tax_code
2146: FROM fnd_lookups tc,
2147: mtl_system_items si
2148: WHERE si.inventory_item_id = p_item_id
2149: AND si.organization_id = nvl(p_ship_to_loc_org_id, p_item_org_id)
2150: AND tc.lookup_code = si.purchasing_tax_code
3061: CURSOR chk_tax_classification_code
3062: (c_tax_classification_code VARCHAR2)
3063: IS
3064: SELECT count(1)
3065: FROM fnd_lookups
3066: WHERE lookup_code = c_tax_classification_code
3067: AND lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
3068: AND nvl(enabled_flag,'Y') = 'Y';
3069: