APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_TXL_ASSETS_B

Line 762: l_query_string := l_query_string || ' SELECT l.dnz_khr_id FROM OKL_TRX_ASSETS h, okl_txl_assets_b l '

758: || ' AND trq.tcn_id IS NULL AND trq.org_id = ' || p_org_id;
759: ELSIF p_in_transit_category = 'RESIDUAL'
760: THEN
761: -- Residual Value Writedown not Processed
762: l_query_string := l_query_string || ' SELECT l.dnz_khr_id FROM OKL_TRX_ASSETS h, okl_txl_assets_b l '
763: || ' WHERE h.id = l.tas_id AND h.tsu_code IN (''ENTERED'',''ERROR'') AND h.tas_type = ''ARC'' ';
764: ELSIF p_in_transit_category = 'TERMINATION'
765: THEN
766: -- Termination Quote Not Accepted

Line 887: okl_txl_assets_b l

883: AND opp.khr_id IN
884: (
885: SELECT l.dnz_khr_id
886: FROM OKL_TRX_ASSETS h,
887: okl_txl_assets_b l
888: WHERE h.id = l.tas_id
889: AND h.tsu_code IN ('ENTERED','ERROR')
890: AND h.tas_type = 'ARC'
891: );