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_RULES_B

Line 12789: From okc_rules_b rul

12785:
12786: Cursor town_rul_csr (pchrid number) is
12787: Select rule_information1 tax_owner,
12788: id
12789: From okc_rules_b rul
12790: where rul.dnz_chr_id = pchrid
12791: and rul.rule_information_category = 'LATOWN'
12792: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12793:

Line 12794: l_town_rul okc_rules_b.rule_information1%TYPE;

12790: where rul.dnz_chr_id = pchrid
12791: and rul.rule_information_category = 'LATOWN'
12792: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12793:
12794: l_town_rul okc_rules_b.rule_information1%TYPE;
12795: l_town_rul_id okc_rules_b.id%TYPE;
12796:
12797: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12798: l_rep_asset_book_done varchar2(1);

Line 12795: l_town_rul_id okc_rules_b.id%TYPE;

12791: and rul.rule_information_category = 'LATOWN'
12792: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12793:
12794: l_town_rul okc_rules_b.rule_information1%TYPE;
12795: l_town_rul_id okc_rules_b.id%TYPE;
12796:
12797: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12798: l_rep_asset_book_done varchar2(1);
12799: l_rep_pdt_id number;

Line 13701: FROM OKC_RULES_B RULSLL_OLD,

13697: SELECT
13698:
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,

Line 13702: OKC_RULES_B RULSLH_OLD,

13698:
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

Line 13704: OKC_RULES_B RULSLL,

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
13708: AND RULSLH_OLD.OBJECT1_ID1 = RULSLH.OBJECT1_ID1 --stream type ids are same for old and new slh

Line 13705: OKC_RULES_B RULSLH,

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
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'

Line 13733: l_slh_id OKC_RULES_B.ID%TYPE;

13729: AND RGPB.CHR_ID IS NULL
13730: AND RGPB.DNZ_CHR_ID = p_chr_id
13731: AND RGPB.CLE_ID = p_cle_id;
13732:
13733: l_slh_id OKC_RULES_B.ID%TYPE;
13734: l_sll_id OKC_RULES_B.ID%TYPE;
13735:
13736: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13737: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 13734: l_sll_id OKC_RULES_B.ID%TYPE;

13730: AND RGPB.DNZ_CHR_ID = p_chr_id
13731: AND RGPB.CLE_ID = p_cle_id;
13732:
13733: l_slh_id OKC_RULES_B.ID%TYPE;
13734: l_sll_id OKC_RULES_B.ID%TYPE;
13735:
13736: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13737: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13738:

Line 15266: FROM OKC_RULES_B rul

15262: FROM okc_k_headers_b CHR
15263: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15264: and chr.ID = p_chr_id
15265: AND exists (SELECT '1'
15266: FROM OKC_RULES_B rul
15267: WHERE rul.dnz_chr_id = chr.id
15268: AND rul.rule_information_category = 'LARLES'
15269: AND nvl(rule_information1,'N') = 'Y');*/
15270:

Line 16441: okc_rules_b rul

16437: chr.orig_system_source_code,
16438: chr.orig_system_id1 orig_chr_id,
16439: chr.start_date
16440: FROM okc_k_headers_b CHR,
16441: okc_rules_b rul
16442: WHERE CHR.ID = p_chr_id
16443: AND rul.dnz_chr_id = CHR.id
16444: AND rul.rule_information_category = 'LARLES'
16445: AND NVL(rule_information1,'N') = 'Y';*/

Line 18196: FROM OKC_RULES_B rul

18192: -- but needs to be validated at contract line
18193: -- Cursor modified to include validation at asset line level
18194: /*CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
18195: SELECT 'Y'
18196: FROM OKC_RULES_B rul
18197: WHERE rul.dnz_chr_id = p_chr_id
18198: AND rul.rule_information_category = 'LARLES'
18199: AND NVL(rule_information1,'N') = 'Y';*/
18200:

Line 19240: FROM OKC_RULES_B rul

19236: -- but needs to be validated at contract line
19237: -- Cursor modified to include validation at asset line level
19238: /* CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
19239: SELECT 'Y'
19240: FROM OKC_RULES_B rul
19241: WHERE rul.dnz_chr_id = p_chr_id
19242: AND rul.rule_information_category = 'LARLES'
19243: AND NVL(rule_information1,'N') = 'Y';*/
19244:

Line 20146: FROM OKC_RULES_B rul

20142: -- but needs to be validated at contract line
20143: -- Cursor modified to include validation at asset line level
20144: /*CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
20145: SELECT 'Y'
20146: FROM OKC_RULES_B rul
20147: WHERE rul.dnz_chr_id = p_chr_id
20148: AND rul.rule_information_category = 'LARLES'
20149: AND NVL(rule_information1,'N') = 'Y';
20150: */