APPS.OKC_TERMINATE_PVT dependencies on OKC_CONDITION_HEADERS_B

Line 606: FROM okc_condition_headers_b

602: */
603:
604: CURSOR cur_condition_headers is
605: SELECT id,object_version_number,date_active,date_inactive
606: FROM okc_condition_headers_b
607: WHERE dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
608: and ( date_inactive > p_terminate_in_parameters_rec.p_termination_date
609: or date_inactive is null )
610: FOR update of date_inactive nowait;

Line 630: FROM okc_condition_headers_b cnh,

626: -- CURSOR for bug 1982629, TERMINATION OF AN EXPIRED CONTRACT
627: CURSOR c_get_terminate_date (b_cnh_id NUMBER) IS
628: SELECT greatest(nvl(co.datetime, cnh.date_active),
629: p_terminate_in_parameters_rec.p_termination_date )
630: FROM okc_condition_headers_b cnh,
631: okc_condition_occurs co
632: WHERE dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
633: AND cnh.id = b_cnh_id
634: AND cnh.id = co.cnh_id (+);