[Home] [Help]
87: WHERE ppta.lease_id = pn_leases.lease_id /*sdm14jul*/
88: AND ppta.lease_id = p_lease_id /*sdm14jul*/
89: AND not exists
90: ( SELECT 'x'
91: FROM pn_payment_items_all a /*sdm14jul*/
92: WHERE a.payment_term_id = ppta.payment_term_id
93: );
94:
95: pt_rec pt_cur%ROWTYPE;
130: AND ppt.payment_term_id = p_paymentTermId
131: AND ppt.frequency_code = 'OT'
132: AND not exists
133: ( SELECT 'x'
134: FROM pn_payment_items_all a /*sdm14jul*/
135: WHERE a.payment_term_id = ppt.payment_term_id
136: );
137: l_paymentScheduleDate DATE := NULL;
138: l_paymentScheduleId NUMBER := NULL;
201: where payment_schedule_id = l_paymentScheduleId;
202: END IF;
203:
204:
205: INSERT INTO pn_payment_items_all /*sdm14jul*/
206: (
207: payment_item_id,
208: last_update_date,
209: last_updated_by,
288: IF (normalize_only = 'Y') THEN
289:
290: iteration_start := 2;
291:
292: DELETE from pn_payment_items_all /*sdm14jul*/
293: WHERE payment_item_type_lookup_code = 'NORMALIZED'
294: AND payment_term_id = pt_rec.payment_term_id;
295:
296: ELSE
333: IF (pt_rec.payment_term_type_code = 'PRE') and (iteration = 1) THEN /* IF A */
334:
335: /* Prepayments */
336:
337: DELETE FROM pn_payment_items_all /*sdm14jul*/
338: WHERE payment_term_id = pt_rec.payment_term_id;
339:
340: rent_sched_date := Trunc(pt_rec.start_date,'MM');
341:
387: );
388:
389: END IF;
390:
391: INSERT INTO pn_payment_items_all /*sdm14jul*/
392: ( payment_item_id,
393: last_update_date,
394: last_updated_by,
395: creation_date,
484: );
485:
486: END IF;
487:
488: INSERT INTO pn_payment_items_all /*sdm14jul*/
489: ( payment_item_id,
490: last_update_date,
491: last_updated_by,
492: creation_date,
537: /* End of CASH Pre-payments */
538:
539: ELSE IF ((pt_rec.frequency_code = 'OT') and (iteration = 1)) THEN /* IF D */
540:
541: DELETE FROM pn_payment_items_all /*sdm14jul*/
542: WHERE payment_term_id = pt_rec.payment_term_id
543: AND payment_item_type_lookup_code = 'NORMALIZED';
544:
545: ------------------------------------------------
550: ELSE IF (iteration = 2) THEN
551:
552: SELECT count(*)
553: INTO actual_items
554: FROM pn_payment_items_all /*sdm14jul*/
555: WHERE payment_term_id = pt_rec.payment_term_id
556: AND actual_amount is NOT NULL
557: AND payment_item_type_lookup_code = 'CASH';
558:
568: Cash base and abates if iteration = 1 */
569:
570: SELECT count(*)
571: INTO items_paid
572: FROM pn_payment_items_all pi, /*sdm14jul*/
573: pn_payment_schedules_all ps /*sdm14jul*/
574: WHERE pi.payment_schedule_id = ps.payment_schedule_id
575: AND pi.payment_term_id = pt_rec.payment_term_id
576: AND pi.payment_item_type_lookup_code = 'CASH'
579: IF (items_paid = 0) or (iteration = 2) THEN /* IF F */
580:
581: IF (iteration = 1) THEN /* IF G */
582:
583: DELETE FROM pn_payment_items_all /*sdm14jul*/
584: WHERE payment_term_id = pt_rec.payment_term_id;
585:
586: ELSE
587:
584: WHERE payment_term_id = pt_rec.payment_term_id;
585:
586: ELSE
587:
588: DELETE FROM pn_payment_items_all /*sdm14jul*/
589: WHERE payment_term_id = pt_rec.payment_term_id
590: AND payment_item_type_lookup_code = 'NORMALIZED';
591:
592: /* Loop and figure out NOCOPY sum of partial months */
668: /* Find total of all cash items */
669:
670: SELECT nvl(sum(actual_amount),0)
671: INTO total_cash
672: FROM pn_payment_items_all /*sdm14jul*/
673: WHERE payment_term_id = pt_rec.payment_term_id
674: AND payment_item_type_lookup_code = 'CASH';
675:
676: /* Set cur_amount to this the normalized per period */
839: ELSE
840: round_amount := amount;
841: END IF;
842:
843: INSERT INTO pn_payment_items_all /*sdm14jul*/
844: (
845: payment_item_id,
846: last_update_date,
847: last_updated_by,
927: END LOOP; /* Loop E */
928:
929: ELSE /* Some items have been paid */
930:
931: DELETE from pn_payment_items_all /*sdm14jul*/
932: WHERE payment_term_id = pt_rec.payment_term_id
933: and payment_item_type_lookup_code = 'NORMALIZED';
934:
935: UPDATE pn_payment_items_all /*sdm14jul*/
931: DELETE from pn_payment_items_all /*sdm14jul*/
932: WHERE payment_term_id = pt_rec.payment_term_id
933: and payment_item_type_lookup_code = 'NORMALIZED';
934:
935: UPDATE pn_payment_items_all /*sdm14jul*/
936: SET actual_amount = cur_amount * period_fraction,
937: estimated_amount = decode(pt_rec.actual_amount,null,
938: cur_estimated_amount * period_fraction,
939: null
954:
955: /* Normalize for estimates and non-BASE or ABATEs */
956: IF (iteration = 2) THEN
957:
958: INSERT INTO pn_payment_items_all /*sdm14jul*/
959: (
960: payment_item_id,
961: last_update_date,
962: last_updated_by,
987: pt_rec.set_of_books_id,
988: pt_rec.currency_code,
989: 1,
990: l_org_id /*sdm14jul*/
991: FROM pn_payment_items_all /*sdm14jul*/
992: WHERE payment_term_id = pt_rec.payment_term_id
993: AND actual_amount is null;
994: END IF;
995: