eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RELEASE_PVT dependencies on OKC_RULES_B

Line 1078: okc_rules_b rul

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'
1082: and rgp.dnz_chr_id = p_chr_id

Line 3179: okc_rules_b crl

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
3183: AND crg.dnz_chr_id = p_chr_id;

Line 3255: FROM okc_rules_b sll,

3251: NVL(TO_NUMBER(sll.rule_information3),1) *
3252: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
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

Line 3256: okc_rules_b slh,

3252: DECODE(sll.object1_id1, 'M',1,'Q',3,'S',6,'A',12)) - 1),
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

Line 3595: FROM okc_rules_b sll,

3591: sll.object2_id1,
3592: sll.object2_id2,
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'

Line 3596: okc_rules_b slh,

3592: sll.object2_id2,
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

Line 3609: FROM okc_rules_b slh

3605: AND FND_DATE.canonical_to_date(sll.rule_information2) < p_release_date;
3606:
3607: CURSOR slh_csr(p_chr_id IN NUMBER) IS
3608: SELECT slh.id slh_id
3609: FROM okc_rules_b slh
3610: WHERE slh.dnz_chr_id = p_chr_id
3611: AND slh.rule_information_category = 'LASLH'
3612: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll
3613: WHERE sll.object2_id1 = slh.id

Line 3612: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll

3608: SELECT slh.id slh_id
3609: FROM okc_rules_b slh
3610: WHERE slh.dnz_chr_id = p_chr_id
3611: AND slh.rule_information_category = 'LASLH'
3612: AND NOT EXISTS (SELECT NULL FROM okc_rules_b sll
3613: WHERE sll.object2_id1 = slh.id
3614: AND sll.rule_information_category = 'LASLL'
3615: AND sll.dnz_chr_id = slh.dnz_chr_id);
3616:

Line 3622: AND NOT EXISTS (SELECT NULL FROM okc_rules_b slh

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
3624: AND slh.rule_information_category = 'LASLH');
3625:
3626: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

Line 4127: FROM okc_rules_b rul_lafexp,

4123: TO_NUMBER(rul_lafexp.rule_information2) amount,
4124: rul_lafexp.id rul_lafexp_id,
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

Line 4128: okc_rules_b rul_lafreq,

4124: rul_lafexp.id rul_lafexp_id,
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'

Line 4186: FROM okc_rules_b crl

4182: SELECT crl.object1_id1,
4183: crl.rule_information3,
4184: crl.rule_information6,
4185: crl.rule_information8
4186: FROM okc_rules_b crl
4187: WHERE crl.rgp_id = p_rgp_id
4188: AND crl.dnz_chr_id = p_chr_id
4189: AND crl.rule_information_category = p_rul_cat;
4190:

Line 5398: FROM okc_rules_b rul_lafexp,

5394: TO_NUMBER(rul_lafexp.rule_information2) amount,
5395: rul_lafexp.id rul_lafexp_id,
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

Line 5399: okc_rules_b rul_lafreq,

5395: rul_lafexp.id rul_lafexp_id,
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'

Line 6077: FROM okc_rules_b sll,

6073: p_cle_id IN NUMBER) IS
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'

Line 6400: okc_rules_b rulb

6396: Cursor l_book_class_csr (p_chr_id IN NUMBER) is
6397: select khr.deal_type deal_type,
6398: rulb.rule_information1 tax_owner
6399: from okl_k_headers khr,
6400: okc_rules_b rulb
6401: where rulb.dnz_chr_id = p_chr_id
6402: and rulb.rule_information_category = 'LATOWN'
6403: and khr.id = p_chr_id;
6404:

Line 7207: okc_rules_b rul

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
7211: and rgp.dnz_chr_id = p_chr_id