eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SECURITIZATION_PVT dependencies on OKC_RULES_B

Line 1150: ,x_inv_acct_code OUT NOCOPY okc_rules_b.RULE_INFORMATION1%TYPE

1146: ,p_khr_id IN NUMBER
1147: ,p_scs_code IN okc_k_headers_b.scs_code%TYPE DEFAULT NULL
1148: ,p_trx_date IN DATE
1149: ,x_fact_synd_code OUT NOCOPY fnd_lookups.lookup_code%TYPE
1150: ,x_inv_acct_code OUT NOCOPY okc_rules_b.RULE_INFORMATION1%TYPE
1151: )
1152: IS
1153: l_api_name CONSTANT VARCHAR2(30) := 'check_khr_ia_associated';
1154: l_api_version CONSTANT NUMBER := 1.0;

Line 1161: FROM okc_rules_b

1157: l_trx_date DATE; -- cklee fixed bug: 7017824(R12)/OKL.H bug#6964174
1158:
1159: CURSOR investor_code (p_ia_chr_id IN NUMBER) IS
1160: SELECT rule_information1
1161: FROM okc_rules_b
1162: WHERE dnz_chr_id = p_ia_chr_id
1163: AND RULE_INFORMATION_CATEGORY='LASEAC';
1164: l_investor_code okc_rules_b.rule_information1%TYPE;
1165:

Line 1164: l_investor_code okc_rules_b.rule_information1%TYPE;

1160: SELECT rule_information1
1161: FROM okc_rules_b
1162: WHERE dnz_chr_id = p_ia_chr_id
1163: AND RULE_INFORMATION_CATEGORY='LASEAC';
1164: l_investor_code okc_rules_b.rule_information1%TYPE;
1165:
1166: CURSOR fact_synd_code IS
1167: SELECT lookup_code
1168: FROM fnd_lookups

Line 1447: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

1443: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1444: l_action NUMBER;
1445:
1446: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1447: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1448: p_khr_id okc_k_headers_b.id%TYPE) IS
1449: SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
1450: G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
1451: G_PRIORITY_2))

Line 1453: okc_rules_b rg

1449: SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
1450: G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
1451: G_PRIORITY_2))
1452: FROM okc_rule_groups_b rgd,
1453: okc_rules_b rg
1454: WHERE rgd.id = rg.rgp_id
1455: AND rgd.rgd_code = p_rgd_code
1456: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1457: AND EXISTS -- investor agreement Ids

Line 1470: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

1466: ;
1467:
1468:
1469: CURSOR c_inv_khr(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1470: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1471: p_khr_id okc_k_headers_b.id%TYPE) IS
1472: SELECT rgd.dnz_chr_id,
1473: rg.RULE_INFORMATION1
1474: FROM okc_rule_groups_b rgd,

Line 1475: okc_rules_b rg

1471: p_khr_id okc_k_headers_b.id%TYPE) IS
1472: SELECT rgd.dnz_chr_id,
1473: rg.RULE_INFORMATION1
1474: FROM okc_rule_groups_b rgd,
1475: okc_rules_b rg
1476: WHERE rgd.id = rg.rgp_id
1477: AND rgd.rgd_code = p_rgd_code
1478: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1479: AND EXISTS -- investor agreement Ids

Line 1656: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

1652: l_flag VARCHAR2(1) := Okl_Api.G_FALSE;
1653: l_action NUMBER;
1654:
1655: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1656: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1657: p_kle_id okc_k_lines_b.id%TYPE) IS
1658: SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
1659: G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
1660: G_PRIORITY_2))

Line 1662: okc_rules_b rg

1658: SELECT MIN(DECODE(rg.RULE_INFORMATION1, G_PROCESS_AUTO_BACK_BACK, G_PRIORITY_2,
1659: G_PROCESS_NOT_ALLOWED, G_PRIORITY_1,
1660: G_PRIORITY_2))
1661: FROM okc_rule_groups_b rgd,
1662: okc_rules_b rg
1663: WHERE rgd.id = rg.rgp_id
1664: AND rgd.rgd_code = p_rgd_code
1665: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1666: AND EXISTS -- investor agreement Ids

Line 1678: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,

1674: ;
1675:
1676:
1677: CURSOR c_inv_khr(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,
1678: p_rdf_code okc_rules_b.RULE_INFORMATION_CATEGORY%TYPE,
1679:
1680: p_kle_id okc_k_lines_b.id%TYPE) IS
1681: SELECT rgd.dnz_chr_id,
1682: rg.RULE_INFORMATION1

Line 1684: okc_rules_b rg

1680: p_kle_id okc_k_lines_b.id%TYPE) IS
1681: SELECT rgd.dnz_chr_id,
1682: rg.RULE_INFORMATION1
1683: FROM okc_rule_groups_b rgd,
1684: okc_rules_b rg
1685: WHERE rgd.id = rg.rgp_id
1686: AND rgd.rgd_code = p_rgd_code
1687: AND rg.RULE_INFORMATION_CATEGORY = p_rdf_code -- 'LASEPR'
1688:

Line 1955: ,okc_rules_b rulb

1951: ,pocb.kle_id kle_id -- Asset
1952: ,pocb.sty_id sty_id -- Stream Type
1953: FROM okl_pool_contents pocb
1954: ,okl_pools polb
1955: ,okc_rules_b rulb
1956: ,okc_rule_groups_v rgpb
1957: WHERE pocb.id = p_poc_id
1958: AND pocb.pol_id = polb.id
1959: AND polb.khr_id = rulb.dnz_chr_id

Line 2078: ,okc_rules_b rulb

2074: SELECT rulb.rule_information1 formula
2075: FROM --okl_pool_contents pocb --changed by abhsaxen for Bug#6174484
2076: --,
2077: okl_pools polb
2078: ,okc_rules_b rulb
2079: ,okc_rule_groups_v rgpb
2080: WHERE polb.id = p_pol_id
2081: AND polb.khr_id = rulb.dnz_chr_id
2082: AND rgpb.rgd_code = 'LASEBB'