APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_RULES_B

Line 221: l_bto_id okc_rules_b.object1_id1%TYPE;

217: and (cplb.bill_to_site_use_id is NOT NULL
218: OR
219: cplb.cust_acct_id is NOT NULL);
220:
221: l_bto_id okc_rules_b.object1_id1%TYPE;
222: l_custacct_id okc_rules_b.object1_id1%TYPE;
223:
224:
225: --Local function to determine whether BTO is active

Line 222: l_custacct_id okc_rules_b.object1_id1%TYPE;

218: OR
219: cplb.cust_acct_id is NOT NULL);
220:
221: l_bto_id okc_rules_b.object1_id1%TYPE;
222: l_custacct_id okc_rules_b.object1_id1%TYPE;
223:
224:
225: --Local function to determine whether BTO is active
226: Function is_bto_active(p_bto_id IN Varchar2,

Line 595: FROM OKC_RULES_B rul

591: FROM okc_k_headers_b CHR
592: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
593: and chr.ID = p_chr_id
594: /*AND exists (SELECT '1'
595: FROM OKC_RULES_B rul
596: WHERE rul.dnz_chr_id = chr.id
597: AND rul.rule_information_category = 'LARLES'
598: AND nvl(rule_information1,'N') = 'Y');*/
599: -- Bug# 15992711 Start of Modifications

Line 646: FROM OKC_RULES_B rul

642: --Cursor to check for the rule group LARLES
643: CURSOR l_rule_info_csr ( p_chr_id IN NUMBER) IS
644: SELECT rul.id
645: ,rul.rule_information1
646: FROM OKC_RULES_B rul
647: WHERE rul.dnz_chr_id = p_chr_id
648: AND rul.rule_information_category = 'LARLES';
649: l_rul_info NUMBER;
650: l_rul_info1 VARCHAR2(30);

Line 786: From okc_rules_b rul

782: -- Bug# 3541098
783: -- cursor to get capitalize interest flag
784: Cursor cap_interest_rul_csr (pchrid number) is
785: Select rul.rule_information1 capitalize_interest_flag
786: From okc_rules_b rul
787: where rul.dnz_chr_id = pchrid
788: and rul.rule_information_category = 'LACPLN';
789:
790: Cursor chr_csr (pchrid number) is

Line 803: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;

799: FROM okl_strm_elements sel
800: WHERE sel.stm_id = p_stm_id
801: AND sel.date_billed IS NOT NULL;
802:
803: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
804: l_amount number;
805: l_source_id number;
806: l_contract_number okc_k_headers_b.contract_number%type;
807: l_start_date okc_k_headers_b.start_date%type;