APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PERF_MGMT_PLANS

Line 872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,

868: IS
869: select DEFAULT_JOB_COMPETENCIES, ASSESSMENT_TYPE_ID from per_assessment_types
870: where ASSESSMENT_TYPE_ID = p_assess_templ;
871:
872: cursor find_appraisal(p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
873: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
874: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
875: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
876: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

Line 1395: l_status_code per_perf_mgmt_plans.status_code%TYPE;

1391: )
1392: is
1393: --
1394: l_object_version_number number ;
1395: l_status_code per_perf_mgmt_plans.status_code%TYPE;
1396: l_dummy boolean;
1397: l_request_id number;
1398: l_effective_date varchar2(30) := fnd_date.date_to_canonical(nvl(p_effective_date,trunc(sysdate)));
1399:

Line 1437: from per_perf_mgmt_plans

1433:
1434: --
1435: cursor csr_plan_ovn is
1436: select object_version_number
1437: from per_perf_mgmt_plans
1438: where plan_id = p_plan_id;
1439:
1440: l_object_version_number number;
1441: l_effective_date date := fnd_date.canonical_to_date(nvl(p_effective_date,trunc(sysdate)));

Line 1529: l_status_code per_perf_mgmt_plans.status_code%TYPE;

1525: l_logging pay_action_parameters.parameter_value%type;
1526: l_debug boolean := FALSE;
1527: l_effective_date date := TRUNC(nvl(p_effective_date, sysdate));
1528: l_object_version_number number;
1529: l_status_code per_perf_mgmt_plans.status_code%TYPE;
1530: l_dummy boolean;
1531:
1532: --
1533: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;

Line 1547: FROM per_perf_mgmt_plans

1543:
1544: -- Plan record
1545: CURSOR csr_get_plan_rec IS
1546: SELECT *
1547: FROM per_perf_mgmt_plans
1548: WHERE plan_id = p_plan_id;
1549: /*
1550: -- Scorecard Objectives
1551: CURSOR csr_sc_objectives(p_scorecard_id number) IS

Line 1568: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

1564: FROM per_personal_scorecards
1565: WHERE plan_id = p_plan_id;
1566: --
1567:
1568: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
1569: l_obj_date date;
1570: l_scorecard_status_code varchar2(30);
1571: --
1572: -- cursor to select pending transactions for a given scorecard