APPS.IEX_DELINQUENCY_PUB dependencies on IEX_DUNNINGS

Line 2544: UPDATE iex_dunnings idun

2540: END IF;
2541:
2542: if dunning_level in ('ALL', 'DELINQUENCY') then
2543: Begin
2544: UPDATE iex_dunnings idun
2545: set status = 'CLOSE'
2546: where idun.dunning_level = 'DELINQUENCY'
2547: and idun.status = 'OPEN'
2548: and EXISTS

Line 2584: UPDATE iex_dunnings idun

2580: if dunning_level in ('ALL', 'BILL_TO') then
2581: Begin
2582:
2583:
2584: UPDATE iex_dunnings idun
2585: set status = 'CLOSE'
2586: where idun.dunning_level = 'BILL_TO'
2587: and idun.status = 'OPEN'
2588: and dunning_object_id IN

Line 2629: UPDATE iex_dunnings idun

2625: -- clchang updated 04/18/2003 for BILL_TO level -- end
2626:
2627: if dunning_level in ('ALL', 'ACCOUNT') then
2628: Begin
2629: UPDATE iex_dunnings idun
2630: set status = 'CLOSE'
2631: where idun.dunning_level = 'ACCOUNT'
2632: and idun.status = 'OPEN'
2633: and dunning_object_id IN

Line 2671: UPDATE iex_dunnings idun

2667:
2668: -- BEGIN jsanju for 4505461 -change sql stmt
2669:
2670: /*
2671: UPDATE iex_dunnings idun
2672: set status = 'CLOSE'
2673: where idun.dunning_level = 'CUSTOMER'
2674: and idun.status = 'OPEN'
2675: and dunning_object_id IN

Line 2684: UPDATE IEX_DUNNINGS IDUN

2680: FROM IEX_DELINQUENCIES id2
2681: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2682: and id2.party_cust_id = id.party_cust_id)) ;
2683: */
2684: UPDATE IEX_DUNNINGS IDUN
2685: SET STATUS = 'CLOSE'
2686: WHERE IDUN.DUNNING_LEVEL = 'CUSTOMER'
2687: AND IDUN.STATUS = 'OPEN'
2688: and not exists (SELECT 'x'