APPS.OKL_STRY_CALL_CO_PUB dependencies on OKL_K_HEADERS

Line 199: okl_k_headers khr,

195: ,lease.contract_number contract_number
196: ,rgp.rgd_code
197: FROM okc_k_headers_b prog,
198: okc_k_headers_b lease,
199: okl_k_headers khr,
200: okc_rule_groups_b rgp
201: WHERE khr.id = lease.id
202: AND khr.khr_id = prog.id
203: AND prog.scs_code = 'PROGRAM'

Line 605: okl_k_headers khr,

601: ,lease.contract_number contract_number
602: ,rgp.rgd_code
603: FROM okc_k_headers_b prog,
604: okc_k_headers_b lease,
605: okl_k_headers khr,
606: okc_rule_groups_b rgp
607: WHERE khr.id = lease.id
608: AND khr.khr_id = prog.id
609: AND prog.scs_code = 'PROGRAM'

Line 721: okl_k_headers khr,

717: ,lease.contract_number contract_number
718: ,rgp.rgd_code
719: FROM okc_k_headers_b prog,
720: okc_k_headers_b lease,
721: okl_k_headers khr,
722: okc_rule_groups_b rgp
723: WHERE khr.id = lease.id
724: AND khr.khr_id = prog.id
725: AND prog.scs_code = 'PROGRAM'

Line 829: okl_k_headers khr,

825: ,lease.contract_number contract_number
826: ,rgp.rgd_code
827: FROM okc_k_headers_b prog,
828: okc_k_headers_b lease,
829: okl_k_headers khr,
830: okc_rule_groups_b rgp
831: WHERE khr.id = lease.id
832: AND khr.khr_id = prog.id
833: AND prog.scs_code = 'PROGRAM'

Line 961: okl_k_headers khr,

957: ,lease.contract_number contract_number
958: ,rgp.rgd_code
959: FROM okc_k_headers_b prog,
960: okc_k_headers_b lease,
961: okl_k_headers khr,
962: okc_rule_groups_b rgp
963: WHERE khr.id = lease.id
964: AND khr.khr_id = prog.id
965: AND prog.scs_code = 'PROGRAM'

Line 1058: okl_k_headers khr,

1054: ,lease.contract_number contract_number
1055: ,rgp.rgd_code
1056: FROM okc_k_headers_b prog,
1057: okc_k_headers_b lease,
1058: okl_k_headers khr,
1059: okc_rule_groups_b rgp
1060: WHERE khr.id = lease.id
1061: AND khr.khr_id = prog.id
1062: AND prog.scs_code = 'PROGRAM'

Line 1151: okl_k_headers khr,

1147: ,lease.contract_number contract_number
1148: ,rgp.rgd_code
1149: FROM okc_k_headers_b prog,
1150: okc_k_headers_b lease,
1151: okl_k_headers khr,
1152: okc_rule_groups_b rgp
1153: WHERE khr.id = lease.id
1154: AND khr.khr_id = prog.id
1155: AND prog.scs_code = 'PROGRAM'

Line 1246: okl_k_headers khr,

1242: ,lease.contract_number contract_number
1243: ,rgp.rgd_code
1244: FROM okc_k_headers_b prog,
1245: okc_k_headers_b lease,
1246: okl_k_headers khr,
1247: okc_rule_groups_b rgp
1248: WHERE khr.id = lease.id
1249: AND khr.khr_id = prog.id
1250: AND prog.scs_code = 'PROGRAM'

Line 1351: okl_k_headers khr,

1347: ,lease.contract_number contract_number
1348: ,rgp.rgd_code
1349: FROM okc_k_headers_b prog,
1350: okc_k_headers_b lease,
1351: okl_k_headers khr,
1352: okc_rule_groups_b rgp
1353: WHERE khr.id = lease.id
1354: AND khr.khr_id = prog.id
1355: AND prog.scs_code = 'PROGRAM'