APPS.OKL_CONTRACT_INFO dependencies on OKL_STRMTYP_SOURCE_V

Line 1254: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1250: WHERE org1.dnz_chr_id = p_contract_id
1251: AND org1.id = orv1.rgp_id
1252: AND orv1.rule_information_category = 'SLL'
1253: AND EXISTS
1254: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1255: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1256: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1257: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1258: AND object1_id2 = stm.id2 AND stm.name ='RENT');

Line 1268: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1264: WHERE org1.dnz_chr_id = p_contract_id
1265: AND org1.id = orv1.rgp_id
1266: AND orv1.rule_information_category = 'SLL'
1267: AND EXISTS
1268: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1269: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1270: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1271: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1272: AND object1_id2 = stm.id2 AND stm.name ='SECURITY DEPOSIT');

Line 1282: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm

1278: WHERE org1.dnz_chr_id = p_contract_id
1279: AND org1.id = orv1.rgp_id
1280: AND orv1.rule_information_category = 'SLL'
1281: AND EXISTS
1282: ( SELECT 1 FROM okc_k_headers_v okhdr,okc_rules_v orv,OKL_STRMTYP_SOURCE_V stm
1283: WHERE okhdr.id = org1.dnz_chr_id AND org1.rgd_code = 'LAEVEL'
1284: AND org1.id = orv.rgp_id AND orv.rule_information_category ='SLH'
1285: AND jtot_object1_code ='OKL_STRMTYP' AND object1_id1 = stm.id1
1286: AND object1_id2 = stm.id2 AND stm.name ='SECURITY DEPOSIT');