eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DMEXTRACT_PVT dependencies on HZ_EDUCATION

Line 1263: FROM hz_education hze, ams_dm_drv_stg_gt drv

1259: GROUP BY drv.party_id,hpp.date_of_birth;
1260:
1261: CURSOR c_days_since_last_school IS
1262: SELECT SYSDATE - MAX(hze.last_date_attended), drv.party_id
1263: FROM hz_education hze, ams_dm_drv_stg_gt drv
1264: WHERE hze.party_id = drv.party_id
1265: AND hze.status = 'A'
1266: GROUP BY drv.party_id;
1267:

Line 1270: FROM hz_education hze, ams_dm_drv_stg_gt drv, hz_relationships hpr

1266: GROUP BY drv.party_id;
1267:
1268: CURSOR c_days_since_last_school_b2b IS
1269: SELECT SYSDATE - MAX(hze.last_date_attended), drv.party_id
1270: FROM hz_education hze, ams_dm_drv_stg_gt drv, hz_relationships hpr
1271: WHERE hze.party_id = hpr.subject_id
1272: AND drv.party_id = hpr.party_id
1273: AND hpr.status = 'A'
1274: AND hpr.subject_table_name = 'HZ_PARTIES'