APPS.AMS_DMSELECTION_PVT dependencies on HZ_SUSPENSION_ACTIVITY

Line 2471: FROM hz_cust_accounts c, hz_suspension_activity s

2467: UPDATE /*+ index(t AMS_DM_SOURCE_U2) */ ams_dm_source t
2468: SET target_value = (SELECT L_POSITIVE_TARGET_VALUE
2469: FROM dual
2470: WHERE EXISTS (SELECT 1
2471: FROM hz_cust_accounts c, hz_suspension_activity s
2472: WHERE c.party_id = t.party_id
2473: AND s.cust_account_id = c.cust_account_id
2474: AND s.action_type = L_NON_LOYAL_CODE
2475: ))