APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 456: From zx_party_tax_profile

452: where application_id = c_application_id
453: and entity_code = c_entity_code
454: and event_class_code = c_event_class_code
455: and first_pty_org_id = (Select party_tax_profile_id
456: From zx_party_tax_profile
457: where party_id = c_org_id
458: and party_type_code = 'OU')
459: and sysdate >= effective_from
460: and sysdate <= nvl(effective_to,sysdate)

Line 1637: FROM zx_party_tax_profile vs,

1633: CURSOR sel_site_tax_ptp
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

Line 1692: -- need to get it from zx_party_tax_profiles

1688:
1689: IF l_count = 0 THEN
1690: --
1691: -- l_tax_classification_code is no longer valid
1692: -- need to get it from zx_party_tax_profiles
1693: l_tax_classification_code := NULL;
1694: END IF;
1695: END IF;
1696:

Line 1788: FROM zx_party_tax_profile v,

1784: CURSOR sel_vendor_tax_ptp
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

Line 1842: -- need to get it from zx_party_tax_profiles

1838:
1839: IF l_count = 0 THEN
1840: --
1841: -- l_tax_classification_code is no longer valid
1842: -- need to get it from zx_party_tax_profiles
1843: l_tax_classification_code := NULL;
1844: END IF;
1845: END IF;
1846:

Line 1936: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;

1932: l_curr_calling_sequence VARCHAR2(2000);
1933: l_tax_classification_code VARCHAR2(30);
1934: l_party_type_code VARCHAR2(30);
1935: l_return_status VARCHAR2(30);
1936: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;
1937:
1938: CURSOR sel_ship_to_loc_tax
1939: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)
1940: IS

Line 1939: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)

1935: l_return_status VARCHAR2(30);
1936: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;
1937:
1938: CURSOR sel_ship_to_loc_tax
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

Line 1942: FROM zx_party_tax_profile ptp,

1938: CURSOR sel_ship_to_loc_tax
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'