APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKC_RULES_B

Line 1086: FROM okc_rules_b rule,

1082:
1083: -- Derive print lead days from the rules
1084: CURSOR c_lead_days(p_khr_id IN NUMBER) IS
1085: SELECT rule_information3
1086: FROM okc_rules_b rule,
1087: okc_rule_groups_b rgp
1088: WHERE rgp.id = rule.rgp_id
1089: AND rgp.dnz_chr_id = p_khr_id
1090: AND rgd_code = 'LABILL'

Line 2821: okc_rules_b rulb,

2817: rulb2.RULE_INFORMATION8 stub_amount,
2818: rulb2.object1_id1 frequency
2819: FROM okc_k_lines_b cleb,
2820: okc_rule_groups_b rgpb,
2821: okc_rules_b rulb,
2822: okc_rules_b rulb2,
2823: okl_strm_type_b styb
2824: WHERE rgpb.chr_id IS NULL
2825: AND rgpb.dnz_chr_id = cleb.dnz_chr_id

Line 2822: okc_rules_b rulb2,

2818: rulb2.object1_id1 frequency
2819: FROM okc_k_lines_b cleb,
2820: okc_rule_groups_b rgpb,
2821: okc_rules_b rulb,
2822: okc_rules_b rulb2,
2823: okl_strm_type_b styb
2824: WHERE rgpb.chr_id IS NULL
2825: AND rgpb.dnz_chr_id = cleb.dnz_chr_id
2826: AND rgpb.cle_id = cleb.id

Line 2854: l_frequency okc_rules_b.object1_id1%type;

2850: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2851: l_next_start_date DATE := p_start_date;
2852: l_sel_date DATE;
2853: l_recurrence_date DATE := NULL;
2854: l_frequency okc_rules_b.object1_id1%type;
2855: l_adder_months NUMBER := 0;
2856: l_cle_id OKC_K_LINES_B.ID%TYPE;
2857:
2858: BEGIN

Line 3031: from okc_rules_b sll_rulb,

3027: -- Declare payment frequency cursor
3028: -----------------------------------------------------------------
3029: CURSOR c_pay_freq(cp_khr_id NUMBER) IS
3030: select sll_rulb.object1_id1 pay_freq
3031: from okc_rules_b sll_rulb,
3032: okc_rules_b slh_rulb,
3033: okl_strm_type_b styb,
3034: okc_rule_groups_b rgpb
3035: where sll_rulb.rgp_id = rgpb.id

Line 3032: okc_rules_b slh_rulb,

3028: -----------------------------------------------------------------
3029: CURSOR c_pay_freq(cp_khr_id NUMBER) IS
3030: select sll_rulb.object1_id1 pay_freq
3031: from okc_rules_b sll_rulb,
3032: okc_rules_b slh_rulb,
3033: okl_strm_type_b styb,
3034: okc_rule_groups_b rgpb
3035: where sll_rulb.rgp_id = rgpb.id
3036: and sll_rulb.rule_information_category = 'LASLL'

Line 6456: okc_rules_b rul1,

6452: --Bug# 13026821
6453: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
6454: SELECT NVL(rul2.rule_information10,'N') arrears_yn
6455: FROM okc_rule_groups_b rgp,
6456: okc_rules_b rul1,
6457: okc_rules_b rul2,
6458: okl_strm_type_b sty
6459: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
6460: AND rul2.rule_information_category = 'LASLL'

Line 6457: okc_rules_b rul2,

6453: CURSOR l_varint_sll_csr( khrid NUMBER ) IS
6454: SELECT NVL(rul2.rule_information10,'N') arrears_yn
6455: FROM okc_rule_groups_b rgp,
6456: okc_rules_b rul1,
6457: okc_rules_b rul2,
6458: okl_strm_type_b sty
6459: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
6460: AND rul2.rule_information_category = 'LASLL'
6461: AND rul2.rgp_id = rgp.id