eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_STAGED_DUNNING dependencies on AR_DUNNING_LETTER_SET_LINES

Line 509: FROM ar_dunning_letter_set_lines dlsl

505: END ;
506: BEGIN
507: SELECT dlsl.dunning_letter_id
508: INTO id
509: FROM ar_dunning_letter_set_lines dlsl
510: WHERE dlsl.dunning_letter_set_id = site.letter_set_id
511: AND help_level BETWEEN dlsl.range_of_dunning_level_from
512: AND dlsl.range_of_dunning_level_to;
513:

Line 695: ,ar_dunning_letter_set_lines dlsl

691: CURSOR last_print IS
692: SELECT c.correspondence_date
693: FROM ar_correspondence_pay_sched cp
694: ,ar_correspondences c
695: ,ar_dunning_letter_set_lines dlsl
696: WHERE cp.payment_schedule_id = ps_id
697: AND c.preliminary_flag = 'N'
698: AND cp.staged_dunning_level is NOT NULL
699: AND dlsl.dunning_letter_set_id = c.reference1

Line 717: FROM ar_dunning_letter_set_lines

713: CLOSE last_print;
714:
715: SELECT min_days_between_dunning
716: INTO min_dunning_days
717: FROM ar_dunning_letter_set_lines
718: WHERE dunning_letter_set_id = o_letter_set_id
719: AND range_of_dunning_level_from <= (NVL(staged_dunning_level, 0)+1)
720: AND range_of_dunning_level_to >= (NVL(staged_dunning_level, 0)+1);
721: