APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_RULE_GROUPS_B

Line 1372: okc_rule_groups_b rgpb,

1368: okc_k_party_roles_v cplv,
1369: hz_cust_accounts hzc,
1370: hz_cust_site_uses_all hzcsu,
1371: okc_rg_party_roles rgrp,
1372: okc_rule_groups_b rgpb,
1373: hz_parties hzp,
1374: okc_rules_b rulb
1375: WHERE cplv.dnz_chr_id = chrb.id
1376: and cplv.chr_id = chrb.id

Line 1411: ,okc_rule_groups_b rgp_lavenb

1407: ,rul_lapmth.object1_id1 rul_lapmth_o1id1
1408: ,rul_lapmth.object1_id2 rul_lapmth_o1id2
1409: FROM okc_k_headers_b chr
1410: ,okl_k_headers khr
1411: ,okc_rule_groups_b rgp_lavenb
1412: ,okc_rules_b rul_lainpr
1413: ,okc_rules_b rul_lainvd
1414: ,okc_rules_b rul_labacc
1415: ,okc_rules_b rul_lapmth

Line 2474: cp_rgd_code okc_rule_groups_b.rgd_code%TYPE) IS

2470: AND orig.cle_id IS NULL);
2471:
2472: CURSOR c_rl_exist_csr (cp_rul_info_cat okc_rules_b.rule_information_category%TYPE,
2473: cp_chr_id okc_k_headers_b.id%TYPE,
2474: cp_rgd_code okc_rule_groups_b.rgd_code%TYPE) IS
2475: SELECT rul.id
2476: ,rul.rgp_id
2477: ,rul.object_version_number
2478: FROM okc_rules_b rul

Line 2479: ,okc_rule_groups_b rgp

2475: SELECT rul.id
2476: ,rul.rgp_id
2477: ,rul.object_version_number
2478: FROM okc_rules_b rul
2479: ,okc_rule_groups_b rgp
2480: WHERE rgp.id = rul.rgp_id
2481: AND rgp.chr_id = rul.dnz_chr_id
2482: AND rul.rule_information_category = cp_rul_info_cat
2483: AND rgp.chr_id = cp_chr_id

Line 2508: FROM okc_rule_groups_b

2504: AND orig.cle_id IS NULL);
2505:
2506: CURSOR c_get_residual_grp(cp_chr_id okc_k_headers_b.id%TYPE) IS
2507: SELECT id
2508: FROM okc_rule_groups_b
2509: WHERE dnz_chr_id = cp_chr_id
2510: AND rgd_code = 'VGLRS';
2511:
2512: lv_rule_group_id okc_rule_groups_b.id%TYPE;

Line 2512: lv_rule_group_id okc_rule_groups_b.id%TYPE;

2508: FROM okc_rule_groups_b
2509: WHERE dnz_chr_id = cp_chr_id
2510: AND rgd_code = 'VGLRS';
2511:
2512: lv_rule_group_id okc_rule_groups_b.id%TYPE;
2513:
2514: cv_rl_exist_rec c_rl_exist_csr%ROWTYPE;
2515:
2516: lv_rule_info_tbl okl_rgrp_rules_process_pvt.rgr_tbl_type;

Line 2525: lv_rgp_id okc_rule_groups_b.id%TYPE;

2521: lx_new_rgp_tbl okl_okc_migration_pvt.rgpv_tbl_type;
2522: lv_new_rgp_tbl okl_okc_migration_pvt.rgpv_tbl_type;
2523: x_new_rgp_rec okl_rule_pub.rgpv_rec_type;
2524: x_rulv2_tbl okl_rule_pub.rulv_tbl_type;
2525: lv_rgp_id okc_rule_groups_b.id%TYPE;
2526: lx_rulv2_tbl OKL_RULE_PUB.rulv_tbl_type;
2527: lv_rgpv_del_tbl okl_vp_rule_pub.rgpv_tbl_type;
2528: lv_rule_information1 okc_rules_b.rule_information1%TYPE;
2529: