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.EDW_HR_PERSON_M_SIZING dependencies on PER_ALL_PEOPLE_F

Line 19: FROM per_all_people_f peo

15: SELECT SUM(total)
16: FROM (
17: SELECT COUNT(*) total
18: FROM ( SELECT DISTINCT peo.person_id
19: FROM per_all_people_f peo
20: ,hr_all_organization_units bgr
21: WHERE peo.business_group_id = bgr.organization_id
22: AND greatest( NVL(peo.last_update_date,to_date('01-01-2000','DD-MM-YYYY')),
23: NVL(bgr.last_update_date,to_date('01-01-2000','DD-MM-YYYY')))

Line 53: /* (since per_all_people_f is large and date-tracked) some attributes have */

49: END count_source_rows;
50:
51: /******************************************************************************/
52: /* Estimates row lengths. Because the union is likely to be heavily skewed */
53: /* (since per_all_people_f is large and date-tracked) some attributes have */
54: /* been averaged across the union to improve the accuracy of the estimation */
55: /******************************************************************************/
56: PROCEDURE estimate_row_length( p_from_date IN DATE,
57: p_to_date IN DATE,

Line 177: per_all_people_f peo

173: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO',resume_exists)),0))
174: ,avg(nvl(vsize(hr_general.decode_lookup('YES_NO',fast_path_employee)),0))
175: ,count(person_id)
176: FROM
177: per_all_people_f peo
178: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
179:
180: /* Length of language */
181: CURSOR lng_cur IS