APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 358: pn_payment_schedules_all sched

354: SELECT 'Y'
355: FROM DUAL
356: WHERE EXISTS( SELECT payment_item_id
357: FROM pn_payment_items_all items,
358: pn_payment_schedules_all sched
359: WHERE sched.payment_schedule_id = items.payment_schedule_id
360: AND items.payment_term_id = p_payment_term_id
361: AND sched.payment_status_lookup_code = 'APPROVED');
362:

Line 444: DELETE FROM pn_payment_schedules_all pps

440:
441: DELETE FROM pn_payment_items_all
442: WHERE payment_term_id =il_rec.payment_term_id;
443:
444: DELETE FROM pn_payment_schedules_all pps
445: WHERE not exists(SELECT 1
446: FROM PN_PAYMENT_ITEMS_ALL ppi
447: WHERE ppi.payment_schedule_id=pps.payment_schedule_id)
448: AND pps.lease_id=il_rec.lease_id;

Line 1110: FROM pn_payment_schedules_all sched,

1106: IS
1107:
1108: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1109: SELECT term.payment_term_id
1110: FROM pn_payment_schedules_all sched,
1111: pn_index_leases_all ilease,
1112: pn_payment_terms_all term,
1113: pn_payment_items_all item,
1114: pn_index_lease_periods_all period

Line 1154: DELETE FROM pn_payment_schedules_all sched

1150: WHERE term.index_period_id = iperiod.index_period_id
1151: AND iperiod.index_lease_id = p_index_lease_id
1152: AND term.index_period_id IS NOT NULL);
1153:
1154: DELETE FROM pn_payment_schedules_all sched
1155: WHERE sched.payment_status_lookup_code = 'DRAFT'
1156: AND NOT EXISTS( SELECT payment_schedule_id
1157: FROM pn_payment_items_all item
1158: WHERE item.payment_schedule_id = sched.payment_schedule_id);

Line 1562: FROM pn_payment_schedules_all pps

1558: BEGIN
1559:
1560: SELECT '1'
1561: INTO v_approved_sch
1562: FROM pn_payment_schedules_all pps
1563: WHERE pps.payment_schedule_id IN
1564: (SELECT ppt.payment_schedule_id
1565: FROM pn_payment_items_all ppt
1566: WHERE ppt.payment_term_id = rec_payment_terms.payment_term_id

Line 2435: FROM pn_payment_schedules_all pps

2431: AND changes.lease_change_id = details.lease_change_id;
2432:
2433: CURSOR get_last_appr_schd_dt (p_lease_id NUMBER) IS
2434: SELECT MAX(pps.schedule_date) lst_schedule_date
2435: FROM pn_payment_schedules_all pps
2436: WHERE pps.payment_status_lookup_code = 'APPROVED'
2437: AND pps.lease_id = p_lease_id;
2438:
2439: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS

Line 2653: FROM pn_payment_schedules_all

2649:
2650: CURSOR approved_sched_exist_cur(p_payment_term_id IN NUMBER)
2651: IS
2652: SELECT payment_schedule_id
2653: FROM pn_payment_schedules_all
2654: WHERE lease_id IN ( SELECT lease_id
2655: FROM pn_payment_terms_all
2656: WHERE payment_term_id = p_payment_term_id)
2657: AND payment_status_lookup_code = 'APPROVED'

Line 2670: FROM pn_payment_schedules_all pps

2666: AND ppi.payment_item_type_lookup_code = 'CASH';
2667:
2668: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS
2669: SELECT pps.payment_schedule_id
2670: FROM pn_payment_schedules_all pps
2671: WHERE pps.schedule_date = p_sched_date
2672: AND pps.lease_id IN (SELECT lease_id FROM pn_index_leases_all
2673: WHERE index_lease_id = p_index_lease_id)
2674: AND pps.payment_status_lookup_code = 'DRAFT';

Line 2805: FROM pn_payment_schedules_all

2801:
2802: DELETE pn_payment_items_all
2803: WHERE payment_schedule_id IN
2804: (SELECT payment_schedule_id
2805: FROM pn_payment_schedules_all
2806: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2807: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2808: AND schedule_date > p_new_termination_date
2809: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))

Line 2919: FROM pn_payment_schedules_all

2915:
2916: DELETE pn_payment_items_all
2917: WHERE payment_schedule_id IN
2918: (SELECT payment_schedule_id
2919: FROM pn_payment_schedules_all
2920: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2921: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2922: AND schedule_date > p_new_termination_date
2923: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))