APPS.IEX_PROFILE dependencies on AR_PAYMENT_SCHEDULES

Line 50: from ar_payment_schedules aps,

46: SUM(DECODE(aps.status, 'CL', DECODE(SIGN(aps.actual_date_closed - aps.due_date), 1, 1, 0), 0)) -- Late Installements
47: INTO p_unpaid_inv,
48: p_ontime_inv,
49: p_late_inv
50: from ar_payment_schedules aps,
51: hz_cust_accounts hzca
52: where aps.customer_id = hzca.cust_account_id
53: and aps.class IN ('INV', 'DM', 'CB')
54: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to

Line 71: from ar_payment_schedules aps,

67: SUM(DECODE(aps.status, 'CL', DECODE(SIGN(aps.actual_date_closed - aps.due_date), 1, 1, 0), 0)) -- Late Installements
68: INTO p_unpaid_inv,
69: p_ontime_inv,
70: p_late_inv
71: from ar_payment_schedules aps,
72: hz_cust_accounts hzca
73: where aps.customer_id = hzca.cust_account_id
74: and aps.class IN ('INV', 'DM', 'CB')
75: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to

Line 96: from ar_payment_schedules aps,

92: SUM(DECODE(aps.status, 'CL', DECODE(SIGN(aps.actual_date_closed - aps.due_date), 1, 1, 0), 0)) -- Late Installements
93: INTO p_unpaid_inv,
94: p_ontime_inv,
95: p_late_inv
96: from ar_payment_schedules aps,
97: hz_cust_accounts hzca
98: where aps.customer_id = hzca.cust_account_id
99: and aps.class IN ('INV', 'DM', 'CB')
100: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to

Line 120: from ar_payment_schedules aps,

116: SUM(DECODE(aps.status, 'CL', DECODE(SIGN(aps.actual_date_closed - aps.due_date), 1, 1, 0), 0)) -- Late Installements
117: INTO p_unpaid_inv,
118: p_ontime_inv,
119: p_late_inv
120: from ar_payment_schedules aps,
121: iex_delinquencies del
122: where aps.class IN ('INV', 'DM', 'CB')
123: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
124: and del.payment_schedule_id = aps.payment_schedule_id

Line 143: from ar_payment_schedules aps

139: SUM(DECODE(aps.status, 'CL', DECODE(SIGN(aps.actual_date_closed - aps.due_date), 1, 1, 0), 0)) -- Late Installements
140: INTO p_unpaid_inv,
141: p_ontime_inv,
142: p_late_inv
143: from ar_payment_schedules aps
144: where aps.class IN ('INV', 'DM', 'CB')
145: and aps.due_date between g_curr_rec.past_year_from and g_curr_rec.past_year_to
146: and aps.customer_site_use_id = p_filter_id;
147: EXCEPTION