eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on BEN_ELIG_OBJ_F

Line 85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE

81: measure_comments per_objectives_library.measure_comments%TYPE,
82: details per_objectives_library.details%TYPE,
83: success_criteria per_objectives_library.success_criteria%TYPE,
84: comments per_objectives_library.comments%TYPE,
85: elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE
86: );
87:
88: TYPE g_qual_obj_t IS TABLE OF g_qual_obj_r
89: INDEX BY BINARY_INTEGER;

Line 1345: FROM per_objectives_library pol, ben_elig_obj_f elig

1341: IS
1342: SELECT objective_id, objective_name, valid_from, valid_to, target_date, next_review_date, group_code, priority_code,
1343: appraise_flag, weighting_percent, target_value, uom_code, measurement_style_code, measure_name,
1344: measure_type_code, measure_comments, details, success_criteria, comments, elig.elig_obj_id
1345: FROM per_objectives_library pol, ben_elig_obj_f elig
1346: WHERE ( pol.valid_from BETWEEN p_start_date AND p_end_date
1347: OR p_start_date BETWEEN pol.valid_from AND NVL (pol.valid_to, TO_DATE ('31-12-4712', 'DD-MM-YYYY'))
1348: )
1349: AND pol.eligibility_type_code <> 'N_P'

Line 4904: FROM ben_elig_obj_f elig

4900: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.
4901: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
4902: IS
4903: SELECT elig.elig_obj_id
4904: FROM ben_elig_obj_f elig
4905: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
4906: AND elig.column_name = 'PLAN_ID'
4907: AND elig.COLUMN_VALUE = p_plan_id
4908: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;

Line 4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

4922: l_appr_ovn per_appraisals.object_version_number%TYPE;
4923: l_appr_id per_appraisals.appraisal_id%TYPE;
4924: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
4925: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
4926: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
4927: l_person_name per_all_people_f.full_name%TYPE;
4928: BEGIN
4929: --
4930: -- Initialize logging

Line 7424: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

7420: l_check_elig VARCHAR2 (1);
7421: l_check_period_elig VARCHAR2 (1);
7422: l_plan_aprsl_pds_index BINARY_INTEGER;
7423: l_appr_ret_status VARCHAR2 (30);
7424: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
7425: l_proc VARCHAR2 (72) := g_package || 'enroll_a_person';
7426:
7427: -- cursor added
7428: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.

Line 7432: FROM ben_elig_obj_f elig

7428: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.
7429: CURSOR get_elig_obj_id_for_period (p_appraisal_period_id IN per_appraisal_periods.appraisal_period_id%TYPE)
7430: IS
7431: SELECT elig.elig_obj_id
7432: FROM ben_elig_obj_f elig
7433: WHERE elig.table_name = 'PER_APPRAISAL_PERIODS'
7434: AND elig.column_name = 'APPRAISAL_PERIOD_ID'
7435: AND elig.COLUMN_VALUE = p_appraisal_period_id
7436: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;

Line 10412: FROM ben_elig_obj_f elig

10408: IS
10409: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10410: IS
10411: SELECT elig.elig_obj_id
10412: FROM ben_elig_obj_f elig
10413: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
10414: AND elig.column_name = 'PLAN_ID'
10415: AND elig.COLUMN_VALUE = p_plan_id
10416: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;

Line 10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

10443: l_appr_ovn per_appraisals.object_version_number%TYPE;
10444: l_appr_id per_appraisals.appraisal_id%TYPE;
10445: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10446: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10447: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10448: l_person_name per_all_people_f.full_name%TYPE;
10449: l_qual_pop_index BINARY_INTEGER;
10450: l_curr_sc_pop_index BINARY_INTEGER;
10451: l_qual_obj_index BINARY_INTEGER;

Line 10933: FROM ben_elig_obj_f elig

10929: -- 23-Jun-2009 schowdhu Eligibility Profile Enhc.
10930: CURSOR get_elig_obj_id_for_person (p_plan_id IN per_perf_mgmt_plans.plan_id%TYPE)
10931: IS
10932: SELECT elig.elig_obj_id
10933: FROM ben_elig_obj_f elig
10934: WHERE elig.table_name = 'PER_PERF_MGMT_PLANS'
10935: AND elig.column_name = 'PLAN_ID'
10936: AND elig.COLUMN_VALUE = p_plan_id
10937: AND TRUNC (SYSDATE) BETWEEN elig.effective_start_date AND elig.effective_end_date;

Line 10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

10951: l_appr_ovn per_appraisals.object_version_number%TYPE;
10952: l_appr_id per_appraisals.appraisal_id%TYPE;
10953: l_appr_sys_status per_appraisals.appraisal_system_status%TYPE;
10954: l_appraiser_person_id per_appraisals.appraiser_person_id%TYPE;
10955: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
10956: l_person_name per_all_people_f.full_name%TYPE;
10957: l_task_codes VARCHAR2 (200);
10958: t_task_codes DBMS_UTILITY.lname_array;
10959: l_task_cnt BINARY_INTEGER;