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_V

Line 831: FROM okc_rule_groups_v

827:
828: CURSOR del_rgp_csr(p_chr_id OKC_K_HEADERS_V.ID%TYPE,
829: p_rgp_id NUMBER) IS
830: SELECT id
831: FROM okc_rule_groups_v
832: WHERE dnz_chr_id = p_chr_id
833: AND id = p_rgp_id
834: AND rgd_code = 'LALEVL';
835:

Line 991: FROM okc_rule_groups_v

987: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
988: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
989: SELECT id,
990: cle_id
991: FROM okc_rule_groups_v
992: WHERE dnz_chr_id = p_chr_id
993: AND cle_id = p_cle_id
994: AND rgd_code = 'LALEVL';
995:

Line 999: FROM okc_rule_groups_v

995:
996: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
997: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
998: SELECT id
999: FROM okc_rule_groups_v
1000: WHERE dnz_chr_id = p_chr_id
1001: AND rgd_code = 'LALEVL'
1002: AND (cle_id = p_cle_id
1003: OR ( cle_id IS NULL

Line 1069: FROM okc_rule_groups_v

1065:
1066: CURSOR lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1067: SELECT id,
1068: cle_id
1069: FROM okc_rule_groups_v
1070: WHERE dnz_chr_id = p_chr_id
1071: AND cle_id IS NULL -- Bug 2376998
1072: AND rgd_code = 'LALEVL';
1073:

Line 1077: FROM okc_rule_groups_v

1073:
1074: CURSOR old_lalevl_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1075: p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1076: SELECT id
1077: FROM okc_rule_groups_v
1078: WHERE dnz_chr_id = p_chr_id
1079: AND rgd_code = 'LALEVL'
1080: AND (cle_id = p_cle_id
1081: OR ( cle_id IS NULL

Line 2565: FROM okc_rule_groups_v rglease

2561:
2562: -- returns rgp id thet exist in lease as well as vp
2563: CURSOR c_prev_src_crs(p_vp_tmpl_id IN NUMBER) IS
2564: SELECT rglease.id, rglease.rgd_code
2565: FROM okc_rule_groups_v rglease
2566: WHERE dnz_chr_id = p_dest_id
2567: AND chr_id = p_dest_id
2568: AND EXISTS(
2569: SELECT '1'

Line 2570: FROM okc_rule_groups_v rg,

2566: WHERE dnz_chr_id = p_dest_id
2567: AND chr_id = p_dest_id
2568: AND EXISTS(
2569: SELECT '1'
2570: FROM okc_rule_groups_v rg,
2571: okc_k_headers_v hdr
2572: WHERE rg.chr_id = p_vp_tmpl_id
2573: AND hdr.id = rg.chr_id
2574: AND hdr.id = rg.dnz_chr_id

Line 2693: l_rgp_id okc_rule_groups_v.id%TYPE;

2689:
2690: l_api_name VARCHAR2(30) := 'COPY_RULES';
2691: l_api_version CONSTANT NUMBER := 1.0;
2692:
2693: l_rgp_id okc_rule_groups_v.id%TYPE;
2694: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2695: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2696: l_to_template_yn VARCHAR2(5) :='N';
2697: x_rgp_id okc_rule_groups_v.id%TYPE;

Line 2694: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;

2690: l_api_name VARCHAR2(30) := 'COPY_RULES';
2691: l_api_version CONSTANT NUMBER := 1.0;
2692:
2693: l_rgp_id okc_rule_groups_v.id%TYPE;
2694: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2695: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2696: l_to_template_yn VARCHAR2(5) :='N';
2697: x_rgp_id okc_rule_groups_v.id%TYPE;
2698:

Line 2695: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;

2691: l_api_version CONSTANT NUMBER := 1.0;
2692:
2693: l_rgp_id okc_rule_groups_v.id%TYPE;
2694: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2695: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2696: l_to_template_yn VARCHAR2(5) :='N';
2697: x_rgp_id okc_rule_groups_v.id%TYPE;
2698:
2699: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;

Line 2697: x_rgp_id okc_rule_groups_v.id%TYPE;

2693: l_rgp_id okc_rule_groups_v.id%TYPE;
2694: l_cle_id okc_rule_groups_v.cle_id%TYPE DEFAULT NULL;
2695: l_chr_id okc_rule_groups_v.chr_id%TYPE := p_dest_id;
2696: l_to_template_yn VARCHAR2(5) :='N';
2697: x_rgp_id okc_rule_groups_v.id%TYPE;
2698:
2699: l_func_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2700: l_k_curr_code okc_k_headers_b.currency_code%TYPE := NULL;
2701: l_start_date okc_k_headers_b.start_date%TYPE;

Line 2730: FROM okc_rule_groups_v rg,

2726:
2727: -- returns vendor program rgd codes which are qualified for lease
2728: CURSOR c_src_crs(p_vp_tmpl_id IN NUMBER) IS
2729: SELECT rg.id
2730: FROM okc_rule_groups_v rg,
2731: okc_k_headers_v hdr
2732: WHERE rg.chr_id = p_vp_tmpl_id
2733: AND hdr.id = rg.chr_id
2734: AND hdr.id = rg.dnz_chr_id

Line 2743: FROM okc_rule_groups_v rglease

2739: WHERE rgdfs.rgd_code = rg.rgd_code
2740: AND rgdfs.scs_code = 'LEASE')
2741: AND NOT EXISTS
2742: (SELECT '1'
2743: FROM okc_rule_groups_v rglease
2744: WHERE dnz_chr_id =p_dest_id
2745: AND chr_id = p_dest_id
2746: AND rglease.rgd_code = rg.rgd_code);
2747:

Line 2842: FROM okc_rule_groups_v rgpv

2838: AND rgrdfs.sre_id = sre.id;
2839:
2840: CURSOR c_vndr_blng_id_csr IS
2841: SELECT rgpv.id
2842: FROM okc_rule_groups_v rgpv
2843: WHERE rgpv.rgd_code = G_VENDOR_BILL_RGD_CODE
2844: AND rgpv.dnz_chr_id = p_source_id;
2845:
2846: CURSOR c_vp_cpl_csr IS

Line 8382: FROM okc_rule_groups_v rgp, okc_rules_v rul

8378: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8379:
8380: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8381: SELECT rgp.id, rul.id, rul.rule_information1
8382: FROM okc_rule_groups_v rgp, okc_rules_v rul
8383: WHERE rgp.id = rul.rgp_id
8384: AND rgp.rgd_code = p_rgd_code
8385: AND rul.rule_information_category = p_rule_information_category
8386: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8401: FROM okc_rule_groups_v rgp, okc_rules_v rul

8397: --end modified abhsaxen for performance SQLID 20563248
8398: ;
8399: CURSOR l_customer_account_csr IS
8400: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8401: FROM okc_rule_groups_v rgp, okc_rules_v rul
8402: WHERE rgp.id = rul.rgp_id
8403: AND rgp.rgd_code = 'LACAN'
8404: AND rul.rule_information_category = 'CAN'
8405: AND rul.dnz_chr_id = p_durv_rec.chr_id