APPS.IBY_EVAL_AR_FACTORS_PKG dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 125: from ar_payment_schedules_all

121: ** Get the debit Balance
122: */
123: cursor c_get_debit_balance(ci_customer_id in number) is
124: select nvl(sum(amount_due_remaining),0)
125: from ar_payment_schedules_all
126: where customer_id = ci_customer_id and
127: class in ('DM','INV') and
128: status = 'OP';
129:

Line 135: from ar_payment_schedules_all

131: ** Get Credit Balance
132: */
133: cursor c_get_credit_balance(ci_customer_id in number) is
134: select nvl(sum(amount_due_remaining),0)
135: from ar_payment_schedules_all
136: where customer_id = ci_customer_id and
137: class in ('CM') and
138: status = 'OP';
139: /*

Line 145: ar_payment_schedules_all ps,

141: */
142: cursor c_get_on_account_cash(ci_customer_id in number) is
143: select nvl(sum(decode(app.status,'ACC',(-1*app.amount_applied_from),0)),0)
144: from ar_receivable_applications_all app,
145: ar_payment_schedules_all ps,
146: gl_code_combinations cc
147: where ps.customer_id = ci_customer_id and
148: ps.cash_receipt_id = app.cash_receipt_id and
149: nvl(app.confirmed_flag ,'Y') = 'Y' and

Line 159: ar_payment_schedules_all ps,

155: */
156: cursor c_get_unapplied_cash(ci_customer_id in number) is
157: select nvl(sum(decode(app.status,'UNAPP',(-1*app.amount_applied_from),0)),0)
158: from ar_receivable_applications_all app,
159: ar_payment_schedules_all ps,
160: gl_code_combinations cc
161: where ps.customer_id = ci_customer_id and
162: ps.cash_receipt_id = app.cash_receipt_id and
163: nvl(app.confirmed_flag,'Y') = 'Y' and