DBA Data[Home] [Help]

APPS.PER_OBJ_BUS dependencies on PER_PERF_MGMT_PLANS

Line 2032: -- ,per_perf_mgmt_plans ppln

2028: ppsc.plan_id,ppsc.scorecard_id,ppsc.person_id
2029: FROM
2030: per_objectives pobj
2031: ,per_personal_scorecards ppsc
2032: -- ,per_perf_mgmt_plans ppln
2033: WHERE
2034: pobj.objective_id = p_aligned_with_obj_id
2035: AND pobj.scorecard_id = ppsc.scorecard_id;
2036: --and ppsc.plan_id = ppln.plan_id;*/

Line 2081: ,per_perf_mgmt_plans ppln

2077: SELECT 'Y'
2078: FROM
2079: per_objectives pobj
2080: ,per_personal_scorecards ppsc
2081: ,per_perf_mgmt_plans ppln
2082: WHERE
2083: ppln.plan_id = l_source_plan_id
2084: AND ppln.plan_id = ppsc.plan_id
2085: AND ppsc.person_id = l_source_person_id