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 PER_PEOPLE_F

Line 10: c_person_id per_people_f.person_id%type;

6: := hr_util_misc_web.g_region_application_id;
7:
8: c_title hr_util_misc_web.g_title%TYPE;
9: g_prompts hr_util_misc_web.g_prompts%TYPE;
10: c_person_id per_people_f.person_id%type;
11: c_language_code varchar2(5);
12: c_legislation_code varchar2(5);
13: g_person_rec per_people_f%ROWTYPE;
14:

Line 13: g_person_rec per_people_f%ROWTYPE;

9: g_prompts hr_util_misc_web.g_prompts%TYPE;
10: c_person_id per_people_f.person_id%type;
11: c_language_code varchar2(5);
12: c_legislation_code varchar2(5);
13: g_person_rec per_people_f%ROWTYPE;
14:
15: -- ---------------------------------------------------------------------------
16: -- get_option_header
17: -- ---------------------------------------------------------------------------

Line 280: ||' FROM per_people_f ppf'

276: ||',ppf.employee_number'
277: ||',ppf.applicant_number'
278: ||',decode (ppf.current_employee_flag ,''Y'',ppos.date_start,null)'
279: ||',ppf.order_name'
280: ||' FROM per_people_f ppf'
281: ||',per_periods_of_service ppos'
282: ||' WHERE ppf.person_id IN ('||l_ids||')'
283: -- Bug # 2670769 fix begins.
284: -- Bug#3282680 start

Line 814: ||' FROM per_people_f ppf'

810: l_dynamic_sql := 'SELECT ppf.person_id';
811: l_dynamic_sql := l_dynamic_sql
812: ||',ppf.full_name name';
813: l_dynamic_sql := l_dynamic_sql
814: ||' FROM per_people_f ppf'
815: ||' WHERE ppf.person_id IN ('
816: ||p_ids
817: ||')';
818: ELSE

Line 950: ||' ,per_people_f ppf'

946: IF p_search_type = g_location_type THEN
947: l_dynamic_sql := 'SELECT DISTINCT(paf.location_id) id'
948: ||' ,hl.location_code name'
949: ||' FROM per_assignments_f paf'
950: ||' ,per_people_f ppf'
951: ||' ,per_person_type_usages_f ptu'
952: ||' ,hr_locations_all hl'
953: ||' WHERE paf.business_group_id = '
954: ||l_business_group

Line 987: ||' ,per_people_f ppf'

983: ELSIF p_search_type = g_organization_type THEN
984: l_dynamic_sql := 'SELECT DISTINCT(paf.organization_id) id'
985: ||' ,hou.name name'
986: ||' FROM per_assignments_f paf'
987: ||' ,per_people_f ppf'
988: ||' ,per_person_type_usages_f ptu'
989: ||' ,hr_organization_units hou'
990: ||' WHERE paf.business_group_id = '
991: ||l_business_group

Line 1024: ||' ,per_people_f ppf'

1020: ELSIF p_search_type = g_job_type THEN
1021: l_dynamic_sql := 'SELECT DISTINCT(paf.job_id) id'
1022: ||','|| l_job_flex_select_clause
1023: ||' FROM per_assignments_f paf'
1024: ||' ,per_people_f ppf'
1025: ||' ,per_person_type_usages_f ptu'
1026: ||' ,per_jobs_vl pj'
1027: ||' ,per_job_definitions pjd'
1028: ||' WHERE paf.business_group_id = '

Line 1064: ||' ,per_people_f ppf'

1060: ELSIF p_search_type = g_position_type THEN
1061: l_dynamic_sql := 'SELECT DISTINCT(paf.position_id) id'
1062: ||','|| l_pos_flex_select_clause
1063: ||' FROM per_assignments_f paf'
1064: ||' ,per_people_f ppf'
1065: ||' ,per_person_type_usages_f ptu'
1066: ||' ,hr_positions_f pp'
1067: ||' ,per_position_definitions ppd'
1068: ||' WHERE paf.business_group_id = '

Line 1110: ||' ,per_people_f ppf'

1106: ELSIF p_search_type = g_vacancy_type THEN
1107: l_dynamic_sql := 'SELECT DISTINCT(paf.vacancy_id) id'
1108: ||',pv.name || '' (''||pr.name||'')'' name'
1109: ||' FROM per_assignments_f paf'
1110: ||' ,per_people_f ppf'
1111: ||' ,per_person_type_usages_f ptu'
1112: ||' ,per_vacancies pv'
1113: ||' ,per_requisitions pr'
1114: ||' WHERE paf.business_group_id = '

Line 1157: ||' ,per_people_f ppf'

1153: ELSIF p_search_type = g_grade_type THEN
1154: l_dynamic_sql := 'SELECT DISTINCT(paf.grade_id) id'
1155: ||','|| l_grd_flex_select_clause
1156: ||' FROM per_assignments_f paf'
1157: ||' ,per_people_f ppf'
1158: ||' ,per_person_type_usages_f ptu'
1159: ||' ,per_grades pg'
1160: ||' ,per_grade_definitions pgd'
1161: ||' WHERE paf.business_group_id = '

Line 2608: ,per_people_f ppf

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
2609: WHERE paf.vacancy_id = p_vacancy_id
2610: AND p_effective_date BETWEEN paf.effective_start_date
2611: AND NVL(paf.effective_end_date, p_effective_date)
2612: AND paf.person_id = ppf.person_id

Line 2626: ,per_people_f ppf

2622: (p_effective_date, paf.person_id) type
2623: ,ppf.last_name
2624: ,ppf.first_name
2625: FROM per_assignments_f paf
2626: ,per_people_f ppf
2627: WHERE paf.vacancy_id = p_vacancy_id
2628: AND p_effective_date BETWEEN paf.effective_start_date
2629: AND NVL(paf.effective_end_date, p_effective_date)
2630: AND paf.person_id = ppf.person_id

Line 2937: ,per_people_f ppf

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
2938: WHERE psp.position_id = p_pos_id
2939: AND p_effective_date <=
2940: NVL(psp.end_date, p_effective_date)
2941: AND psp.person_id = ppf.person_id

Line 2952: ,per_people_f ppf

2948: (p_effective_date, ppf.person_id) type
2949: ,ppf.order_name
2950: from hr_positions_f ps,
2951: per_assignments_f paf
2952: ,per_people_f ppf
2953: where ps.successor_position_id = p_pos_id
2954: AND p_effective_date BETWEEN ps.effective_start_date
2955: AND ps.effective_end_date
2956: and paf.position_id = ps.position_id

Line 2973: ,per_people_f ppf

2969: (p_effective_date, ppf.person_id) type
2970: ,ppf.last_name
2971: ,ppf.first_name
2972: FROM per_succession_planning psp
2973: ,per_people_f ppf
2974: WHERE psp.position_id = p_pos_id
2975: AND p_effective_date <=
2976: NVL(psp.end_date, p_effective_date)
2977: AND psp.person_id = ppf.person_id

Line 2989: ,per_people_f ppf

2985: ,ppf.last_name
2986: ,ppf.first_name
2987: from hr_positions_f ps,
2988: per_assignments_f paf
2989: ,per_people_f ppf
2990: where ps.successor_position_id = p_pos_id
2991: AND p_effective_date BETWEEN ps.effective_start_date
2992: AND ps.effective_end_date
2993: and paf.position_id = ps.position_id

Line 3069: ||' ,per_people_f ppf'

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 = '
3072: ||l_business_group
3073: ||' AND paf.assignment_type = ''E'''

Line 3197: ,per_people_f ppf

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
3198: WHERE paf.organization_id = p_org_id
3199: AND paf.assignment_type = 'E'
3200: AND p_effective_date BETWEEN paf.effective_start_date
3201: AND NVL(paf.effective_end_date, p_effective_date)

Line 3215: ,per_people_f ppf

3211: (p_effective_date,ppf.person_id) type
3212: ,ppf.last_name
3213: ,ppf.first_name
3214: FROM per_assignments_f paf
3215: ,per_people_f ppf
3216: WHERE paf.organization_id = p_org_id
3217: AND paf.assignment_type = 'E'
3218: AND p_effective_date BETWEEN paf.effective_start_date
3219: AND NVL(paf.effective_end_date, p_effective_date)

Line 3270: ,per_people_f ppf

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
3271: WHERE paf.job_id = p_job_id
3272: AND paf.assignment_type = 'E'
3273: AND (p_grade_id is null or paf.grade_id = p_grade_id)
3274: AND p_effective_date BETWEEN paf.effective_start_date

Line 3289: ,per_people_f ppf

3285: (p_effective_date,ppf.person_id) type
3286: ,ppf.last_name
3287: ,ppf.first_name
3288: FROM per_assignments_f paf
3289: ,per_people_f ppf
3290: WHERE paf.job_id = p_job_id
3291: AND paf.assignment_type = 'E'
3292: AND (p_grade_id is null or paf.grade_id = p_grade_id)
3293: AND p_effective_date BETWEEN paf.effective_start_date

Line 3345: ,per_people_f ppf

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
3346: WHERE paf.position_id = p_pos_id
3347: AND paf.assignment_type = 'E'
3348: AND (p_grade_id is null or paf.grade_id = p_grade_id)
3349: AND p_effective_date BETWEEN paf.effective_start_date

Line 3364: ,per_people_f ppf

3360: (p_effective_date,ppf.person_id) type
3361: ,ppf.last_name
3362: ,ppf.first_name
3363: FROM per_assignments_f paf
3364: ,per_people_f ppf
3365: WHERE paf.position_id = p_pos_id
3366: AND paf.assignment_type = 'E'
3367: AND (p_grade_id is null or paf.grade_id = p_grade_id)
3368: AND p_effective_date BETWEEN paf.effective_start_date