APPS.OKL_PRB_UPGRADE_PVT dependencies on OKC_K_HEADERS_B

Line 444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id

440: ,DECODE(p_criteria_set, 'CONTRACT', 'Contract - Criteria', 'REAMORT', 'Reamort', 'Revision - Criteria' ) criteria_set
441: ,( SELECT DISTINCT legal_entity_name from XLE_LE_OU_LEDGER_V
442: WHERE legal_entity_id = p_le_id
443: AND rownum <= 1 ) le_id
444: ,( SELECT contract_number FROM OKC_K_HEADERS_B WHERE id = p_khr_id ) khr_id
445: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING( 'OKL_BOOK_CLASS',p_book_classification) book_classification
446: ,( SELECT name from okl_products where id = p_pdt_id ) pdt_id
447: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_INTEREST_CALCULATION_BASIS',p_int_calc_method) int_calc_method
448: ,OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_REVENUE_RECOGNITION_METHOD',p_rev_rec_method) rev_rec_method

Line 472: FROM okc_k_headers_b chr -- Org Specific

468: 'PROCESSING_FAILED', 1,
469: 'PROCESS_ABORTED', 2,
470: 'TIME_OUT', 3,
471: 'SERVER_NA', 4, 100) pricing_error_level
472: FROM okc_k_headers_b chr -- Org Specific
473: ,okl_k_headers khr
474: ,okl_products pdt
475: ,okl_ae_tmpt_sets_all aes
476: ,okl_st_gen_tmpt_sets_all gts

Line 656: ' FROM okc_k_headers_b chr, okl_k_headers khr, okc_k_lines_b cle ' ||

652: ' ,''PENDING_ASSIGNMENT'' ' || -- PROCESS_STATUS
653: ' ,SYSDATE ' || -- CREATION_DATE
654: ' ,chr.id ' || -- KHR_ID
655: ' ,COUNT(cle.id) ' || -- VOLUME = Number of Assets
656: ' FROM okc_k_headers_b chr, okl_k_headers khr, okc_k_lines_b cle ' ||
657: ' ,okl_products pdt ,okl_ae_tmpt_sets aes , okl_st_gen_tmpt_sets gts ' ;
658: -- Appending the Where Caluse including the Mandatory Predicates
659: l_query_string := l_query_string
660: || ' WHERE chr.id = khr.id AND chr.id = cle.dnz_chr_id AND cle.lse_id = 33 ' -- FREE_FORM1 for Assets

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