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_DEAL_CREAT_PVT dependencies on OKC_RULE_GROUPS_B

Line 1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs

1155: AND id = p_id;
1156:
1157: CURSOR c_rgpv IS
1158: SELECT rgp.id
1159: FROM okc_rule_groups_b rgp, okc_subclass_rg_defs rg_defs
1160: WHERE rgp.dnz_chr_id = p_source_chr_id
1161: AND rgp.rgd_code = rg_defs.rgd_code
1162: AND rg_defs.scs_code = 'LEASE'
1163: AND rgp.cle_id IS NULL

Line 2709: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;

2705: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE := NULL;
2706: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE := NULL;
2707: x_converted_amount NUMBER := NULL;
2708:
2709: l_rgd_code okc_rule_groups_b.rgd_code%TYPE := NULL;
2710: l_rule_info_cat okc_rules_b.rule_information_category%TYPE := NULL;
2711: l_rule_id NUMBER := NULL;
2712: l_rule_segment VARCHAR2(250) := NULL;
2713:

Line 2770: from okc_rule_groups_b rgp, okc_rules_b rul

2766: ;
2767: CURSOR c_rule_csr (p_rgp_id IN NUMBER) IS
2768: --Start modified abhsaxen for performance SQLID 20562755
2769: select rgp.rgd_code,rul.rule_information_category,rul.id
2770: from okc_rule_groups_b rgp, okc_rules_b rul
2771: where rgp.id = rul.rgp_id
2772: and rul.dnz_chr_id = p_dest_id
2773: and rgp.id = p_rgp_id
2774: and exists (

Line 4836: FROM okc_rule_groups_b

4832: FROM okl_system_params;
4833:
4834: CURSOR c_rule_group(p_chr_id NUMBER, p_rgd_code VARCHAR2) IS
4835: SELECT id,rgd_code
4836: FROM okc_rule_groups_b
4837: WHERE dnz_chr_id = p_chr_id
4838: AND rgd_code = p_rgd_code;
4839:
4840: CURSOR c_orig_system_source(p_chr_id NUMBER) IS

Line 4849: okc_rule_groups_b rgp

4845: --Added by bkatraga for bug 9343568
4846: CURSOR c_check_rule(p_chr_id NUMBER, p_rgd_code VARCHAR2, p_rule_cat VARCHAR2) IS
4847: SELECT count(1)
4848: FROM okc_rules_b rul,
4849: okc_rule_groups_b rgp
4850: WHERE rgp.chr_id = p_chr_id
4851: AND rgp.rgd_code = p_rgd_code
4852: AND rul.rgp_id = rgp.id
4853: AND rul.RULE_INFORMATION_CATEGORY = p_rule_cat;

Line 6741: FROM okc_rule_groups_b rgp,

6737: AND CHR.id = p_durv_rec.chr_id;
6738:
6739: CURSOR get_larles_csr IS
6740: SELECT rul.rule_information1
6741: FROM okc_rule_groups_b rgp,
6742: okc_rules_b rul
6743: WHERE rgp.id = rul.rgp_id
6744: AND rgp.rgd_code = 'LARLES'
6745: AND rul.rule_information_category = 'LARLES'

Line 6766: okc_rule_groups_b rgp

6762:
6763: CURSOR get_lacpln_csr IS
6764: SELECT rul.rule_information1
6765: FROM okc_rules_b rul,
6766: okc_rule_groups_b rgp
6767: WHERE rgp.id = rul.rgp_id
6768: AND rul.rule_information_category = 'LACPLN'
6769: AND rgp.RGD_CODE = 'LACPLN'
6770: AND rul.dnz_chr_id = rgp.dnz_chr_id

Line 9458: FROM okc_rule_groups_b rgp,

9454:
9455: CURSOR c_eot(p_chr_id NUMBER) IS
9456: SELECT rul.rule_information1 eot_option_code,
9457: rul.rule_information2 eot_option_amount
9458: FROM okc_rule_groups_b rgp,
9459: okc_rules_b rul
9460: WHERE rgp.dnz_chr_id = p_chr_id
9461: AND rgp.rgd_code = 'AMTFOC'
9462: AND rgp.dnz_chr_id = rgp.dnz_chr_id