APPS.OKL_PRB_UPGRADE_PVT dependencies on OKL_RBK_SELECTED_CONTRACT

Line 749: l_query_string := l_query_string || ' SELECT rsc.khr_id orig_contract_id FROM okl_rbk_selected_contract rsc, okc_k_headers_b chrb '

745: || ' AND trx.tcn_type = ''TRBK'' AND trx.representation_type = ''PRIMARY'' ';
746: ELSIF p_in_transit_category = 'ONLINE_MASS_RBK'
747: THEN
748: -- Online Mass Rebook Not Processed
749: l_query_string := l_query_string || ' SELECT rsc.khr_id orig_contract_id FROM okl_rbk_selected_contract rsc, okc_k_headers_b chrb '
750: || ' WHERE rsc.transaction_id IS NULL AND rsc.status <> ''PROCESSED'' AND chrb.id = rsc.khr_id ';
751: ELSIF p_in_transit_category = 'PAYDOWN'
752: THEN
753: -- Paydown Not Accepted

Line 846: FROM okl_rbk_selected_contract rsc

842: AND opp.assigned_process = TO_CHAR(l_seq_next)
843: AND opp.khr_id IN
844: (
845: SELECT rsc.khr_id orig_contract_id
846: FROM okl_rbk_selected_contract rsc
847: WHERE opp.khr_id = rsc.khr_id
848: AND rsc.transaction_id IS NULL
849: AND rsc.status <> 'PROCESSED'
850: );

Line 985: FROM okl_rbk_selected_contract rbk_khr

981: AND ktrx.rbr_code IS NOT NULL
982: AND ktrx.tcn_type = 'TRBK'
983: AND ktrx.representation_type = 'PRIMARY'
984: AND EXISTS (SELECT '1'
985: FROM okl_rbk_selected_contract rbk_khr
986: WHERE rbk_khr.khr_id = ktrx.khr_id
987: AND rbk_khr.status <> 'PROCESSED')
988: );
989: