APPS.AMS_DMEXTRACT_PVT dependencies on HZ_PERSON_PROFILES

Line 280: FROM hz_person_profiles b

276: AND a.party_id = x.party_id
277: AND a.status = 'A')
278: UNION ALL
279: (SELECT b.party_id
280: FROM hz_person_profiles b
281: WHERE b.last_update_date > x.last_update_date
282: AND b.party_id = x.party_id
283: AND SYSDATE BETWEEN b.effective_start_date AND NVL(b.effective_end_date,SYSDATE))
284: UNION ALL

Line 689: hz_person_profiles hpp,

685: hzp.city
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,

Line 795: hz_person_profiles hpp,

791: hzp.city
792: FROM
793: -- ams_dm_drv_stg drv,
794: ams_dm_drv_stg_gt drv, -- nysotos - Sep 15, 2003 - Global Temp Table
795: hz_person_profiles hpp,
796: hz_employment_history heh,
797: hz_parties hzp
798: WHERE
799: drv.party_id = hzp.party_id

Line 1242: FROM hz_person_profiles hpp, ams_dm_drv_stg_gt drv

1238:
1239: -- age is in number of days
1240: CURSOR c_age IS
1241: SELECT SYSDATE - hpp.date_of_birth, drv.party_id
1242: FROM hz_person_profiles hpp, ams_dm_drv_stg_gt drv
1243: WHERE hpp.party_id = drv.party_id
1244: AND (SYSDATE BETWEEN hpp.effective_start_date AND NVL(hpp.effective_end_date,SYSDATE))
1245: GROUP BY drv.party_id,hpp.date_of_birth;
1246:

Line 1249: FROM hz_person_profiles hpp,hz_relationships hpr,ams_dm_drv_stg_gt drv

1245: GROUP BY drv.party_id,hpp.date_of_birth;
1246:
1247: CURSOR c_age_b2b IS
1248: SELECT SYSDATE - hpp.date_of_birth,drv.party_id
1249: FROM hz_person_profiles hpp,hz_relationships hpr,ams_dm_drv_stg_gt drv
1250: WHERE hpp.party_id = hpr.subject_id
1251: AND drv.party_id = hpr.party_id
1252: AND hpr.status = 'A'
1253: AND hpr.subject_table_name = 'HZ_PARTIES'