APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PERF_MGMT_PLANS

Line 1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,

1184: FROM per_all_assignments_f
1185: WHERE person_id = p_person_id AND primary_flag <> 'Y';
1186:
1187: CURSOR find_appraisal (
1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,
1189: p_appr_prd_st_dt per_appraisals.appraisal_period_start_date%TYPE,
1190: p_appr_prd_ed_dt per_appraisals.appraisal_period_end_date%TYPE,
1191: p_appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
1192: -- p_appraiser_person_id per_appraisals.appraiser_person_id%TYPE,

Line 2167: l_status_code per_perf_mgmt_plans.status_code%TYPE;

2163: )
2164: IS
2165: --
2166: l_object_version_number NUMBER;
2167: l_status_code per_perf_mgmt_plans.status_code%TYPE;
2168: l_dummy BOOLEAN;
2169: l_request_id NUMBER;
2170: l_effective_date VARCHAR2 (30)
2171: := fnd_date.date_to_canonical (NVL (p_effective_date,

Line 2215: FROM per_perf_mgmt_plans

2211: --
2212: CURSOR csr_plan_ovn
2213: IS
2214: SELECT object_version_number
2215: FROM per_perf_mgmt_plans
2216: WHERE plan_id = p_plan_id;
2217:
2218: l_object_version_number NUMBER;
2219: l_effective_date DATE

Line 2368: l_status_code per_perf_mgmt_plans.status_code%TYPE;

2364: l_debug BOOLEAN := FALSE;
2365: l_effective_date DATE
2366: := TRUNC (NVL (p_effective_date, SYSDATE));
2367: l_object_version_number NUMBER;
2368: l_status_code per_perf_mgmt_plans.status_code%TYPE;
2369: l_dummy BOOLEAN;
2370: --
2371: l_scorecard_id per_personal_scorecards.scorecard_id%TYPE;
2372: --

Line 2386: FROM per_perf_mgmt_plans

2382: -- Plan record
2383: CURSOR csr_get_plan_rec
2384: IS
2385: SELECT *
2386: FROM per_perf_mgmt_plans
2387: WHERE plan_id = p_plan_id;
2388:
2389: /*
2390: -- Scorecard Objectives

Line 2434: l_plan_rec per_perf_mgmt_plans%ROWTYPE;

2430: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date
2431: AND elig.effective_end_date;
2432:
2433: --
2434: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
2435: l_obj_date DATE := TRUNC (SYSDATE);
2436: l_scorecard_status_code VARCHAR2 (30);
2437: l_check_elig VARCHAR2 (1);
2438: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;