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 12703: From okc_rules_b rul

12699:
12700: Cursor town_rul_csr (pchrid number) is
12701: Select rule_information1 tax_owner,
12702: id
12703: From okc_rules_b rul
12704: where rul.dnz_chr_id = pchrid
12705: and rul.rule_information_category = 'LATOWN'
12706: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12707:

Line 12708: l_town_rul okc_rules_b.rule_information1%TYPE;

12704: where rul.dnz_chr_id = pchrid
12705: and rul.rule_information_category = 'LATOWN'
12706: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12707:
12708: l_town_rul okc_rules_b.rule_information1%TYPE;
12709: l_town_rul_id okc_rules_b.id%TYPE;
12710:
12711: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12712: l_rep_asset_book_done varchar2(1);

Line 12709: l_town_rul_id okc_rules_b.id%TYPE;

12705: and rul.rule_information_category = 'LATOWN'
12706: and nvl(rul.STD_TEMPLATE_YN,'N') = 'N';
12707:
12708: l_town_rul okc_rules_b.rule_information1%TYPE;
12709: l_town_rul_id okc_rules_b.id%TYPE;
12710:
12711: l_rep_asset_book okl_txl_assets_b.corporate_book%TYPE;
12712: l_rep_asset_book_done varchar2(1);
12713: l_rep_pdt_id number;

Line 13602: FROM OKC_RULES_B RULSLL_OLD,

13598: SELECT
13599:
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,

Line 13603: OKC_RULES_B RULSLH_OLD,

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

Line 13605: OKC_RULES_B RULSLL,

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

Line 13606: OKC_RULES_B RULSLH,

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

Line 13634: l_slh_id OKC_RULES_B.ID%TYPE;

13630: AND RGPB.CHR_ID IS NULL
13631: AND RGPB.DNZ_CHR_ID = p_chr_id
13632: AND RGPB.CLE_ID = p_cle_id;
13633:
13634: l_slh_id OKC_RULES_B.ID%TYPE;
13635: l_sll_id OKC_RULES_B.ID%TYPE;
13636:
13637: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13638: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 13635: l_sll_id OKC_RULES_B.ID%TYPE;

13631: AND RGPB.DNZ_CHR_ID = p_chr_id
13632: AND RGPB.CLE_ID = p_cle_id;
13633:
13634: l_slh_id OKC_RULES_B.ID%TYPE;
13635: l_sll_id OKC_RULES_B.ID%TYPE;
13636:
13637: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13638: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
13639:

Line 15154: FROM OKC_RULES_B rul

15150: FROM okc_k_headers_b CHR
15151: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
15152: and chr.ID = p_chr_id
15153: AND exists (SELECT '1'
15154: FROM OKC_RULES_B rul
15155: WHERE rul.dnz_chr_id = chr.id
15156: AND rul.rule_information_category = 'LARLES'
15157: AND nvl(rule_information1,'N') = 'Y');
15158:

Line 16300: okc_rules_b rul

16296: chr.orig_system_source_code,
16297: chr.orig_system_id1 orig_chr_id,
16298: chr.start_date
16299: FROM okc_k_headers_b CHR,
16300: okc_rules_b rul
16301: WHERE CHR.ID = p_chr_id
16302: AND rul.dnz_chr_id = CHR.id
16303: AND rul.rule_information_category = 'LARLES'
16304: AND NVL(rule_information1,'N') = 'Y';

Line 17986: FROM OKC_RULES_B rul

17982: --akrangan Bug# 5362977 start
17983: --cursor to check if contract has re-lease assets
17984: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
17985: SELECT 'Y'
17986: FROM OKC_RULES_B rul
17987: WHERE rul.dnz_chr_id = p_chr_id
17988: AND rul.rule_information_category = 'LARLES'
17989: AND NVL(rule_information1,'N') = 'Y';
17990:

Line 19006: FROM OKC_RULES_B rul

19002: --akrangan Bug# 5362977 start
19003: --cursor to check if contract has re-lease assets
19004: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
19005: SELECT 'Y'
19006: FROM OKC_RULES_B rul
19007: WHERE rul.dnz_chr_id = p_chr_id
19008: AND rul.rule_information_category = 'LARLES'
19009: AND NVL(rule_information1,'N') = 'Y';
19010:

Line 19887: FROM OKC_RULES_B rul

19883: --Bug# 5362977 start
19884: --cursor to check if contract has re-lease assets
19885: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
19886: SELECT 'Y'
19887: FROM OKC_RULES_B rul
19888: WHERE rul.dnz_chr_id = p_chr_id
19889: AND rul.rule_information_category = 'LARLES'
19890: AND NVL(rule_information1,'N') = 'Y';
19891: