APPS.PN_VAR_RENT_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 2691: DELETE FROM pn_payment_schedules_all

2687:
2688: -- Added by Sathesh K 15-APR-2005 to delete schedules and items records
2689: -- Mac Trac Issue M30106
2690:
2691: DELETE FROM pn_payment_schedules_all
2692: WHERE payment_schedule_id IN
2693: (SELECT payment_schedule_id
2694: FROM pn_payment_items_all
2695: WHERE NVL(export_to_ar_flag,'N') <>'Y'

Line 3564: DELETE FROM pn_payment_schedules_all

3560: )
3561: )
3562: AND export_to_ar_flag <>'Y' ;
3563:
3564: DELETE FROM pn_payment_schedules_all
3565: WHERE payment_schedule_id IN
3566: (SELECT payment_schedule_id
3567: FROM pn_payment_items_all
3568: WHERE export_to_ar_flag <>'Y'

Line 4429: pn_payment_schedules_all sched

4425: FROM pn_payment_items_ALL item,
4426: pn_payment_terms_ALL term,
4427: pn_var_periods_ALL per,
4428: pn_var_rents_ALL var,
4429: pn_payment_schedules_all sched
4430: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4431: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4432: AND term.lease_id = var.lease_id
4433: AND var.var_rent_id = p_var_rent_id

Line 4453: pn_payment_schedules_all sched

4449: FROM pn_payment_items_ALL item,
4450: pn_payment_terms_ALL term,
4451: pn_var_periods_ALL per,
4452: pn_var_rents_ALL var,
4453: pn_payment_schedules_all sched
4454: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4455: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4456: AND term.lease_id = var.lease_id
4457: AND var.var_rent_id = p_var_rent_id