APPS.OKL_RELEASE_PVT dependencies on OKC_RULE_GROUPS_B

Line 1077: from okc_rule_groups_b rgp,

1073: CURSOR larles_csr(p_chr_id IN NUMBER) IS
1074: select rul.id rul_id,
1075: rgp.id rgp_id,
1076: rul.rule_information1
1077: from okc_rule_groups_b rgp,
1078: okc_rules_b rul
1079: where rgp.id = rul.rgp_id
1080: and rgp.rgd_code = 'LARLES'
1081: and rul.rule_information_category = 'LARLES'

Line 3178: FROM okc_rule_groups_b crg,

3174: p_rgd_code IN VARCHAR2,
3175: p_rul_cat IN VARCHAR2
3176: ) IS
3177: SELECT crl.rule_information1
3178: FROM okc_rule_groups_b crg,
3179: okc_rules_b crl
3180: WHERE crl.rgp_id = crg.id
3181: AND crg.rgd_code = p_rgd_code
3182: AND crl.rule_information_category = p_rul_cat

Line 3257: okc_rule_groups_b rgp,

3253: FND_DATE.canonical_to_date(sll.rule_information2) +
3254: TO_NUMBER(sll.rule_information7) - 1) end_date
3255: FROM okc_rules_b sll,
3256: okc_rules_b slh,
3257: okc_rule_groups_b rgp,
3258: okl_strm_type_b sty
3259: WHERE rgp.dnz_chr_id = p_chr_id
3260: AND rgp.cle_id = p_cle_id
3261: AND rgp.rgd_code = 'LALEVL'

Line 3597: okc_rule_groups_b rgp

3593: sll.jtot_object2_code,
3594: sll.id sll_id
3595: FROM okc_rules_b sll,
3596: okc_rules_b slh,
3597: okc_rule_groups_b rgp
3598: WHERE rgp.dnz_chr_id = p_chr_id
3599: AND rgp.rgd_code = 'LALEVL'
3600: AND slh.rgp_id = rgp.id
3601: AND slh.rule_information_category = 'LASLH'

Line 3619: FROM okc_rule_groups_b rgp

3615: AND sll.dnz_chr_id = slh.dnz_chr_id);
3616:
3617: CURSOR rgp_csr(p_chr_id IN NUMBER) IS
3618: SELECT rgp.id rgp_id
3619: FROM okc_rule_groups_b rgp
3620: WHERE rgp.dnz_chr_id = p_chr_id
3621: AND rgp.rgd_code = 'LALEVL'
3622: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh
3623: WHERE slh.rgp_id = rgp.id

Line 4129: okc_rule_groups_b rgp

4125: rul_lafreq.id rul_lafreq_id,
4126: rgp.id rgp_id
4127: FROM okc_rules_b rul_lafexp,
4128: okc_rules_b rul_lafreq,
4129: okc_rule_groups_b rgp
4130: WHERE rgp.dnz_chr_id = p_chr_id
4131: AND rgp.cle_id = p_cle_id
4132: AND rgp.rgd_code = 'LAFEXP'
4133: AND rul_lafreq.rgp_id = rgp.id

Line 4160: FROM okc_rule_groups_b rgp

4156: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
4157: p_cle_id IN NUMBER) IS
4158: SELECT 'Y' pymt_exists,
4159: rgp.id
4160: FROM okc_rule_groups_b rgp
4161: WHERE rgp.cle_id = p_cle_id
4162: AND rgp.dnz_chr_id = p_chr_id
4163: AND rgp.rgd_code = 'LALEVL';
4164:

Line 4166: l_rgp_id okc_rule_groups_b.id%TYPE;

4162: AND rgp.dnz_chr_id = p_chr_id
4163: AND rgp.rgd_code = 'LALEVL';
4164:
4165: l_pymt_exists VARCHAR2(30);
4166: l_rgp_id okc_rule_groups_b.id%TYPE;
4167:
4168: CURSOR fee_item_csr(p_chr_id IN NUMBER,
4169: p_cle_id IN NUMBER) IS
4170: SELECT fee_cim.id,

Line 5400: okc_rule_groups_b rgp

5396: rul_lafreq.id rul_lafreq_id,
5397: rgp.id rgp_id
5398: FROM okc_rules_b rul_lafexp,
5399: okc_rules_b rul_lafreq,
5400: okc_rule_groups_b rgp
5401: WHERE rgp.dnz_chr_id = p_chr_id
5402: AND rgp.cle_id = p_cle_id
5403: AND rgp.rgd_code = 'LAFEXP'
5404: AND rul_lafreq.rgp_id = rgp.id

Line 5434: FROM okc_rule_groups_b rgp

5430:
5431: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
5432: p_cle_id IN NUMBER) IS
5433: SELECT 'Y' pymt_exists
5434: FROM okc_rule_groups_b rgp
5435: WHERE rgp.cle_id = p_cle_id
5436: AND rgp.dnz_chr_id = p_chr_id
5437: AND rgp.rgd_code = 'LALEVL';
5438:

Line 6078: okc_rule_groups_b rgp

6074: SELECT TO_NUMBER(sll.rule_information6) amount,
6075: TO_NUMBER(sll.rule_information8) stub_amount,
6076: sll.id sll_id
6077: FROM okc_rules_b sll,
6078: okc_rule_groups_b rgp
6079: WHERE rgp.dnz_chr_id = p_chr_id
6080: AND rgp.cle_id = p_cle_id
6081: AND rgp.rgd_code = 'LALEVL'
6082: AND sll.rule_information_category = 'LASLL'

Line 7206: from okc_rule_groups_b rgp,

7202: p_rgd_code IN VARCHAR2,
7203: p_rul_cat IN VARCHAR2) IS
7204: select rul.id rul_id,
7205: rgp.id rgp_id
7206: from okc_rule_groups_b rgp,
7207: okc_rules_b rul
7208: where rgp.id = rul.rgp_id
7209: and rgp.rgd_code = p_rgd_code
7210: and rul.rule_information_category = p_rul_cat