APPS.PN_VAR_RENT_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 2695: DELETE FROM pn_payment_schedules_all

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

Line 3568: DELETE FROM pn_payment_schedules_all

3564: )
3565: )
3566: AND export_to_ar_flag <>'Y' ;
3567:
3568: DELETE FROM pn_payment_schedules_all
3569: WHERE payment_schedule_id IN
3570: (SELECT payment_schedule_id
3571: FROM pn_payment_items_all
3572: WHERE export_to_ar_flag <>'Y'

Line 4433: pn_payment_schedules_all sched

4429: FROM pn_payment_items_ALL item,
4430: pn_payment_terms_ALL term,
4431: pn_var_periods_ALL per,
4432: pn_var_rents_ALL var,
4433: pn_payment_schedules_all sched
4434: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4435: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4436: AND term.lease_id = var.lease_id
4437: AND var.var_rent_id = p_var_rent_id

Line 4457: pn_payment_schedules_all sched

4453: FROM pn_payment_items_ALL item,
4454: pn_payment_terms_ALL term,
4455: pn_var_periods_ALL per,
4456: pn_var_rents_ALL var,
4457: pn_payment_schedules_all sched
4458: WHERE item.PAYMENT_TERM_ID = term.PAYMENT_TERM_ID
4459: AND sched.PAYMENT_SCHEDULE_ID = item.PAYMENT_SCHEDULE_ID
4460: AND term.lease_id = var.lease_id
4461: AND var.var_rent_id = p_var_rent_id