APPS.ARP_AUTO_RULE dependencies on AR_PAYMENT_SCHEDULES

Line 1043: FROM ar_payment_schedules ps,

1039: /* bug 1947192 */
1040: cursor c_update_ps( l_trx_id NUMBER) is
1041: SELECT ps.payment_schedule_id ps_id,
1042: gld.gl_date gl_date
1043: FROM ar_payment_schedules ps,
1044: ra_cust_trx_line_gl_dist gld
1045: WHERE gld.customer_trx_id = l_trx_id
1046: AND gld.account_class = 'REC'
1047: AND gld.account_set_flag = 'N'

Line 1181: UPDATE ar_payment_schedules

1177: FOR i IN c_update_ps(p_trx_id) LOOP
1178: IF PG_DEBUG in ('Y', 'C') THEN
1179: arp_standard.debug('arp_auto_rule.create_other_receivable(): Change Payment Schedule Gl Date');
1180: END IF;
1181: UPDATE ar_payment_schedules
1182: SET gl_date = i.gl_date ,
1183: last_updated_by = arp_standard.profile.user_id,
1184: last_update_date = sysdate
1185: WHERE payment_schedule_id = i.ps_id;