DBA Data[Home] [Help]

APPS.HR_WPM_NTF_UTIL dependencies on PER_ASSIGNMENTS_F

Line 53: from per_personal_scorecards sc, per_assignments_f wrk,

49:
50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)
51: is
52: select sup.person_id
53: from per_personal_scorecards sc, per_assignments_f wrk,
54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans
55: where sc.scorecard_id = p_sc_id
56: and plans.plan_id = sc.plan_id
57: and sc.assignment_id = wrk.assignment_id

Line 54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans

50: cursor get_pos_manager_id(p_sc_id per_personal_scorecards.scorecard_id%TYPE)
51: is
52: select sup.person_id
53: from per_personal_scorecards sc, per_assignments_f wrk,
54: per_pos_structure_elements ppse, per_assignments_f sup, per_perf_mgmt_plans plans
55: where sc.scorecard_id = p_sc_id
56: and plans.plan_id = sc.plan_id
57: and sc.assignment_id = wrk.assignment_id
58: and trunc(sysdate) between wrk.effective_start_date and wrk.effective_end_date