DBA Data[Home] [Help]

APPS.ARP_PROCESS_CREDIT dependencies on AR_PAYMENT_SCHEDULES

Line 1087: FROM ar_payment_schedules

1083: | get balances from the payment schedule, if they exist |
1084: +--------------------------------------------------------*/
1085: SELECT count(*)
1086: INTO l_count
1087: FROM ar_payment_schedules
1088: WHERE customer_trx_id = p_prev_customer_trx_id;
1089:
1090: IF (l_count > 0)
1091: THEN

Line 1100: FROM ar_payment_schedules

1096: INTO l_trx_balance_due,
1097: l_line_balance_due,
1098: l_tax_balance_due,
1099: l_freight_balance_due
1100: FROM ar_payment_schedules
1101: WHERE customer_trx_id = p_prev_customer_trx_id;
1102:
1103: /*---------------------------------------------------------+
1104: | For CMs against a child of a deposit, add the amount of |