132: ,rgp.rgd_code
133: FROM okc_k_headers_b prog,
134: okc_k_headers_b lease,
135: okl_k_headers khr,
136: okc_rule_groups_b rgp
137: WHERE khr.id = lease.id
138: AND khr.khr_id = prog.id
139: AND prog.scs_code = 'PROGRAM'
140: AND lease.scs_code in ('LEASE','LOAN')
238: ,rgp.rgd_code
239: FROM okc_k_headers_b prog,
240: okc_k_headers_b lease,
241: okl_k_headers khr,
242: okc_rule_groups_b rgp
243: WHERE khr.id = lease.id
244: AND khr.khr_id = prog.id
245: AND prog.scs_code = 'PROGRAM'
246: AND lease.scs_code in ('LEASE','LOAN')
344: ,rgp.rgd_code
345: FROM okc_k_headers_b prog,
346: okc_k_headers_b lease,
347: okl_k_headers khr,
348: okc_rule_groups_b rgp
349: WHERE khr.id = lease.id
350: AND khr.khr_id = prog.id
351: AND prog.scs_code = 'PROGRAM'
352: AND lease.scs_code in ('LEASE','LOAN')
462: ,rgp.rgd_code
463: FROM okc_k_headers_b prog,
464: okc_k_headers_b lease,
465: okl_k_headers khr,
466: okc_rule_groups_b rgp
467: WHERE khr.id = lease.id
468: AND khr.khr_id = prog.id
469: AND prog.scs_code = 'PROGRAM'
470: AND lease.scs_code in ('LEASE','LOAN')