APPS.AMS_DMEXTRACT_PVT dependencies on HZ_PERSON_INTEREST

Line 307: FROM hz_person_interest f

303: AND e.party_id = x.party_id
304: AND e.status = 'A')
305: UNION ALL
306: (SELECT f.party_id
307: FROM hz_person_interest f
308: WHERE f.last_update_date > x.last_update_date
309: AND f.party_id = x.party_id
310: AND f.status = 'A')
311: )

Line 882: hz_person_interest hpi,

878: 'DRINK',0,
879: 'SMOKE',0, 1)) interest_other_flag
880: -- FROM ams_dm_drv_stg drv,
881: FROM ams_dm_drv_stg_gt drv, -- nyostos - Sept 15, 2003 - Global Temp Table
882: hz_person_interest hpi,
883: hz_relationships hpr
884: WHERE drv.party_id = hpr.party_id --it's the party of type relationship
885: AND hpr.status = 'A'
886: AND hpr.subject_table_name = 'HZ_PARTIES'

Line 931: hz_person_interest hpi

927: 'DRINK',0,
928: 'SMOKE',0, 1)) interest_other_flag
929: -- FROM ams_dm_drv_stg drv,
930: FROM ams_dm_drv_stg_gt drv, -- nyostos - Sep 15, 2003 - Global Temp Table
931: hz_person_interest hpi
932: WHERE drv.party_id = hpi.party_id(+)
933: AND hpi.status(+) = 'A'
934: GROUP BY drv.party_id
935: ;