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

Line 12488: FROM OKC_RULE_GROUPS_B rgpb

12484: --cursor to fetch rules linked to lines
12485: CURSOR l_rgp_csr(p_cle_id in number,
12486: p_chr_id in number) IS
12487: SELECT rgpb.id
12488: FROM OKC_RULE_GROUPS_B rgpb
12489: WHERE rgpb.cle_id = p_cle_id
12490: AND rgpb.dnz_chr_id = p_chr_id;
12491:
12492:

Line 12493: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

12489: WHERE rgpb.cle_id = p_cle_id
12490: AND rgpb.dnz_chr_id = p_chr_id;
12491:
12492:
12493: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
12494: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
12495:
12496:
12497: --cursor to get cost and salvage value for corporate book

Line 13554: FROM okc_rule_groups_b rgpb

13550: --cursor to get rule groups attached to old line
13551: CURSOR l_rgp_csr(p_orig_cle_id in number,
13552: p_chr_id in number) is
13553: SELECT rgpb.id
13554: FROM okc_rule_groups_b rgpb
13555: WHERE rgpb.cle_id = p_cle_id
13556: AND rgpb.dnz_chr_id = p_chr_id;
13557:
13558: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

Line 13558: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

13554: FROM okc_rule_groups_b rgpb
13555: WHERE rgpb.cle_id = p_cle_id
13556: AND rgpb.dnz_chr_id = p_chr_id;
13557:
13558: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13559: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13560:
13561: --cursor to get party roles attached to old line
13562: CURSOR l_cpl_csr (p_orig_cle_id in number,

Line 13559: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

13555: WHERE rgpb.cle_id = p_cle_id
13556: AND rgpb.dnz_chr_id = p_chr_id;
13557:
13558: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13559: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13560:
13561: --cursor to get party roles attached to old line
13562: CURSOR l_cpl_csr (p_orig_cle_id in number,
13563: p_chr_id in number) is

Line 13604: OKC_RULE_GROUPS_B RGPB_OLD,

13600: RULSLH.ID,
13601: RULSLL.ID
13602: FROM OKC_RULES_B RULSLL_OLD,
13603: OKC_RULES_B RULSLH_OLD,
13604: OKC_RULE_GROUPS_B RGPB_OLD,
13605: OKC_RULES_B RULSLL,
13606: OKC_RULES_B RULSLH,
13607: OKC_RULE_GROUPS_B RGPB
13608: WHERE TO_CHAR(RULSLH_OLD.ID) = NVL(RULSLL.OBJECT2_ID1,-99) --the new sll has old slh's id

Line 13607: OKC_RULE_GROUPS_B RGPB

13603: OKC_RULES_B RULSLH_OLD,
13604: OKC_RULE_GROUPS_B RGPB_OLD,
13605: OKC_RULES_B RULSLL,
13606: OKC_RULES_B RULSLH,
13607: OKC_RULE_GROUPS_B RGPB
13608: WHERE TO_CHAR(RULSLH_OLD.ID) = NVL(RULSLL.OBJECT2_ID1,-99) --the new sll has old slh's id
13609: AND RULSLH_OLD.OBJECT1_ID1 = RULSLH.OBJECT1_ID1 --stream type ids are same for old and new slh
13610: AND RULSLL_OLD.RULE_INFORMATION_CATEGORY = 'LASLL'
13611: AND RULSLL_OLD.DNZ_CHR_ID = RGPB_OLD.DNZ_CHR_ID