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_ASSIGNMENTS_F

Line 949: ||' FROM per_assignments_f paf'

945: END IF;
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 = '

Line 986: ||' FROM per_assignments_f paf'

982: END IF;
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 = '

Line 1023: ||' FROM per_assignments_f paf'

1019: END IF;
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'

Line 1063: ||' FROM per_assignments_f paf'

1059:
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'

Line 1109: ||' FROM per_assignments_f paf'

1105: END IF;
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'

Line 1156: ||' FROM per_assignments_f paf'

1152: END IF;
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'

Line 2607: FROM per_assignments_f paf

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
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)

Line 2625: FROM per_assignments_f paf

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
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)

Line 2674: FROM per_assignments_f pasf,

2670:
2671: CURSOR csr_vacanies_by_person IS
2672: SELECT pasf.vacancy_id
2673: ,pv.name ||' ('||pr.name||')' name
2674: FROM per_assignments_f pasf,
2675: per_assignment_status_types past,
2676: per_vacancies pv,
2677: per_requisitions pr
2678: WHERE pasf.person_id = p_person_id

Line 2724: per_assignments_f paf

2720: SELECT pp.position_id, pp.name
2721: FROM hr_positions_f pp
2722: WHERE pp.position_id = (SELECT pp2.successor_position_id
2723: FROM hr_positions_f pp2,
2724: per_assignments_f paf
2725: WHERE paf.person_id = p_person_id
2726: AND p_effective_date BETWEEN paf.effective_start_date
2727: AND paf.effective_end_date
2728: AND paf.position_id = pp2.position_id

Line 2761: FROM per_assignments_f pasf,

2757: ,p_count out nocopy number) IS
2758:
2759: CURSOR csr_deployment_by_person IS
2760: SELECT pasf.assignment_id, pasf.position_id, pasf.grade_id, pp.name
2761: FROM per_assignments_f pasf,
2762: per_assignment_status_types past,
2763: hr_positions_f pp
2764: WHERE pasf.person_id = p_person_id
2765: AND p_effective_date BETWEEN pasf.effective_start_date

Line 2805: FROM per_assignments_f pasf,

2801: ,p_count out nocopy number) IS
2802:
2803: CURSOR csr_deployment_by_person IS
2804: SELECT pasf.assignment_id, pasf.job_id, pasf.grade_id, pj.name
2805: FROM per_assignments_f pasf,
2806: per_assignment_status_types past,
2807: per_jobs_vl pj
2808: WHERE pasf.person_id = p_person_id
2809: AND p_effective_date BETWEEN pasf.effective_start_date

Line 2847: FROM per_assignments_f pasf,

2843: ,p_count out nocopy number) IS
2844:
2845: CURSOR csr_deployment_by_person IS
2846: SELECT pasf.assignment_id, pasf.organization_id, hou.name
2847: FROM per_assignments_f pasf,
2848: per_assignment_status_types past,
2849: hr_organization_units hou
2850: WHERE pasf.person_id = p_person_id
2851: AND p_effective_date BETWEEN pasf.effective_start_date

Line 2890: FROM per_assignments_f pasf,

2886: CURSOR csr_deployment_by_person IS
2887: SELECT pasf.assignment_id
2888: ,pasf.vacancy_id
2889: ,pv.name||' ('||pr.name||')' name
2890: FROM per_assignments_f pasf,
2891: per_assignment_status_types past,
2892: per_vacancies pv,
2893: per_requisitions pr
2894: WHERE pasf.person_id = p_person_id

Line 2951: per_assignments_f paf

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
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

Line 2988: per_assignments_f paf

2984: (p_effective_date, ppf.person_id) type
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

Line 3068: ||' FROM per_assignments_f paf'

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 = '
3072: ||l_business_group

Line 3196: FROM per_assignments_f paf

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

Line 3214: FROM per_assignments_f paf

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
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

Line 3269: FROM per_assignments_f paf

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
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)

Line 3288: FROM per_assignments_f paf

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
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)

Line 3344: FROM per_assignments_f paf

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
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)

Line 3363: FROM per_assignments_f paf

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
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)