APPS.PN_MODIFY_PMT_SCHED dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 108: FROM pn_payment_schedules_all ps, /*sdm14jul*/

104: END IF;
105:
106: SELECT count(*)
107: INTO items_paid
108: FROM pn_payment_schedules_all ps, /*sdm14jul*/
109: pn_payment_items_all pi /*sdm14jul*/
110: WHERE ps.payment_schedule_id = pi.payment_schedule_id
111: AND pi.payment_term_id = pt_rec.payment_term_id
112: AND ps.payment_status_lookup_code <> 'DRAFT'

Line 149: FROM pn_payment_schedules_all ps, /*sdm14jul*/

145: BEGIN
146:
147: SELECT ps.payment_status_lookup_code, pi.payment_item_id
148: INTO sched_status, pi_id
149: FROM pn_payment_schedules_all ps, /*sdm14jul*/
150: pn_payment_items_all pi /*sdm14jul*/
151: WHERE pi.payment_schedule_id = ps.payment_schedule_id
152: AND pi.due_date = item_to_change_date
153: AND pi.payment_term_id = pt_rec.payment_term_id

Line 213: FROM pn_payment_schedules_all /*sdm14jul*/

209: WHERE payment_term_id = pt_rec.payment_term_id
210: AND due_date > item_to_change_date
211: AND payment_item_type_lookup_code = 'CASH'
212: AND payment_schedule_id in (SELECT payment_schedule_id
213: FROM pn_payment_schedules_all /*sdm14jul*/
214: WHERE payment_status_lookup_code = 'DRAFT'
215: AND lease_id = pt_rec.lease_id
216: );
217:

Line 266: FROM pn_payment_schedules_all /*sdm14jul*/

262: /* ------------------ Renormalize ------------------------- */
263:
264: SELECT max(schedule_date)
265: INTO min_sched_date
266: FROM pn_payment_schedules_all /*sdm14jul*/
267: WHERE lease_id = pt_rec.lease_id
268: AND payment_status_lookup_code <> 'DRAFT';
269:
270: IF min_sched_date is not null THEN

Line 417: FROM pn_payment_schedules_all /*sdm14jul*/

413: /* See if a payment schedule exists for this lease and gl period */
414:
415: SELECT max(payment_schedule_id)
416: INTO ps_id
417: FROM pn_payment_schedules_all /*sdm14jul*/
418: WHERE lease_id = pt_rec.lease_id
419: AND schedule_date = rent_sched_date;
420:
421: IF ps_id is null THEN

Line 431: FROM pn_payment_schedules_all

427: IF (rent_sched_date < min_sched_date) THEN
428:
429: /*sdm14jul*/
430: SELECT org_id INTO l_org_id
431: FROM pn_payment_schedules_all
432: WHERE payment_schedule_id = ps_id;
433:
434:
435: INSERT INTO pn_payment_schedules_all /*sdm14jul*/

Line 435: INSERT INTO pn_payment_schedules_all /*sdm14jul*/

431: FROM pn_payment_schedules_all
432: WHERE payment_schedule_id = ps_id;
433:
434:
435: INSERT INTO pn_payment_schedules_all /*sdm14jul*/
436: (
437: payment_schedule_id,
438: last_update_date,
439: last_updated_by,

Line 463: INSERT INTO pn_payment_schedules_all /*sdm14jul*/

459: );
460:
461: ELSE
462:
463: INSERT INTO pn_payment_schedules_all /*sdm14jul*/
464: (
465: payment_schedule_id,
466: last_update_date,
467: last_updated_by,

Line 636: DELETE FROM pn_payment_schedules_all ps /*sdm14jul*/

632: END LOOP;
633:
634: CLOSE pt_cur;
635:
636: DELETE FROM pn_payment_schedules_all ps /*sdm14jul*/
637: WHERE ps.lease_id = pn_lease_id
638: AND NOT exists (SELECT 'x'
639: FROM pn_payment_items_all pi /*sdm14jul*/
640: WHERE pi.payment_schedule_id = ps.payment_schedule_id);