APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 353: pn_payment_schedules_all sched

349: SELECT 'Y'
350: FROM DUAL
351: WHERE EXISTS( SELECT payment_item_id
352: FROM pn_payment_items_all items,
353: pn_payment_schedules_all sched
354: WHERE sched.payment_schedule_id = items.payment_schedule_id
355: AND items.payment_term_id = p_payment_term_id
356: AND sched.payment_status_lookup_code = 'APPROVED');
357:

Line 439: DELETE FROM pn_payment_schedules_all pps

435:
436: DELETE FROM pn_payment_items_all
437: WHERE payment_term_id =il_rec.payment_term_id;
438:
439: DELETE FROM pn_payment_schedules_all pps
440: WHERE not exists(SELECT 1
441: FROM PN_PAYMENT_ITEMS_ALL ppi
442: WHERE ppi.payment_schedule_id=pps.payment_schedule_id)
443: AND pps.lease_id=il_rec.lease_id;

Line 1102: FROM pn_payment_schedules_all sched,

1098: IS
1099:
1100: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1101: SELECT term.payment_term_id
1102: FROM pn_payment_schedules_all sched,
1103: pn_index_leases_all ilease,
1104: pn_payment_terms_all term,
1105: pn_payment_items_all item,
1106: pn_index_lease_periods_all period

Line 1146: DELETE FROM pn_payment_schedules_all sched

1142: WHERE term.index_period_id = iperiod.index_period_id
1143: AND iperiod.index_lease_id = p_index_lease_id
1144: AND term.index_period_id IS NOT NULL);
1145:
1146: DELETE FROM pn_payment_schedules_all sched
1147: WHERE sched.payment_status_lookup_code = 'DRAFT'
1148: AND NOT EXISTS( SELECT payment_schedule_id
1149: FROM pn_payment_items_all item
1150: WHERE item.payment_schedule_id = sched.payment_schedule_id);

Line 1554: FROM pn_payment_schedules_all pps

1550: BEGIN
1551:
1552: SELECT '1'
1553: INTO v_approved_sch
1554: FROM pn_payment_schedules_all pps
1555: WHERE pps.payment_schedule_id IN
1556: (SELECT ppt.payment_schedule_id
1557: FROM pn_payment_items_all ppt
1558: WHERE ppt.payment_term_id = rec_payment_terms.payment_term_id

Line 2309: FROM pn_payment_schedules_all pps

2305: AND changes.lease_change_id = details.lease_change_id;
2306:
2307: CURSOR get_last_appr_schd_dt (p_lease_id NUMBER) IS
2308: SELECT MAX(pps.schedule_date) lst_schedule_date
2309: FROM pn_payment_schedules_all pps
2310: WHERE pps.payment_status_lookup_code = 'APPROVED'
2311: AND pps.lease_id = p_lease_id;
2312:
2313: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS

Line 2509: FROM pn_payment_schedules_all

2505:
2506: CURSOR approved_sched_exist_cur(p_payment_term_id IN NUMBER)
2507: IS
2508: SELECT payment_schedule_id
2509: FROM pn_payment_schedules_all
2510: WHERE lease_id IN ( SELECT lease_id
2511: FROM pn_payment_terms_all
2512: WHERE payment_term_id = p_payment_term_id)
2513: AND payment_status_lookup_code = 'APPROVED'

Line 2526: FROM pn_payment_schedules_all pps

2522: AND ppi.payment_item_type_lookup_code = 'CASH';
2523:
2524: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS
2525: SELECT pps.payment_schedule_id
2526: FROM pn_payment_schedules_all pps
2527: WHERE pps.schedule_date = p_sched_date
2528: AND pps.lease_id IN (SELECT lease_id FROM pn_index_leases_all
2529: WHERE index_lease_id = p_index_lease_id)
2530: AND pps.payment_status_lookup_code = 'DRAFT';

Line 2660: FROM pn_payment_schedules_all

2656:
2657: DELETE pn_payment_items_all
2658: WHERE payment_schedule_id IN
2659: (SELECT payment_schedule_id
2660: FROM pn_payment_schedules_all
2661: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2662: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2663: AND schedule_date > p_new_termination_date
2664: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))

Line 2773: FROM pn_payment_schedules_all

2769:
2770: DELETE pn_payment_items_all
2771: WHERE payment_schedule_id IN
2772: (SELECT payment_schedule_id
2773: FROM pn_payment_schedules_all
2774: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2775: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2776: AND schedule_date > p_new_termination_date
2777: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))