DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_ASSIGNMENTS_F

Line 5804: ,per_assignments_f paaf

5800: ,paaf.supervisor_id
5801: ,paaf.supervisor_assignment_id
5802: ,suppapf.full_name SUPERVISOR_NAME
5803: FROM per_people_f papf
5804: ,per_assignments_f paaf
5805: ,per_all_people_f suppapf
5806: WHERE paaf.assignment_id = p_assignment_id
5807: AND papf.person_id = paaf.person_id
5808: AND p_effective_date BETWEEN papf.effective_start_date AND

Line 6163: ,per_assignments_f paaf

6159: ,pc.assignment_id
6160: ,paaf.supervisor_id -- Bug7567079
6161: FROM per_personal_scorecards pc
6162: ,per_people_f papf
6163: ,per_assignments_f paaf
6164: WHERE pc.scorecard_id = p_sc_id
6165: AND pc.plan_id = p_plan_id
6166: AND pc.assignment_id = paaf.assignment_id
6167: AND pc.person_id = papf.person_id

Line 6255: ,per_assignments_f paaf

6251: ,pc.assignment_id
6252: ,paaf.supervisor_id -- Bug7567079
6253: FROM per_personal_scorecards pc
6254: ,per_people_f papf
6255: ,per_assignments_f paaf
6256: WHERE pc.scorecard_id = p_sc_id
6257: AND pc.plan_id = p_plan_id
6258: AND pc.assignment_id = paaf.assignment_id
6259: AND pc.person_id = papf.person_id