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 12574: FROM OKC_RULE_GROUPS_B rgpb

12570: --cursor to fetch rules linked to lines
12571: CURSOR l_rgp_csr(p_cle_id in number,
12572: p_chr_id in number) IS
12573: SELECT rgpb.id
12574: FROM OKC_RULE_GROUPS_B rgpb
12575: WHERE rgpb.cle_id = p_cle_id
12576: AND rgpb.dnz_chr_id = p_chr_id;
12577:
12578:

Line 12579: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

12575: WHERE rgpb.cle_id = p_cle_id
12576: AND rgpb.dnz_chr_id = p_chr_id;
12577:
12578:
12579: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
12580: l_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
12581:
12582:
12583: --cursor to get cost and salvage value for corporate book

Line 13653: FROM okc_rule_groups_b rgpb

13649: --cursor to get rule groups attached to old line
13650: CURSOR l_rgp_csr(p_orig_cle_id in number,
13651: p_chr_id in number) is
13652: SELECT rgpb.id
13653: FROM okc_rule_groups_b rgpb
13654: WHERE rgpb.cle_id = p_cle_id
13655: AND rgpb.dnz_chr_id = p_chr_id;
13656:
13657: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

Line 13657: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

13653: FROM okc_rule_groups_b rgpb
13654: WHERE rgpb.cle_id = p_cle_id
13655: AND rgpb.dnz_chr_id = p_chr_id;
13656:
13657: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13658: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13659:
13660: --cursor to get party roles attached to old line
13661: CURSOR l_cpl_csr (p_orig_cle_id in number,

Line 13658: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;

13654: WHERE rgpb.cle_id = p_cle_id
13655: AND rgpb.dnz_chr_id = p_chr_id;
13656:
13657: l_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13658: lx_rgp_id OKC_RULE_GROUPS_B.ID%TYPE;
13659:
13660: --cursor to get party roles attached to old line
13661: CURSOR l_cpl_csr (p_orig_cle_id in number,
13662: p_chr_id in number) is

Line 13703: OKC_RULE_GROUPS_B RGPB_OLD,

13699: RULSLH.ID,
13700: RULSLL.ID
13701: FROM OKC_RULES_B RULSLL_OLD,
13702: OKC_RULES_B RULSLH_OLD,
13703: OKC_RULE_GROUPS_B RGPB_OLD,
13704: OKC_RULES_B RULSLL,
13705: OKC_RULES_B RULSLH,
13706: OKC_RULE_GROUPS_B RGPB
13707: WHERE TO_CHAR(RULSLH_OLD.ID) = NVL(RULSLL.OBJECT2_ID1,-99) --the new sll has old slh's id

Line 13706: OKC_RULE_GROUPS_B RGPB

13702: OKC_RULES_B RULSLH_OLD,
13703: OKC_RULE_GROUPS_B RGPB_OLD,
13704: OKC_RULES_B RULSLL,
13705: OKC_RULES_B RULSLH,
13706: OKC_RULE_GROUPS_B RGPB
13707: WHERE TO_CHAR(RULSLH_OLD.ID) = NVL(RULSLL.OBJECT2_ID1,-99) --the new sll has old slh's id
13708: AND RULSLH_OLD.OBJECT1_ID1 = RULSLH.OBJECT1_ID1 --stream type ids are same for old and new slh
13709: AND RULSLL_OLD.RULE_INFORMATION_CATEGORY = 'LASLL'
13710: AND RULSLL_OLD.DNZ_CHR_ID = RGPB_OLD.DNZ_CHR_ID