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.HR_SUIT_MATCH_UTILITY_WEB dependencies on HR_PERSON_TYPE_USAGE_INFO

Line 273: ||',hr_person_type_usage_info.get_user_person_type(trunc(sysdate),ppf.person_id) user_person_type'

269: 'SELECT distinct ppf.person_id';
270: l_dynamic_sql := l_dynamic_sql
271: ||',ppf.full_name name';
272: l_dynamic_sql := l_dynamic_sql
273: ||',hr_person_type_usage_info.get_user_person_type(trunc(sysdate),ppf.person_id) user_person_type'
274: ||',hr_general.get_work_phone(ppf.person_id)'
275: ||',ppf.internal_location'
276: ||',ppf.employee_number'
277: ||',ppf.applicant_number'

Line 2604: ,hr_person_type_usage_info.get_user_person_type

2600:
2601: CURSOR csr_people_by_vacancy IS
2602: SELECT distinct(paf.person_id) person_id
2603: ,ppf.full_name name
2604: ,hr_person_type_usage_info.get_user_person_type
2605: (p_effective_date, paf.person_id) type
2606: ,ppf.order_name
2607: FROM per_assignments_f paf
2608: ,per_people_f ppf

Line 2621: ,hr_person_type_usage_info.get_user_person_type

2617: --legislatioon_code = 'JP'
2618: CURSOR csr_jp_people_by_vacancy IS
2619: SELECT distinct(paf.person_id) person_id
2620: ,ppf.full_name name
2621: ,hr_person_type_usage_info.get_user_person_type
2622: (p_effective_date, paf.person_id) type
2623: ,ppf.last_name
2624: ,ppf.first_name
2625: FROM per_assignments_f paf

Line 2933: ,hr_person_type_usage_info.get_user_person_type

2929: CURSOR csr_succesors_by_position IS
2930: SELECT * FROM (
2931: SELECT distinct(psp.person_id) person_id
2932: ,ppf.full_name name
2933: ,hr_person_type_usage_info.get_user_person_type
2934: (p_effective_date, ppf.person_id) type
2935: ,ppf.order_name
2936: FROM per_succession_planning psp
2937: ,per_people_f ppf

Line 2947: ,hr_person_type_usage_info.get_user_person_type

2943: AND ppf.effective_end_date
2944: UNION
2945: select paf.person_id
2946: ,ppf.full_name name
2947: ,hr_person_type_usage_info.get_user_person_type
2948: (p_effective_date, ppf.person_id) type
2949: ,ppf.order_name
2950: from hr_positions_f ps,
2951: per_assignments_f paf

Line 2968: ,hr_person_type_usage_info.get_user_person_type

2964: CURSOR csr_jp_succesors_by_position IS
2965: SELECT * FROM (
2966: SELECT distinct(psp.person_id) person_id
2967: ,ppf.full_name name
2968: ,hr_person_type_usage_info.get_user_person_type
2969: (p_effective_date, ppf.person_id) type
2970: ,ppf.last_name
2971: ,ppf.first_name
2972: FROM per_succession_planning psp

Line 2983: ,hr_person_type_usage_info.get_user_person_type

2979: AND NVL(ppf.effective_end_date, p_effective_date)
2980: UNION
2981: select paf.person_id
2982: ,ppf.full_name name
2983: ,hr_person_type_usage_info.get_user_person_type
2984: (p_effective_date, ppf.person_id) type
2985: ,ppf.last_name
2986: ,ppf.first_name
2987: from hr_positions_f ps,

Line 3067: ||',hr_person_type_usage_info.get_user_person_type(trunc(sysdate),paf.person_id) type'

3063: 'SELECT distinct(paf.person_id) person_id';
3064: l_dynamic_sql := l_dynamic_sql
3065: ||',ppf.full_name name';
3066: l_dynamic_sql := l_dynamic_sql
3067: ||',hr_person_type_usage_info.get_user_person_type(trunc(sysdate),paf.person_id) type'
3068: ||' FROM per_assignments_f paf'
3069: ||' ,per_people_f ppf'
3070: ||' ,per_periods_of_service ppos'
3071: ||' WHERE paf.business_group_id = '

Line 3193: ,hr_person_type_usage_info.get_user_person_type

3189:
3190: CURSOR csr_people_by_role_org IS
3191: SELECT distinct(paf.person_id) person_id
3192: ,ppf.full_name name
3193: ,hr_person_type_usage_info.get_user_person_type
3194: (p_effective_date, ppf.person_id) type
3195: ,ppf.order_name
3196: FROM per_assignments_f paf
3197: ,per_people_f ppf

Line 3210: ,hr_person_type_usage_info.get_user_person_type

3206:
3207: CURSOR csr_jp_people_by_role_org IS
3208: SELECT distinct(paf.person_id) person_id
3209: ,ppf.full_name name
3210: ,hr_person_type_usage_info.get_user_person_type
3211: (p_effective_date,ppf.person_id) type
3212: ,ppf.last_name
3213: ,ppf.first_name
3214: FROM per_assignments_f paf

Line 3266: ,hr_person_type_usage_info.get_user_person_type

3262:
3263: CURSOR csr_people_by_role_job IS
3264: SELECT distinct(paf.person_id) person_id
3265: ,ppf.full_name name
3266: ,hr_person_type_usage_info.get_user_person_type
3267: (p_effective_date,ppf.person_id) type
3268: ,ppf.order_name
3269: FROM per_assignments_f paf
3270: ,per_people_f ppf

Line 3284: ,hr_person_type_usage_info.get_user_person_type

3280:
3281: CURSOR csr_jp_people_by_role_job IS
3282: SELECT distinct(paf.person_id) person_id
3283: ,ppf.full_name name
3284: ,hr_person_type_usage_info.get_user_person_type
3285: (p_effective_date,ppf.person_id) type
3286: ,ppf.last_name
3287: ,ppf.first_name
3288: FROM per_assignments_f paf

Line 3341: ,hr_person_type_usage_info.get_user_person_type

3337:
3338: CURSOR csr_people_by_role_pos IS
3339: SELECT distinct(paf.person_id) person_id
3340: ,ppf.full_name name
3341: ,hr_person_type_usage_info.get_user_person_type
3342: (p_effective_date,ppf.person_id) type
3343: ,ppf.order_name
3344: FROM per_assignments_f paf
3345: ,per_people_f ppf

Line 3359: ,hr_person_type_usage_info.get_user_person_type

3355:
3356: CURSOR csr_jp_people_by_role_pos IS
3357: SELECT distinct(paf.person_id) person_id
3358: ,ppf.full_name name
3359: ,hr_person_type_usage_info.get_user_person_type
3360: (p_effective_date,ppf.person_id) type
3361: ,ppf.last_name
3362: ,ppf.first_name
3363: FROM per_assignments_f paf