APPS.HR_WPM_UTIL dependencies on PER_ASSIGNMENTS_F

Line 1116: per_assignments_f paf,

1112: per_sp_successor_in_plan ssp,
1113: per_sp_successee_details ssd,
1114: hr_organization_information bg,
1115: per_people_f ppf,
1116: per_assignments_f paf,
1117: per_assignments_f pa1,
1118: per_assignment_status_types pas
1119: WHERE ppf.person_id <> fnd_global.employee_id
1120: AND ppf.person_id = paf.person_id

Line 1117: per_assignments_f pa1,

1113: per_sp_successee_details ssd,
1114: hr_organization_information bg,
1115: per_people_f ppf,
1116: per_assignments_f paf,
1117: per_assignments_f pa1,
1118: per_assignment_status_types pas
1119: WHERE ppf.person_id <> fnd_global.employee_id
1120: AND ppf.person_id = paf.person_id
1121: AND paf.primary_flag = 'Y'

Line 1180: per_assignments_f paf,

1176: FROM per_sp_plan sp,
1177: per_sp_successor_in_plan ssp,
1178: per_sp_successee_details ssd,
1179: per_people_f ppf,
1180: per_assignments_f paf,
1181: per_assignments_f pa1,
1182: per_assignment_status_types pas
1183: WHERE sp.plan_id = p_plan_id
1184: AND ppf.person_id <> fnd_global.employee_id

Line 1181: per_assignments_f pa1,

1177: per_sp_successor_in_plan ssp,
1178: per_sp_successee_details ssd,
1179: per_people_f ppf,
1180: per_assignments_f paf,
1181: per_assignments_f pa1,
1182: per_assignment_status_types pas
1183: WHERE sp.plan_id = p_plan_id
1184: AND ppf.person_id <> fnd_global.employee_id
1185: AND ppf.person_id = paf.person_id

Line 1245: FROM per_personal_scorecards pps, per_assignments_f paf,

1241: SELECT 'Y'
1242: FROM DUAL
1243: WHERE EXISTS (
1244: SELECT 'x'
1245: FROM per_personal_scorecards pps, per_assignments_f paf,
1246: per_perf_mgmt_plans pmp
1247: WHERE paf.supervisor_id = p_manager_person_id
1248: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date AND
1249: paf.effective_end_date