APPS.AR_PURGE dependencies on AR_CORRESPONDENCE_PAY_SCHED

Line 4455: ar_correspondence_pay_sched sched

4451: WHERE corr.correspondence_id IN
4452: (
4453: SELECT sched.correspondence_id
4454: FROM ar_payment_schedules ps,
4455: ar_correspondence_pay_sched sched
4456: WHERE ps.customer_trx_id = p_entity_id
4457: AND ps.payment_schedule_id =
4458: sched.payment_schedule_id
4459: ) ;

Line 4463: DELETE FROM ar_correspondence_pay_sched sched

4459: ) ;
4460: --
4461: /* bug2021662 :add RETURNING to get deleted correspondence_id
4462: */
4463: DELETE FROM ar_correspondence_pay_sched sched
4464: WHERE payment_schedule_id IN
4465: (
4466: SELECT payment_schedule_id
4467: FROM ar_payment_schedules

Line 4477: FROM ar_correspondence_pay_sched sched,

4473: DELETE FROM ar_correspondences corr
4474: WHERE corr.correspondence_id NOT IN
4475: (
4476: SELECT sched.correspondence_id
4477: FROM ar_correspondence_pay_sched sched,
4478: ar_payment_schedules ps
4479: WHERE ps.customer_trx_id = p_entity_id
4480: AND ps.payment_schedule_id =
4481: sched.payment_schedule_id

Line 4493: FROM ar_correspondence_pay_sched sched

4489: DELETE FROM ar_correspondences corr
4490: WHERE not exists
4491: (
4492: SELECT 'there are children records'
4493: FROM ar_correspondence_pay_sched sched
4494: WHERE corr.correspondence_id = sched.correspondence_id )
4495: AND corr.correspondence_id = del_cid(l_corr_row) ;
4496: END IF;
4497: --