[Home] [Help]
644: FROM ar_payment_schedules ps,
645: hz_cust_accounts ca,
646: -- Begin fix bug #5261855-jypark-06/16/2006-change to based table for performance
647: -- iex_delinquencies del,
648: iex_delinquencies_all del,
649: -- End fix bug #5261855-jypark-06/16/2006-change to based table for performance
650: ar_system_parameters sp
651: WHERE ca.party_id = l_party_id
652: AND ps.customer_id = ca.cust_account_id
671: SUM(DECODE(del.status, 'DELINQUENT', NVL(acctd_amount_due_remaining,0),
672: 'PREDELINQUENT', NVL(acctd_amount_due_remaining,0),0)) overdue_amt
673: FROM ar_payment_schedules ps,
674: hz_cust_accounts ca,
675: iex_delinquencies_all del,
676: ar_system_parameters sp
677: WHERE ca.party_id = l_party_id
678: AND ps.customer_id = ca.cust_account_id
679: AND ps.status = 'OP'
700: where ca.party_id = l_party_id
701: and ps.customer_id = ca.cust_account_id
702: and ps.status = 'OP')
703: and cm.status='PENDING_APPROVAL'
704: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531
705: and transaction_id = cm.customer_trx_id);
706:
707: x_object_info_rec.amount_overdue := x_object_info_rec.amount_overdue - l_amount_in_dispute;
708: end if;
758: where ps.customer_id = p_object_id
759: and ps.org_id = parm.org_id
760: and ps.status = 'OP')
761: and cm.status='PENDING_APPROVAL'
762: and not exists (select 1 from iex_delinquencies_all where status in ('CURRENT','CLOSE') -- bug 14499531
763: and transaction_id = cm.customer_trx_id);
764:
765: x_object_info_rec.amount_overdue := x_object_info_rec.amount_overdue - l_amount_in_dispute;
766: end if;