APPS.ARP_STAGED_DUNNING dependencies on AR_PAYMENT_SCHEDULES

Line 50: TYPE leveltab IS TABLE OF ar_payment_schedules.staged_dunning_level%TYPE

46: ,letter_count IN OUT NOCOPY NUMBER
47: ,single_letter_flag IN VARCHAR2) RETURN BOOLEAN AS
48:
49: -- define array to store distinct dunning levels
50: TYPE leveltab IS TABLE OF ar_payment_schedules.staged_dunning_level%TYPE
51: INDEX BY BINARY_INTEGER;
52: level_tab leveltab;
53:
54: -- define cursor for the dynamic SELECT of the open payment schedules

Line 104: ' FROM ar_payment_schedules ps';

100: ',ps.amount_due_remaining' ||
101: ',fnd_date.canonical_to_date(:b_dun_date) - ps.due_date ' ||
102: ',ps.staged_dunning_level' ||
103: ',ps.dunning_level_override_date' ||
104: ' FROM ar_payment_schedules ps';
105:
106: sql_statement_s :=
107: 'SELECT ps.invoice_currency_code, ' ||
108: ' sum(ps.amount_due_remaining) ' ||

Line 109: ' FROM ar_payment_schedules ps';

105:
106: sql_statement_s :=
107: 'SELECT ps.invoice_currency_code, ' ||
108: ' sum(ps.amount_due_remaining) ' ||
109: ' FROM ar_payment_schedules ps';
110:
111: if parameter.transaction_type_from is not null
112: OR
113: parameter.transaction_type_to is not null then