APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_CORRESPONDENCES

Line 1991: l_dunning_date_last ar_correspondences.correspondence_date%type;

1987: IN ar_correspondence_pay_sched.payment_schedule_id%type)
1988:
1989: RETURN DATE is
1990:
1991: l_dunning_date_last ar_correspondences.correspondence_date%type;
1992:
1993: BEGIN
1994:
1995: select MAX(arc.correspondence_date)

Line 1997: from ar_correspondences arc,

1993: BEGIN
1994:
1995: select MAX(arc.correspondence_date)
1996: into l_dunning_date_last
1997: from ar_correspondences arc,
1998: ar_correspondence_pay_sched arcps
1999: where arcps.payment_schedule_id = p_payment_schedule_id
2000: and arc.correspondence_id = arcps.correspondence_id
2001: and nvl(arc.preliminary_flag,'N') = 'N';