APPS.HR_WPM_MASS_APR_PUSH dependencies on PER_PEOPLE_F

Line 1101: CURSOR get_ma_start_date (p_ma_person_id per_people_f.person_id%TYPE)

1097: AND pps.person_id = paf.person_id
1098: AND paf.primary_flag = 'Y'; --8780710 bug fix
1099:
1100: -- 8529866 Bug Fix
1101: CURSOR get_ma_start_date (p_ma_person_id per_people_f.person_id%TYPE)
1102: IS
1103: SELECT date_start
1104: FROM per_periods_of_service
1105: WHERE person_id = p_ma_person_id

Line 1254: l_appraiser_id per_people_f.person_id%TYPE;

1250: l_assess_comps_processed competences_tbl;
1251: z PLS_INTEGER;
1252: l_def_job_comps sel_comp_tab;
1253: appraisal_setup_issue EXCEPTION;
1254: l_appraiser_id per_people_f.person_id%TYPE;
1255: l_main_appraiser_id per_people_f.person_id%TYPE;
1256: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
1257: l_found_appraisal BOOLEAN;
1258: -- Declare local variables

Line 1255: l_main_appraiser_id per_people_f.person_id%TYPE;

1251: z PLS_INTEGER;
1252: l_def_job_comps sel_comp_tab;
1253: appraisal_setup_issue EXCEPTION;
1254: l_appraiser_id per_people_f.person_id%TYPE;
1255: l_main_appraiser_id per_people_f.person_id%TYPE;
1256: l_found_appraisal_id per_appraisals.appraisal_id%TYPE;
1257: l_found_appraisal BOOLEAN;
1258: -- Declare local variables
1259: l_proc VARCHAR2 (72)

Line 2411: per_people_f papf,

2407: SELECT pc.scorecard_id, pc.plan_id, pc.object_version_number,
2408: papf.business_group_id, pc.assignment_id, pc.person_id,
2409: pc.status_code, papf.full_name
2410: FROM per_personal_scorecards pc,
2411: per_people_f papf,
2412: per_assignments_f paaf
2413: WHERE pc.plan_id = p_plan_id
2414: AND pc.assignment_id = paaf.assignment_id
2415: AND pc.person_id = papf.person_id

Line 2894: l_person_name per_people_f.full_name%TYPE;

2890: l_evaluated NUMBER (9) := 0;
2891: l_successful NUMBER (9) := 0;
2892: l_error NUMBER (9) := 0;
2893: l_warning NUMBER (9) := 0;
2894: l_person_name per_people_f.full_name%TYPE;
2895: l_person_index BINARY_INTEGER;
2896:
2897: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
2898: IS