APPS.OKL_TXS_PVT dependencies on HZ_PARTY_SITES

Line 1893: FROM hz_party_sites

1889: l_dummy_var VARCHAR2(1) := '?' ;
1890:
1891: CURSOR okl_txsv_ship_to_locn_fk_csr (p_id IN NUMBER) IS
1892: SELECT 'x'
1893: FROM hz_party_sites
1894: WHERE location_id = p_id;
1895: BEGIN
1896:
1897: IF (p_txsv_rec.ship_to_location_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.ship_to_location_id IS NOT NULL)

Line 1913: 'hz_party_sites');

1909: 'ship_to_location_id',
1910: g_child_table_token ,
1911: 'OKL_TAX_SOURCES_V',
1912: g_parent_table_token ,
1913: 'hz_party_sites');
1914: l_return_status := OKC_API.G_RET_STS_ERROR;
1915:
1916: END IF;
1917:

Line 1943: FROM hz_party_sites

1939: l_dummy_var VARCHAR2(1) := '?' ;
1940:
1941: CURSOR okl_txsv_ship_to_ps_fk_csr (p_id IN NUMBER) IS
1942: SELECT 'x'
1943: FROM hz_party_sites
1944: WHERE party_site_id = p_id;
1945: BEGIN
1946:
1947: IF (p_txsv_rec.ship_to_party_site_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.ship_to_party_site_id IS NOT NULL)

Line 1963: 'hz_party_sites');

1959: 'ship_to_party_site_id',
1960: g_child_table_token ,
1961: 'OKL_TAX_SOURCES_V',
1962: g_parent_table_token ,
1963: 'hz_party_sites');
1964: l_return_status := OKC_API.G_RET_STS_ERROR;
1965:
1966: END IF;
1967:

Line 1993: FROM hz_party_sites

1989: l_dummy_var VARCHAR2(1) := '?' ;
1990:
1991: CURSOR okl_txsv_ship_to_pid_fk_csr (p_id IN NUMBER) IS
1992: SELECT 'x'
1993: FROM hz_party_sites
1994: WHERE party_id = p_id;
1995: BEGIN
1996:
1997: IF (p_txsv_rec.ship_to_party_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.ship_to_party_id IS NOT NULL)

Line 2013: 'hz_party_sites');

2009: 'ship_to_party_id',
2010: g_child_table_token ,
2011: 'OKL_TAX_SOURCES_V',
2012: g_parent_table_token ,
2013: 'hz_party_sites');
2014: l_return_status := OKC_API.G_RET_STS_ERROR;
2015:
2016: END IF;
2017:

Line 2044: FROM hz_party_sites

2040: l_dummy_var VARCHAR2(1) := '?' ;
2041:
2042: CURSOR okl_txsv_bill_to_ps_fk_csr (p_id IN NUMBER) IS
2043: SELECT 'x'
2044: FROM hz_party_sites
2045: WHERE party_site_id = p_id;
2046: BEGIN
2047:
2048: IF (p_txsv_rec.bill_to_party_site_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.bill_to_party_site_id IS NOT NULL)

Line 2064: 'hz_party_sites');

2060: 'bill_to_party_site_id',
2061: g_child_table_token ,
2062: 'OKL_TAX_SOURCES_V',
2063: g_parent_table_token ,
2064: 'hz_party_sites');
2065: l_return_status := OKC_API.G_RET_STS_ERROR;
2066:
2067: END IF;
2068:

Line 2095: FROM hz_party_sites

2091: l_dummy_var VARCHAR2(1) := '?' ;
2092:
2093: CURSOR okl_txsv_bill_to_loc_fk_csr (p_id IN NUMBER) IS
2094: SELECT 'x'
2095: FROM hz_party_sites
2096: WHERE location_id = p_id;
2097: BEGIN
2098:
2099: IF (p_txsv_rec.bill_to_location_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.bill_to_location_id IS NOT NULL)

Line 2115: 'hz_party_sites');

2111: 'bill_to_location_id',
2112: g_child_table_token ,
2113: 'OKL_TAX_SOURCES_V',
2114: g_parent_table_token ,
2115: 'hz_party_sites');
2116: l_return_status := OKC_API.G_RET_STS_ERROR;
2117:
2118: END IF;
2119:

Line 2146: FROM hz_party_sites

2142: l_dummy_var VARCHAR2(1) := '?' ;
2143:
2144: CURSOR okl_txsv_bill_to_pid_fk_csr (p_id IN NUMBER) IS
2145: SELECT 'x'
2146: FROM hz_party_sites
2147: WHERE party_id = p_id;
2148: BEGIN
2149:
2150: IF (p_txsv_rec.bill_to_party_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.bill_to_party_id IS NOT NULL)

Line 2166: 'hz_party_sites');

2162: 'bill_to_party_id',
2163: g_child_table_token ,
2164: 'OKL_TAX_SOURCES_V',
2165: g_parent_table_token ,
2166: 'hz_party_sites');
2167: l_return_status := OKC_API.G_RET_STS_ERROR;
2168:
2169: END IF;
2170: