APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKC_RULES_B

Line 503: l_bto_id okc_rules_b.object1_id1%TYPE;

499: and (cplb.bill_to_site_use_id is NOT NULL
500: OR
501: cplb.cust_acct_id is NOT NULL);
502:
503: l_bto_id okc_rules_b.object1_id1%TYPE;
504: l_custacct_id okc_rules_b.object1_id1%TYPE;
505:
506:
507: --Local function to determine whether BTO is active

Line 504: l_custacct_id okc_rules_b.object1_id1%TYPE;

500: OR
501: cplb.cust_acct_id is NOT NULL);
502:
503: l_bto_id okc_rules_b.object1_id1%TYPE;
504: l_custacct_id okc_rules_b.object1_id1%TYPE;
505:
506:
507: --Local function to determine whether BTO is active
508: Function is_bto_active(p_bto_id IN Varchar2,

Line 877: FROM OKC_RULES_B rul

873: FROM okc_k_headers_b CHR
874: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
875: and chr.ID = p_chr_id
876: AND exists (SELECT '1'
877: FROM OKC_RULES_B rul
878: WHERE rul.dnz_chr_id = chr.id
879: AND rul.rule_information_category = 'LARLES'
880: AND nvl(rule_information1,'N') = 'Y');
881:

Line 1016: From okc_rules_b rul

1012: -- Bug# 3541098
1013: -- cursor to get capitalize interest flag
1014: Cursor cap_interest_rul_csr (pchrid number) is
1015: Select rul.rule_information1 capitalize_interest_flag
1016: From okc_rules_b rul
1017: where rul.dnz_chr_id = pchrid
1018: and rul.rule_information_category = 'LACPLN';
1019:
1020: Cursor chr_csr (pchrid number) is

Line 1033: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;

1029: FROM okl_strm_elements sel
1030: WHERE sel.stm_id = p_stm_id
1031: AND sel.date_billed IS NOT NULL;
1032:
1033: l_capitalize_interest_flag okc_rules_b.rule_information1%TYPE;
1034: l_amount number;
1035: l_source_id number;
1036: l_contract_number okc_k_headers_b.contract_number%type;
1037: l_start_date okc_k_headers_b.start_date%type;