APPS.IEX_PROFILE dependencies on AR_PAYMENT_SCHEDULES

Line 51: from ar_payment_schedules aps,

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

Line 72: from ar_payment_schedules aps,

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

Line 97: from ar_payment_schedules aps,

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

Line 121: from ar_payment_schedules aps,

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

Line 144: from ar_payment_schedules aps

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