APPS.OKL_RELEASE_PVT dependencies on OKC_RULE_GROUPS_B

Line 1091: from okc_rule_groups_b rgp,

1087: CURSOR larles_csr(p_chr_id IN NUMBER) IS
1088: select rul.id rul_id,
1089: rgp.id rgp_id,
1090: rul.rule_information1
1091: from okc_rule_groups_b rgp,
1092: okc_rules_b rul
1093: where rgp.id = rul.rgp_id
1094: and rgp.rgd_code = 'LARLES'
1095: and rul.rule_information_category = 'LARLES'

Line 3232: FROM okc_rule_groups_b crg,

3228: p_rgd_code IN VARCHAR2,
3229: p_rul_cat IN VARCHAR2
3230: ) IS
3231: SELECT crl.rule_information1
3232: FROM okc_rule_groups_b crg,
3233: okc_rules_b crl
3234: WHERE crl.rgp_id = crg.id
3235: AND crg.rgd_code = p_rgd_code
3236: AND crl.rule_information_category = p_rul_cat

Line 3311: okc_rule_groups_b rgp,

3307: FND_DATE.canonical_to_date(sll.rule_information2) +
3308: TO_NUMBER(sll.rule_information7) - 1) end_date
3309: FROM okc_rules_b sll,
3310: okc_rules_b slh,
3311: okc_rule_groups_b rgp,
3312: okl_strm_type_b sty
3313: WHERE rgp.dnz_chr_id = p_chr_id
3314: AND rgp.cle_id = p_cle_id
3315: AND rgp.rgd_code = 'LALEVL'

Line 3653: okc_rule_groups_b rgp,

3649: sll.id sll_id,
3650: sty.stream_type_purpose
3651: FROM okc_rules_b sll,
3652: okc_rules_b slh,
3653: okc_rule_groups_b rgp,
3654: okl_strm_type_b sty
3655: WHERE rgp.dnz_chr_id = p_chr_id
3656: AND rgp.rgd_code = 'LALEVL'
3657: AND slh.rgp_id = rgp.id

Line 3677: FROM okc_rule_groups_b rgp

3673: AND sll.dnz_chr_id = slh.dnz_chr_id);
3674:
3675: CURSOR rgp_csr(p_chr_id IN NUMBER) IS
3676: SELECT rgp.id rgp_id
3677: FROM okc_rule_groups_b rgp
3678: WHERE rgp.dnz_chr_id = p_chr_id
3679: AND rgp.rgd_code = 'LALEVL'
3680: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh
3681: WHERE slh.rgp_id = rgp.id

Line 4189: okc_rule_groups_b rgp

4185: rul_lafreq.id rul_lafreq_id,
4186: rgp.id rgp_id
4187: FROM okc_rules_b rul_lafexp,
4188: okc_rules_b rul_lafreq,
4189: okc_rule_groups_b rgp
4190: WHERE rgp.dnz_chr_id = p_chr_id
4191: AND rgp.cle_id = p_cle_id
4192: AND rgp.rgd_code = 'LAFEXP'
4193: AND rul_lafreq.rgp_id = rgp.id

Line 4220: FROM okc_rule_groups_b rgp

4216: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
4217: p_cle_id IN NUMBER) IS
4218: SELECT 'Y' pymt_exists,
4219: rgp.id
4220: FROM okc_rule_groups_b rgp
4221: WHERE rgp.cle_id = p_cle_id
4222: AND rgp.dnz_chr_id = p_chr_id
4223: AND rgp.rgd_code = 'LALEVL';
4224:

Line 4226: l_rgp_id okc_rule_groups_b.id%TYPE;

4222: AND rgp.dnz_chr_id = p_chr_id
4223: AND rgp.rgd_code = 'LALEVL';
4224:
4225: l_pymt_exists VARCHAR2(30);
4226: l_rgp_id okc_rule_groups_b.id%TYPE;
4227:
4228: CURSOR fee_item_csr(p_chr_id IN NUMBER,
4229: p_cle_id IN NUMBER) IS
4230: SELECT fee_cim.id,

Line 5709: okc_rule_groups_b rgp

5705: rul_lafreq.id rul_lafreq_id,
5706: rgp.id rgp_id
5707: FROM okc_rules_b rul_lafexp,
5708: okc_rules_b rul_lafreq,
5709: okc_rule_groups_b rgp
5710: WHERE rgp.dnz_chr_id = p_chr_id
5711: AND rgp.cle_id = p_cle_id
5712: AND rgp.rgd_code = 'LAFEXP'
5713: AND rul_lafreq.rgp_id = rgp.id

Line 5743: FROM okc_rule_groups_b rgp

5739:
5740: CURSOR check_pymts_csr(p_chr_id IN NUMBER,
5741: p_cle_id IN NUMBER) IS
5742: SELECT 'Y' pymt_exists
5743: FROM okc_rule_groups_b rgp
5744: WHERE rgp.cle_id = p_cle_id
5745: AND rgp.dnz_chr_id = p_chr_id
5746: AND rgp.rgd_code = 'LALEVL';
5747:

Line 6387: okc_rule_groups_b rgp

6383: SELECT TO_NUMBER(sll.rule_information6) amount,
6384: TO_NUMBER(sll.rule_information8) stub_amount,
6385: sll.id sll_id
6386: FROM okc_rules_b sll,
6387: okc_rule_groups_b rgp
6388: WHERE rgp.dnz_chr_id = p_chr_id
6389: AND rgp.cle_id = p_cle_id
6390: AND rgp.rgd_code = 'LALEVL'
6391: AND sll.rule_information_category = 'LASLL'

Line 7524: from okc_rule_groups_b rgp,

7520: p_rgd_code IN VARCHAR2,
7521: p_rul_cat IN VARCHAR2) IS
7522: select rul.id rul_id,
7523: rgp.id rgp_id
7524: from okc_rule_groups_b rgp,
7525: okc_rules_b rul
7526: where rgp.id = rul.rgp_id
7527: and rgp.rgd_code = p_rgd_code
7528: and rul.rule_information_category = p_rul_cat