[Home] [Help]
1634: (c_party_site_id NUMBER)
1635: IS
1636: SELECT vs.tax_classification_code
1637: FROM zx_party_tax_profile vs,
1638: zx_input_classifications_v tc
1639: WHERE vs.party_id = c_party_site_id
1640: AND vs.party_type_code = 'THIRD_PARTY_SITE'
1641: AND vs.tax_classification_code = tc.lookup_code
1642: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1785: (c_party_id NUMBER)
1786: IS
1787: SELECT v.tax_classification_code
1788: FROM zx_party_tax_profile v,
1789: zx_input_classifications_v tc
1790: WHERE v.party_id = c_party_id
1791: AND v.party_type_code = 'THIRD_PARTY'
1792: AND v.tax_classification_code = tc.lookup_code
1793: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1939: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)
1940: IS
1941: SELECT ptp.tax_classification_code
1942: FROM zx_party_tax_profile ptp,
1943: zx_input_classifications_v tc
1944: WHERE ptp.party_tax_profile_id = c_ptp_id
1945: AND ptp.tax_classification_code = tc.lookup_code
1946: AND tc.lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
1947: AND nvl(tc.enabled_flag,'Y') = 'Y'
1951: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1952: IS
1953: SELECT hr.tax_name
1954: FROM hr_locations_all hr,
1955: zx_input_classifications_v tc
1956: WHERE hr.location_id = c_ship_to_loc_id
1957: AND hr.tax_name = tc.lookup_code
1958: AND tc.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
1959: AND nvl(tc.enabled_flag,'Y') = 'Y'
2393: statement := 'SELECT toa.allow_tax_code_override_flag, ' ||
2394: 'toa.tax_classification_code, ' ||
2395: 'toa.tax_class ' ||
2396: 'FROM zx_acct_tx_cls_defs_all toa, ' ||
2397: 'zx_input_classifications_v tc ' ||
2398: 'WHERE toa.account_segment_value = :l_account_seg_value ' ||
2399: 'AND (toa.org_id = :l_bind_org_id or toa.org_id = -1)' ||
2400: 'AND toa.tax_class = ''I'' ' ||
2401: 'AND tc.lookup_code = toa.tax_classification_code ' ||