[Home] [Help]
1646: (c_party_site_id NUMBER)
1647: IS
1648: SELECT vs.tax_classification_code
1649: FROM zx_party_tax_profile vs,
1650: zx_input_classifications_v tc
1651: WHERE vs.party_id = c_party_site_id
1652: AND vs.party_type_code = 'THIRD_PARTY_SITE'
1653: AND vs.tax_classification_code = tc.lookup_code
1654: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1797: (c_party_id NUMBER)
1798: IS
1799: SELECT v.tax_classification_code
1800: FROM zx_party_tax_profile v,
1801: zx_input_classifications_v tc
1802: WHERE v.party_id = c_party_id
1803: AND v.party_type_code = 'THIRD_PARTY'
1804: AND v.tax_classification_code = tc.lookup_code
1805: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1951: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)
1952: IS
1953: SELECT ptp.tax_classification_code
1954: FROM zx_party_tax_profile ptp,
1955: zx_input_classifications_v tc
1956: WHERE ptp.party_tax_profile_id = c_ptp_id
1957: AND ptp.tax_classification_code = tc.lookup_code
1958: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1959: AND nvl(tc.enabled_flag,'Y') = 'Y'
1963: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1964: IS
1965: SELECT hr.tax_name
1966: FROM hr_locations_all hr,
1967: zx_input_classifications_v tc
1968: WHERE hr.location_id = c_ship_to_loc_id
1969: AND hr.tax_name = tc.lookup_code
1970: AND tc.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
1971: AND nvl(tc.enabled_flag,'Y') = 'Y'
2985: statement := 'SELECT toa.allow_tax_code_override_flag, ' ||
2986: 'toa.tax_classification_code, ' ||
2987: 'toa.tax_class ' ||
2988: 'FROM zx_acct_tx_cls_defs_all toa, ' ||
2989: 'zx_input_classifications_v tc ' ||
2990: 'WHERE toa.account_segment_value = :l_account_seg_value ' ||
2991: 'AND toa.ledger_id = :l_bind_set_of_books_id ' || -- Bug 8353620
2992: 'AND (toa.org_id = :l_bind_org_id or toa.org_id = -1)' ||
2993: 'AND toa.tax_class = ''INPUT'' ' ||