DBA Data[Home] [Help]

APPS.OKL_TXS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 2196: FROM hz_cust_site_uses_all

2192: l_dummy_var VARCHAR2(1) := '?' ;
2193:
2194: CURSOR okl_txsv_ship_to_cs_fk_csr (p_id IN NUMBER) IS
2195: SELECT 'x'
2196: FROM hz_cust_site_uses_all
2197: WHERE site_use_id = p_id;
2198: BEGIN
2199:
2200: IF (p_txsv_rec.ship_to_cust_acct_site_use_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.ship_to_cust_acct_site_use_id IS NOT NULL)

Line 2216: 'hz_cust_site_uses_all');

2212: 'ship_to_cust_acct_site_use_id',
2213: g_child_table_token ,
2214: 'OKL_TAX_SOURCES_V',
2215: g_parent_table_token ,
2216: 'hz_cust_site_uses_all');
2217: l_return_status := OKC_API.G_RET_STS_ERROR;
2218:
2219: END IF;
2220:

Line 2247: FROM hz_cust_site_uses_all

2243: l_dummy_var VARCHAR2(1) := '?' ;
2244:
2245: CURSOR okl_txsv_bill_to_cs_fk_csr (p_id IN NUMBER) IS
2246: SELECT 'x'
2247: FROM hz_cust_site_uses_all
2248: WHERE site_use_id = p_id;
2249: BEGIN
2250:
2251: IF (p_txsv_rec.bill_to_cust_acct_site_use_id <> OKL_API.G_MISS_NUM AND p_txsv_rec.bill_to_cust_acct_site_use_id IS NOT NULL)

Line 2267: 'hz_cust_site_uses_all');

2263: 'ship_to_cust_acct_site_use_id',
2264: g_child_table_token ,
2265: 'OKL_TAX_SOURCES_V',
2266: g_parent_table_token ,
2267: 'hz_cust_site_uses_all');
2268: l_return_status := OKC_API.G_RET_STS_ERROR;
2269:
2270: END IF;
2271: