APPS.OKL_SECURITIZATION_PVT dependencies on OKC_RULE_GROUPS_B

Line 1446: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,

1442:
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,

Line 1452: FROM okc_rule_groups_b rgd,

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))
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'

Line 1469: CURSOR c_inv_khr(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,

1465: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
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

Line 1474: FROM okc_rule_groups_b rgd,

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,
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'

Line 1655: CURSOR c_action(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,

1651:
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,

Line 1661: FROM okc_rule_groups_b rgd,

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))
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'

Line 1677: CURSOR c_inv_khr(p_rgd_code okc_rule_groups_b.rgd_code%TYPE,

1673: AND ph.khr_id = rg.dnz_chr_id) -- investor agreement contarct id
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,

Line 1683: FROM okc_rule_groups_b rgd,

1679:
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'