DBA Data[Home] [Help]

APPS.OKL_PARTY_PAYMENTS_PVT dependencies on OKC_RULE_GROUPS_B

Line 1349: okc_rule_groups_b rgp

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'
1353: AND sll.rule_information_category = 'LASLL'

Line 1373: okc_rule_groups_b rgp

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'
1377: AND slh.rgp_id = rgp.id