APPS.ARPT_SQL_FUNC_UTIL dependencies on AR_CORRESPONDENCE_PAY_SCHED

Line 827: FROM ar_correspondence_pay_sched cps

823: OR ps.selected_for_receipt_batch_id IS NOT NULL
824: OR exists
825: (
826: SELECT 'dunned'
827: FROM ar_correspondence_pay_sched cps
828: WHERE cps.payment_schedule_id =
829: ps.payment_schedule_id
830: )
831: );

Line 1987: IN ar_correspondence_pay_sched.payment_schedule_id%type)

1983: | |
1984: | 01-JUN-1998 Yangya Kong Created Bug Fix : 627071 |
1985: +===========================================================================*/
1986: FUNCTION get_dunning_date_last (p_payment_schedule_id
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;

Line 1998: ar_correspondence_pay_sched arcps

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';
2002: