APPS.IEX_DELINQUENCY_PUB dependencies on IEX_DUNNINGS

Line 2621: UPDATE iex_dunnings idun

2617: END IF;
2618:
2619: if dunning_level in ('ALL', 'DELINQUENCY') then
2620: Begin
2621: UPDATE iex_dunnings idun
2622: set status = 'CLOSE'
2623: where idun.dunning_level = 'DELINQUENCY'
2624: and idun.status = 'OPEN'
2625: and EXISTS

Line 2661: UPDATE iex_dunnings idun

2657: if dunning_level in ('ALL', 'BILL_TO') then
2658: Begin
2659:
2660:
2661: UPDATE iex_dunnings idun
2662: set status = 'CLOSE'
2663: where idun.dunning_level = 'BILL_TO'
2664: and idun.status = 'OPEN'
2665: and dunning_object_id IN

Line 2706: UPDATE iex_dunnings idun

2702: -- clchang updated 04/18/2003 for BILL_TO level -- end
2703:
2704: if dunning_level in ('ALL', 'ACCOUNT') then
2705: Begin
2706: UPDATE iex_dunnings idun
2707: set status = 'CLOSE'
2708: where idun.dunning_level = 'ACCOUNT'
2709: and idun.status = 'OPEN'
2710: and dunning_object_id IN

Line 2748: UPDATE iex_dunnings idun

2744:
2745: -- BEGIN jsanju for 4505461 -change sql stmt
2746:
2747: /*
2748: UPDATE iex_dunnings idun
2749: set status = 'CLOSE'
2750: where idun.dunning_level = 'CUSTOMER'
2751: and idun.status = 'OPEN'
2752: and dunning_object_id IN

Line 2761: UPDATE IEX_DUNNINGS IDUN

2757: FROM IEX_DELINQUENCIES id2
2758: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2759: and id2.party_cust_id = id.party_cust_id)) ;
2760: */
2761: UPDATE IEX_DUNNINGS IDUN
2762: SET STATUS = 'CLOSE'
2763: WHERE IDUN.DUNNING_LEVEL = 'CUSTOMER'
2764: AND IDUN.STATUS = 'OPEN'
2765: and not exists (SELECT 'x'