APPS.AMS_DMEXTRACT_PVT dependencies on HZ_ORGANIZATION_PROFILES

Line 295: FROM hz_organization_profiles d

291: AND c.party_id = x.party_id
292: AND c.status = 'A' AND SYSDATE BETWEEN c.start_date AND NVL(c.end_date,SYSDATE))
293: UNION ALL
294: (SELECT d.party_id
295: FROM hz_organization_profiles d
296: WHERE d.last_update_date > x.last_update_date
297: AND d.party_id = x.party_id
298: AND SYSDATE BETWEEN d.effective_start_date AND NVL(d.effective_end_date,SYSDATE))
299: UNION ALL

Line 496: hz_organization_profiles hop,

492: hzp.city
493: FROM
494: -- ams_dm_drv_stg drv,
495: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
496: hz_organization_profiles hop,
497: hz_parties hzp
498: WHERE
499: drv.party_id = hzp.party_id
500: AND hzp.status = 'A'

Line 690: hz_organization_profiles hop,

686: FROM
687: -- ams_dm_drv_stg drv,
688: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
689: hz_person_profiles hpp,
690: hz_organization_profiles hop,
691: hz_org_contacts hoc,
692: hz_employment_history heh,
693: hz_relationships hpr,
694: hz_parties hzp