DBA Data[Home] [Help]

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 2562: FROM okc_rule_groups_v rglease

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

Line 2567: FROM okc_rule_groups_v rg,

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

Line 2690: l_rgp_id okc_rule_groups_v.id%TYPE;

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

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

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

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

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

Line 2694: x_rgp_id okc_rule_groups_v.id%TYPE;

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

Line 2727: FROM okc_rule_groups_v rg,

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

Line 2740: FROM okc_rule_groups_v rglease

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

Line 2839: FROM okc_rule_groups_v rgpv

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

Line 8308: FROM okc_rule_groups_v rgp, okc_rules_v rul

8304: AND gvr.dnz_chr_id = p_durv_rec.chr_id;
8305:
8306: CURSOR l_dff_rule_csr(p_rgd_code VARCHAR2, p_rule_information_category VARCHAR2) IS
8307: SELECT rgp.id, rul.id, rul.rule_information1
8308: FROM okc_rule_groups_v rgp, okc_rules_v rul
8309: WHERE rgp.id = rul.rgp_id
8310: AND rgp.rgd_code = p_rgd_code
8311: AND rul.rule_information_category = p_rule_information_category
8312: AND rul.dnz_chr_id = p_durv_rec.chr_id

Line 8327: FROM okc_rule_groups_v rgp, okc_rules_v rul

8323: --end modified abhsaxen for performance SQLID 20563248
8324: ;
8325: CURSOR l_customer_account_csr IS
8326: SELECT rgp.id, rul.id, rul.object1_id1,rul.object1_id2,rul.jtot_object1_code
8327: FROM okc_rule_groups_v rgp, okc_rules_v rul
8328: WHERE rgp.id = rul.rgp_id
8329: AND rgp.rgd_code = 'LACAN'
8330: AND rul.rule_information_category = 'CAN'
8331: AND rul.dnz_chr_id = p_durv_rec.chr_id