[Home] [Help]
1117: if l_strategy_rec.strategy_level = 10 then
1118:
1119: SELECT count(1)
1120: into l_unpro_dels
1121: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
1122: WHERE del.party_cust_id=l_strategy_rec.object_id
1123: AND ps.payment_schedule_id = del.payment_schedule_id
1124: AND ps.status = 'OP'
1125: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1149: elsif l_strategy_rec.strategy_level = 20 then
1150:
1151: SELECT count(1)
1152: into l_unpro_dels
1153: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
1154: WHERE del.cust_account_id=l_strategy_rec.object_id
1155: AND ps.payment_schedule_id = del.payment_schedule_id
1156: AND ps.status = 'OP'
1157: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1181: elsif l_strategy_rec.strategy_level = 30 then
1182:
1183: SELECT count(1)
1184: into l_unpro_dels
1185: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
1186: WHERE del.customer_site_use_id=l_strategy_rec.object_id
1187: AND ps.payment_schedule_id = del.payment_schedule_id
1188: AND ps.status = 'OP'
1189: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
1213: else
1214:
1215: SELECT count(1)
1216: into l_unpro_dels
1217: FROM ar_payment_schedules_all ps, iex_delinquencies_all del
1218: WHERE del.delinquency_id=l_strategy_rec.object_id
1219: AND ps.payment_schedule_id = del.payment_schedule_id
1220: AND ps.status = 'OP'
1221: AND del.status IN ('DELINQUENT', 'PREDELINQUENT')
3705: aps.trx_number TRANSACTION_NUMBER,
3706: b.account_number,
3707: c.location
3708: from iex_delinquencies_all del,
3709: ar_payment_schedules_all aps ,
3710: hz_parties p,
3711: iex_strategies a,
3712: hz_cust_accounts b,
3713: hz_cust_site_uses_all c