DBA Data[Home] [Help]

APPS.PER_WPM_SUMMARY_PKG dependencies on PER_APPRAISAL_PERIODS

Line 1129: FROM per_appraisal_periods pap, per_appraisal_templates pat

1125: pap.start_date,
1126: pap.end_date,
1127: pat.rating_scale_id,
1128: pat.appraisal_template_id
1129: FROM per_appraisal_periods pap, per_appraisal_templates pat
1130: WHERE pap.appraisal_period_id = p_appraisal_period_id
1131: AND pap.appraisal_template_id = pat.appraisal_template_id;
1132:
1133: --

Line 1151: FROM per_wpm_plan_hierarchy wph, per_appraisal_periods pap

1147: SELECT DISTINCT supervisor_person_id,
1148: supervisor_name,
1149: pap.appraisal_period_id,
1150: pap.appraisal_template_id
1151: FROM per_wpm_plan_hierarchy wph, per_appraisal_periods pap
1152: WHERE wph.plan_id = p_plan_id
1153: AND pap.appraisal_period_id = p_appraisal_period_id
1154: AND pap.plan_id = wph.plan_id;
1155: BEGIN