APPS.PER_OBJ_BUS dependencies on PER_PERSONAL_SCORECARDS

Line 1745: FROM per_personal_scorecards psc

1741: --
1742:
1743: CURSOR csr_chk_scard_id IS
1744: SELECT psc.scorecard_id
1745: FROM per_personal_scorecards psc
1746: WHERE psc.scorecard_id = p_scorecard_id;
1747: --
1748: BEGIN
1749:

Line 2031: ,per_personal_scorecards ppsc

2027: SELECT
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;

Line 2045: ,per_personal_scorecards ppsc

2041: NVL(ppsc.scorecard_id,ppsc2.scorecard_id) SCORECARD_ID,
2042: NVL(ppsc.person_id,ap.appraisee_person_id) SOURCE_PERSON_ID
2043: FROM
2044: per_objectives pobj
2045: ,per_personal_scorecards ppsc
2046: ,per_personal_scorecards ppsc2
2047: ,per_appraisals ap
2048: WHERE
2049: pobj.objective_id = p_aligned_with_obj_id

Line 2046: ,per_personal_scorecards ppsc2

2042: NVL(ppsc.person_id,ap.appraisee_person_id) SOURCE_PERSON_ID
2043: FROM
2044: per_objectives pobj
2045: ,per_personal_scorecards ppsc
2046: ,per_personal_scorecards ppsc2
2047: ,per_appraisals ap
2048: WHERE
2049: pobj.objective_id = p_aligned_with_obj_id
2050: AND pobj.scorecard_id = ppsc.scorecard_id (+)

Line 2055: l_source_plan_id per_personal_scorecards.plan_id%TYPE;

2051: AND pobj.appraisal_id = ap.appraisal_id (+)
2052: AND ap.plan_id = ppsc2.plan_id(+)
2053: AND ap.appraisee_person_id = ppsc2.person_id(+);
2054: --
2055: l_source_plan_id per_personal_scorecards.plan_id%TYPE;
2056: l_source_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
2057: l_source_person_id per_personal_scorecards.person_id%TYPE;
2058: --
2059: -- Cursor to get target plan

Line 2056: l_source_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

2052: AND ap.plan_id = ppsc2.plan_id(+)
2053: AND ap.appraisee_person_id = ppsc2.person_id(+);
2054: --
2055: l_source_plan_id per_personal_scorecards.plan_id%TYPE;
2056: l_source_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
2057: l_source_person_id per_personal_scorecards.person_id%TYPE;
2058: --
2059: -- Cursor to get target plan
2060: --

Line 2057: l_source_person_id per_personal_scorecards.person_id%TYPE;

2053: AND ap.appraisee_person_id = ppsc2.person_id(+);
2054: --
2055: l_source_plan_id per_personal_scorecards.plan_id%TYPE;
2056: l_source_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
2057: l_source_person_id per_personal_scorecards.person_id%TYPE;
2058: --
2059: -- Cursor to get target plan
2060: --
2061: CURSOR csr_target_plan

Line 2066: per_personal_scorecards

2062: IS
2063: SELECT
2064: plan_id,person_id
2065: FROM
2066: per_personal_scorecards
2067: WHERE
2068: scorecard_id = p_scorecard_id;
2069: --
2070: l_target_plan_id per_personal_scorecards.plan_id%TYPE;

Line 2070: l_target_plan_id per_personal_scorecards.plan_id%TYPE;

2066: per_personal_scorecards
2067: WHERE
2068: scorecard_id = p_scorecard_id;
2069: --
2070: l_target_plan_id per_personal_scorecards.plan_id%TYPE;
2071: l_target_person_id per_personal_scorecards.person_id%TYPE;
2072: --
2073: -- Cursor to check if source and target persons is same
2074: --

Line 2071: l_target_person_id per_personal_scorecards.person_id%TYPE;

2067: WHERE
2068: scorecard_id = p_scorecard_id;
2069: --
2070: l_target_plan_id per_personal_scorecards.plan_id%TYPE;
2071: l_target_person_id per_personal_scorecards.person_id%TYPE;
2072: --
2073: -- Cursor to check if source and target persons is same
2074: --
2075: CURSOR csr_chk_person

Line 2080: ,per_personal_scorecards ppsc

2076: IS
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