APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 462: From zx_party_tax_profile

458: where application_id = c_application_id
459: and entity_code = c_entity_code
460: and event_class_code = c_event_class_code
461: and first_pty_org_id = (Select party_tax_profile_id
462: From zx_party_tax_profile
463: where party_id = c_org_id
464: and party_type_code = 'OU')
465: and sysdate >= effective_from
466: and sysdate <= nvl(effective_to,sysdate)

Line 1649: FROM zx_party_tax_profile vs,

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

Line 1704: -- need to get it from zx_party_tax_profiles

1700:
1701: IF l_count = 0 THEN
1702: --
1703: -- l_tax_classification_code is no longer valid
1704: -- need to get it from zx_party_tax_profiles
1705: l_tax_classification_code := NULL;
1706: END IF;
1707: END IF;
1708:

Line 1800: FROM zx_party_tax_profile v,

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

Line 1854: -- need to get it from zx_party_tax_profiles

1850:
1851: IF l_count = 0 THEN
1852: --
1853: -- l_tax_classification_code is no longer valid
1854: -- need to get it from zx_party_tax_profiles
1855: l_tax_classification_code := NULL;
1856: END IF;
1857: END IF;
1858:

Line 1948: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;

1944: l_curr_calling_sequence VARCHAR2(2000);
1945: l_tax_classification_code VARCHAR2(30);
1946: l_party_type_code VARCHAR2(30);
1947: l_return_status VARCHAR2(30);
1948: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;
1949:
1950: CURSOR sel_ship_to_loc_tax
1951: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)
1952: IS

Line 1951: (c_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE)

1947: l_return_status VARCHAR2(30);
1948: l_ptp_id ZX_PARTY_TAX_PROFILE.party_tax_profile_id%TYPE;
1949:
1950: CURSOR sel_ship_to_loc_tax
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

Line 1954: FROM zx_party_tax_profile ptp,

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

Line 2185: From zx_party_tax_profile

2181: where application_id = c_application_id
2182: and entity_code = c_entity_code
2183: and event_class_code = c_event_class_code
2184: and first_pty_org_id = (Select party_tax_profile_id
2185: From zx_party_tax_profile
2186: where party_id = c_org_id
2187: and party_type_code = 'OU')
2188: and sysdate >= effective_from
2189: and sysdate <= nvl(effective_to,sysdate)