[Home] [Help]
719: p_payment_frequency IN VARCHAR2,
720: p_payment_arrears IN VARCHAR2) RETURN BOOLEAN IS
721: -- cursor to retrieve the details of the LASLL rule
722: CURSOR find_lasll_dtls_csr(p_rul_id NUMBER) IS
723: SELECT object1_id1 frequency, object2_id1 laslh_id, fnd_date.canonical_to_date(rule_information2) start_date,
724: rule_information3 periods, rule_information6 amount,
725: rule_information5 payment_structure, rule_information13 rate,
726: rule_information7 stub_days, rule_information8 stub_amount, rule_information10 arrears
727: FROM okc_rules_b
1375: l_lasll_rec.rule_information6 := l_payment_levels_tbl(line_number).amount;
1376: l_lasll_rec.rule_information10 := p_payment_arrears;
1377: l_lasll_rec.rule_information5 := NVL(p_payment_structure, '0');
1378: l_lasll_rec.rule_information13 := l_payment_levels_tbl(line_number).rate;
1379: l_lasll_rec.rule_information2 := fnd_date.date_to_canonical(l_payment_levels_tbl(line_number).start_date);
1380: -- stub information will be null except for the first line ( validation done before)
1381: l_lasll_rec.rule_information7 := l_payment_levels_tbl(line_number).stub_days;
1382: l_lasll_rec.rule_information8 := l_payment_levels_tbl(line_number).stub_amount;
1383:
5192: l_rulv_tbl(2).rule_information1 := 'FULL';
5193: END IF;
5194:
5195: l_rulv_tbl(2).rule_information2 := c_get_guarantors_rec.GUARANTEED_AMOUNT;
5196: l_rulv_tbl(2).rule_information3 := FND_DATE.date_to_canonical(c_get_guarantors_rec.FUNDING_AVAILABLE_FROM);
5197:
5198: l_rulv_tbl(2).std_template_yn := 'N';
5199: l_rulv_tbl(2).warn_yn := 'N';
5200: