APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_CORRESPONDENCES

Line 1901: l_dunning_date_last ar_correspondences.correspondence_date%type;

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;
1902:
1903: BEGIN
1904:
1905: select MAX(arc.correspondence_date)

Line 1907: from ar_correspondences arc,

1903: BEGIN
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';