APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_CORRESPONDENCE_PAY_SCHED

Line 759: FROM ar_correspondence_pay_sched cps

755: OR ps.selected_for_receipt_batch_id IS NOT NULL
756: OR exists
757: (
758: SELECT 'dunned'
759: FROM ar_correspondence_pay_sched cps
760: WHERE cps.payment_schedule_id =
761: ps.payment_schedule_id
762: )
763: );

Line 1897: IN ar_correspondence_pay_sched.payment_schedule_id%type)

1893: | |
1894: | 01-JUN-1998 Yangya Kong Created Bug Fix : 627071 |
1895: +===========================================================================*/
1896: FUNCTION get_dunning_date_last (p_payment_schedule_id
1897: IN ar_correspondence_pay_sched.payment_schedule_id%type)
1898:
1899: RETURN DATE is
1900:
1901: l_dunning_date_last ar_correspondences.correspondence_date%type;

Line 1908: ar_correspondence_pay_sched arcps

1904:
1905: select MAX(arc.correspondence_date)
1906: into l_dunning_date_last
1907: from ar_correspondences arc,
1908: ar_correspondence_pay_sched arcps
1909: where arcps.payment_schedule_id = p_payment_schedule_id
1910: and arc.correspondence_id = arcps.correspondence_id
1911: and nvl(arc.preliminary_flag,'N') = 'N';
1912: