APPS.AR_PURGE dependencies on AR_CORRESPONDENCE_PAY_SCHED

Line 3590: ar_correspondence_pay_sched sched

3586: WHERE corr.correspondence_id IN
3587: (
3588: SELECT sched.correspondence_id
3589: FROM ar_payment_schedules ps,
3590: ar_correspondence_pay_sched sched
3591: WHERE ps.customer_trx_id = p_entity_id
3592: AND ps.payment_schedule_id =
3593: sched.payment_schedule_id
3594: ) ;

Line 3598: DELETE FROM ar_correspondence_pay_sched sched

3594: ) ;
3595: --
3596: /* bug2021662 :add RETURNING to get deleted correspondence_id
3597: */
3598: DELETE FROM ar_correspondence_pay_sched sched
3599: WHERE payment_schedule_id IN
3600: (
3601: SELECT payment_schedule_id
3602: FROM ar_payment_schedules

Line 3612: FROM ar_correspondence_pay_sched sched,

3608: DELETE FROM ar_correspondences corr
3609: WHERE corr.correspondence_id NOT IN
3610: (
3611: SELECT sched.correspondence_id
3612: FROM ar_correspondence_pay_sched sched,
3613: ar_payment_schedules ps
3614: WHERE ps.customer_trx_id = p_entity_id
3615: AND ps.payment_schedule_id =
3616: sched.payment_schedule_id

Line 3628: FROM ar_correspondence_pay_sched sched

3624: DELETE FROM ar_correspondences corr
3625: WHERE not exists
3626: (
3627: SELECT 'there are children records'
3628: FROM ar_correspondence_pay_sched sched
3629: WHERE corr.correspondence_id = sched.correspondence_id )
3630: AND corr.correspondence_id = del_cid(l_corr_row) ;
3631: END IF;
3632: --