APPS.OKL_VAR_INT_FLOAT_PVT dependencies on OKL_STRM_TYPE_B

Line 34: okl_strm_type_b styb

30: rulb2.object1_id1 frequency
31: FROM okc_rule_groups_b rgpb,
32: okc_rules_b rulb,
33: okc_rules_b rulb2,
34: okl_strm_type_b styb
35: WHERE rgpb.chr_id = p_contract_id
36: AND rgpb.dnz_chr_id = p_contract_id
37: AND rgpb.rgd_code = 'LALEVL'
38: AND rulb.rgp_id = rgpb.id

Line 52: okl_strm_type_b styb

48: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION3) * DECODE(rulb2.object1_id1,'M',1,'Q',3,'S',6,'A',12) * 30),0)
49: FROM okc_rule_groups_b rgpb,
50: okc_rules_b rulb,
51: okc_rules_b rulb2,
52: okl_strm_type_b styb
53: WHERE rgpb.chr_id = p_contract_id
54: AND rgpb.dnz_chr_id = p_contract_id
55: AND rgpb.rgd_code = 'LALEVL'
56: AND rulb.rgp_id = rgpb.id

Line 70: okl_strm_type_b styb

66: SELECT NVL(SUM(TO_NUMBER(rulb2.RULE_INFORMATION7)),0)
67: FROM okc_rule_groups_b rgpb,
68: okc_rules_b rulb,
69: okc_rules_b rulb2,
70: okl_strm_type_b styb
71: WHERE rgpb.chr_id = p_contract_id
72: AND rgpb.dnz_chr_id = p_contract_id
73: AND rgpb.rgd_code = 'LALEVL'
74: AND rulb.rgp_id = rgpb.id

Line 1081: okl_strm_type_b sty

1077: SELECT NVL(rul2.rule_information10,'N') arrears_yn
1078: FROM okc_rule_groups_b rgp,
1079: okc_rules_b rul1,
1080: okc_rules_b rul2,
1081: okl_strm_type_b sty
1082: WHERE rul2.dnz_chr_id = rgp.dnz_chr_id
1083: AND rul2.rule_information_category = 'LASLL'
1084: AND rul2.rgp_id = rgp.id
1085: AND rgp.cle_id IS NULL