DBA Data[Home] [Help]

APPS.ARI_DB_UTILITIES dependencies on AR_PAYMENT_SCHEDULES

Line 554: from ar_payment_schedules ps,

550: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
551: decode(v_bucket_category,
552: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
553: 1))) b6
554: from ar_payment_schedules ps,
555: ar_irec_user_acct_sites_all AcctSites
556: where ps.status = 'OP'
557: and AcctSites.user_id=FND_GLOBAL.USER_ID()
558: and AcctSites.customer_id=ps.customer_id

Line 707: from ar_payment_schedules ps,

703: * decode(nvl(ps.amount_adjusted_pending,0), 0, 1,
704: decode(v_bucket_category,
705: 'PENDADJ_ONLY', 0, 'DISPUTE_PENDADJ', 0,
706: 1))) b6
707: from ar_payment_schedules ps,
708: ar_irec_user_acct_sites_all AcctSites
709: where ps.status = 'OP'
710: and AcctSites.user_id=FND_GLOBAL.USER_ID()
711: and AcctSites.customer_id=ps.customer_id