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_PARTY_PAYMENTS_PVT dependencies on OKC_RULES_B

Line 1348: FROM okc_rules_b sll,

1344: CURSOR fee_payment_amt_csr (p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1345: SELECT TO_NUMBER(sll.rule_information3) periods,
1346: TO_NUMBER(sll.rule_information6) amount,
1347: TO_NUMBER(sll.rule_information8) stub_amount
1348: FROM okc_rules_b sll,
1349: okc_rule_groups_b rgp
1350: WHERE rgp.dnz_chr_id = p_chr_id
1351: AND rgp.cle_id = p_cle_id
1352: AND rgp.rgd_code = 'LALEVL'

Line 1371: FROM okc_rules_b sll,

1367: AND pph.dnz_chr_id =p_chr_id;
1368:
1369: CURSOR s_payment_amt_csr (p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1370: SELECT TO_NUMBER(sll.rule_information6) amount
1371: FROM okc_rules_b sll,
1372: okc_rules_b slh,
1373: okc_rule_groups_b rgp
1374: WHERE rgp.dnz_chr_id = p_chr_id
1375: AND rgp.cle_id = p_cle_id

Line 1372: okc_rules_b slh,

1368:
1369: CURSOR s_payment_amt_csr (p_cle_id IN NUMBER, p_chr_id IN NUMBER) IS
1370: SELECT TO_NUMBER(sll.rule_information6) amount
1371: FROM okc_rules_b sll,
1372: okc_rules_b slh,
1373: okc_rule_groups_b rgp
1374: WHERE rgp.dnz_chr_id = p_chr_id
1375: AND rgp.cle_id = p_cle_id
1376: AND rgp.rgd_code = 'LALEVL'