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_WPM_MASS_APR_PUSH dependencies on PER_ALL_PEOPLE_F

Line 79: empl_start_date per_all_people_f.effective_start_date%TYPE,

75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,
81: person_id per_all_people_f.person_id%TYPE
82: );
83:

Line 80: empl_end_date per_all_people_f.effective_end_date%TYPE,

76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,
81: person_id per_all_people_f.person_id%TYPE
82: );
83:
84: --

Line 81: person_id per_all_people_f.person_id%TYPE

77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,
81: person_id per_all_people_f.person_id%TYPE
82: );
83:
84: --
85: -- Following is added with more details to be captured

Line 1060: p_person_id per_all_people_f.person_id%TYPE

1056: WHERE scorecard_id = p_scorecard_id;
1057:
1058: --changed cursor for fixing 6924829
1059: CURSOR get_assignment_info (
1060: p_person_id per_all_people_f.person_id%TYPE
1061: )
1062: IS
1063: SELECT paf.assignment_id, paf.business_group_id, paf.grade_id,
1064: paf.position_id, paf.job_id, paf.organization_id,

Line 1069: per_all_people_f ppf,

1065: paf.supervisor_id, paf.effective_start_date,
1066: pps.date_start empl_start_date,
1067: ppf.effective_end_date empl_end_date, ppf.person_id
1068: FROM per_all_assignments_f paf,
1069: per_all_people_f ppf,
1070: per_periods_of_service pps
1071: WHERE paf.person_id = p_person_id --8780710 bug fix
1072: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
1073: AND paf.effective_end_date

Line 1087: per_all_people_f ppf,

1083: paf.supervisor_id, paf.effective_start_date,
1084: pps.date_start empl_start_date,
1085: ppf.effective_end_date empl_end_date, ppf.person_id
1086: FROM per_all_assignments_f paf,
1087: per_all_people_f ppf,
1088: per_periods_of_placement pps
1089: WHERE paf.person_id = p_person_id --8780710 bug fix
1090: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date
1091: AND paf.effective_end_date

Line 1180: p_person_id per_all_people_f.person_id%TYPE

1176: FROM per_assessment_types
1177: WHERE assessment_type_id = p_assess_templ;
1178:
1179: CURSOR get_sec_asg_supervisors (
1180: p_person_id per_all_people_f.person_id%TYPE
1181: )
1182: IS
1183: SELECT DISTINCT (supervisor_id)
1184: FROM per_all_assignments_f

Line 2897: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)

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
2899: SELECT full_name
2900: FROM per_all_people_f ppf
2901: WHERE ppf.person_id = p_person_id

Line 2900: FROM per_all_people_f ppf

2896:
2897: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
2898: IS
2899: SELECT full_name
2900: FROM per_all_people_f ppf
2901: WHERE ppf.person_id = p_person_id
2902: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date
2903: AND ppf.effective_end_date;
2904: BEGIN

Line 3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl

3120: IS
3121: SELECT pa.plan_id, pa.appraiser_person_id, pa.object_version_number,
3122: usr.user_name, pa.main_appraiser_id, pa.appraisee_person_id,
3123: ppl.full_name
3124: FROM per_appraisals pa, fnd_user usr, per_all_people_f ppl
3125: WHERE appraisal_id = p_appraisal_id
3126: AND ppl.person_id = usr.employee_id(+)
3127: AND ppl.person_id = pa.main_appraiser_id
3128: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date

Line 3152: CURSOR get_role (p_person_id IN per_all_people_f.person_id%TYPE)

3148: SELECT instance_label
3149: FROM wf_process_activities
3150: WHERE instance_id = p_block_activity_id;
3151:
3152: CURSOR get_role (p_person_id IN per_all_people_f.person_id%TYPE)
3153: IS
3154: SELECT wf.NAME role_name, ppl.full_name
3155: FROM wf_roles wf, per_all_people_f ppl
3156: WHERE wf.orig_system = 'PER'

Line 3155: FROM wf_roles wf, per_all_people_f ppl

3151:
3152: CURSOR get_role (p_person_id IN per_all_people_f.person_id%TYPE)
3153: IS
3154: SELECT wf.NAME role_name, ppl.full_name
3155: FROM wf_roles wf, per_all_people_f ppl
3156: WHERE wf.orig_system = 'PER'
3157: AND wf.orig_system_id = p_person_id
3158: AND wf.orig_system_id = ppl.person_id
3159: AND TRUNC (SYSDATE) BETWEEN ppl.effective_start_date

Line 3172: l_main_appraiser_id per_all_people_f.person_id%TYPE;

3168: l_appraisal_id NUMBER;
3169: blockedactivityid NUMBER;
3170: l_instance_label VARCHAR2 (100);
3171: l_user_name fnd_user.user_name%TYPE;
3172: l_main_appraiser_id per_all_people_f.person_id%TYPE;
3173: l_appraisee_person_id per_all_people_f.person_id%TYPE;
3174: l_full_name per_all_people_f.full_name%TYPE;
3175: l_item_type VARCHAR2 (30);
3176: l_item_key VARCHAR2 (80);

Line 3173: l_appraisee_person_id per_all_people_f.person_id%TYPE;

3169: blockedactivityid NUMBER;
3170: l_instance_label VARCHAR2 (100);
3171: l_user_name fnd_user.user_name%TYPE;
3172: l_main_appraiser_id per_all_people_f.person_id%TYPE;
3173: l_appraisee_person_id per_all_people_f.person_id%TYPE;
3174: l_full_name per_all_people_f.full_name%TYPE;
3175: l_item_type VARCHAR2 (30);
3176: l_item_key VARCHAR2 (80);
3177: l_effective_date DATE

Line 3174: l_full_name per_all_people_f.full_name%TYPE;

3170: l_instance_label VARCHAR2 (100);
3171: l_user_name fnd_user.user_name%TYPE;
3172: l_main_appraiser_id per_all_people_f.person_id%TYPE;
3173: l_appraisee_person_id per_all_people_f.person_id%TYPE;
3174: l_full_name per_all_people_f.full_name%TYPE;
3175: l_item_type VARCHAR2 (30);
3176: l_item_key VARCHAR2 (80);
3177: l_effective_date DATE
3178: DEFAULT fnd_date.canonical_to_date (NVL (p_effective_date,

Line 3187: l_to_wkr_name per_all_people_f.full_name%TYPE;

3183: l_no_of_processed NUMBER DEFAULT 0;
3184: ecode NUMBER;
3185: emesg VARCHAR2 (4000);
3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;

Line 3189: l_to_mgr_name per_all_people_f.full_name%TYPE;

3185: emesg VARCHAR2 (4000);
3186: l_to_wkr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3193: ln_notification_id NUMBER;

Line 3191: l_to_nma_name per_all_people_f.full_name%TYPE;

3187: l_to_wkr_name per_all_people_f.full_name%TYPE;
3188: l_to_mgr_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3189: l_to_mgr_name per_all_people_f.full_name%TYPE;
3190: l_to_nma_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3191: l_to_nma_name per_all_people_f.full_name%TYPE;
3192: l_from_role wf_local_roles.NAME%TYPE DEFAULT NULL;
3193: ln_notification_id NUMBER;
3194: l_dummy VARCHAR2 (1) DEFAULT 'N';
3195: l_plan_id per_personal_scorecards.plan_id%TYPE;