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 PER_ALL_PEOPLE_F

Line 277: FROM per_all_people_f ppf, per_periods_of_service pps

273: SELECT 'Y'
274: FROM DUAL
275: WHERE EXISTS (
276: SELECT 'x'
277: FROM per_all_people_f ppf, per_periods_of_service pps
278: WHERE ppf.person_id = p_supervisor_id
279: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
280: AND ppf.person_id = pps.person_id
281: AND TRUNC (SYSDATE) BETWEEN pps.date_start AND NVL (pps.actual_termination_date, TRUNC (SYSDATE)));

Line 303: FROM per_all_people_f ppf, per_periods_of_placement ppp

299: SELECT 'Y'
300: FROM DUAL
301: WHERE EXISTS (
302: SELECT 'x'
303: FROM per_all_people_f ppf, per_periods_of_placement ppp
304: WHERE ppf.person_id = p_supervisor_id
305: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
306: AND ppf.person_id = ppp.person_id
307: AND TRUNC (SYSDATE) BETWEEN ppp.date_start AND NVL (ppp.actual_termination_date, TRUNC (SYSDATE)));

Line 743: FROM per_all_people_f ppf

739: OR p_plan_rec.primary_asg_only_flag = 'Y' AND asg.primary_flag = 'Y'
740: )
741: AND 'x' =
742: (SELECT 'x'
743: FROM per_all_people_f ppf
744: WHERE asg.person_id = ppf.person_id
745: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
746: AND ('Y' =
747: DECODE (p_plan_rec.assignment_types_code,

Line 776: FROM per_all_people_f ppf

772: )
773: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
774: AND 'x' =
775: (SELECT 'x'
776: FROM per_all_people_f ppf
777: WHERE asg.person_id = ppf.person_id
778: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
779: AND ('Y' =
780: DECODE (p_plan_rec.assignment_types_code,

Line 807: FROM per_all_people_f ppf

803: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
804: AND ((p_plan_rec.primary_asg_only_flag = 'N') OR p_plan_rec.primary_asg_only_flag = 'Y' AND asg.primary_flag = 'Y')
805: AND 'x' =
806: (SELECT 'x'
807: FROM per_all_people_f ppf
808: WHERE asg.person_id = ppf.person_id
809: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
810: AND ('Y' =
811: DECODE (p_plan_rec.assignment_types_code,

Line 851: FROM per_all_people_f ppf

847: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
848: AND ((p_plan_rec.primary_asg_only_flag = 'N') OR p_plan_rec.primary_asg_only_flag = 'Y' AND asg.primary_flag = 'Y')
849: AND 'x' =
850: (SELECT 'x'
851: FROM per_all_people_f ppf
852: WHERE asg.person_id = ppf.person_id
853: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
854: AND ('Y' =
855: DECODE (p_plan_rec.assignment_types_code,

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

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;
4909:
4910: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
4911: IS
4912: SELECT full_name
4913: FROM per_all_people_f ppf
4914: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;

Line 4913: FROM per_all_people_f ppf

4909:
4910: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
4911: IS
4912: SELECT full_name
4913: FROM per_all_people_f ppf
4914: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
4915:
4916: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
4917: l_obj_date DATE := TRUNC (SYSDATE);

Line 4927: l_person_name per_all_people_f.full_name%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
4931: --

Line 7730: FROM per_people_f papf, per_assignments_f paaf, per_all_people_f suppapf

7726: CURSOR csr_person_dtls (p_assignment_id IN NUMBER, p_effective_date IN DATE)
7727: IS
7728: SELECT papf.person_id, papf.full_name full_name, paaf.assignment_id, paaf.assignment_number, paaf.position_id,
7729: paaf.organization_id, paaf.supervisor_id, paaf.supervisor_assignment_id, suppapf.full_name supervisor_name
7730: FROM per_people_f papf, per_assignments_f paaf, per_all_people_f suppapf
7731: WHERE paaf.assignment_id = p_assignment_id
7732: AND papf.person_id = paaf.person_id
7733: AND p_effective_date BETWEEN papf.effective_start_date AND papf.effective_end_date
7734: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 8439: FROM per_all_people_f ppf

8435: OR g_plan_dtls (1).primary_asg_only_flag = 'Y' AND asg.primary_flag = 'Y'
8436: )
8437: AND 'x' =
8438: (SELECT 'x'
8439: FROM per_all_people_f ppf
8440: WHERE asg.person_id = ppf.person_id
8441: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
8442: AND ('Y' =
8443: DECODE (g_plan_dtls (1).assignment_types_code,

Line 8472: FROM per_all_people_f ppf

8468: )
8469: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
8470: AND 'x' =
8471: (SELECT 'x'
8472: FROM per_all_people_f ppf
8473: WHERE asg.person_id = ppf.person_id
8474: AND p_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
8475: AND ('Y' =
8476: DECODE (g_plan_dtls (1).assignment_types_code,

Line 8851: FROM per_all_people_f ppf, per_personal_scorecards pps

8847:
8848: CURSOR csr_person_full_name (p_sc_id IN NUMBER)
8849: IS
8850: SELECT hr_person_name.get_list_name(ppf.global_name, ppf.local_name) full_name
8851: FROM per_all_people_f ppf, per_personal_scorecards pps
8852: WHERE ppf.person_id = pps.person_id
8853: AND pps.scorecard_id = p_sc_id
8854: AND TRUNC(SYSDATE) between ppf.effective_start_date and ppf.effective_end_date;
8855:

Line 9365: p_full_name per_all_people_f.full_name%TYPE

9361: PROCEDURE send_message_notification (
9362: p_person_id IN NUMBER,
9363: p_message VARCHAR2,
9364: p_plan_id per_perf_mgmt_plans.plan_id%TYPE DEFAULT NULL,
9365: p_full_name per_all_people_f.full_name%TYPE
9366: )
9367: IS
9368: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
9369: IS

Line 9368: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)

9364: p_plan_id per_perf_mgmt_plans.plan_id%TYPE DEFAULT NULL,
9365: p_full_name per_all_people_f.full_name%TYPE
9366: )
9367: IS
9368: CURSOR get_role (person_id per_all_people_f.person_id%TYPE)
9369: IS
9370: SELECT wf.NAME role_name
9371: FROM wf_roles wf
9372: WHERE wf.orig_system = 'PER' AND wf.orig_system_id = person_id;

Line 9383: FROM per_all_people_f

9379:
9380: CURSOR csr_full_name
9381: IS
9382: SELECT full_name
9383: FROM per_all_people_f
9384: WHERE person_id = p_person_id AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
9385:
9386: l_full_name per_all_people_f.full_name%TYPE;
9387: l_plan_rec csr_plan_det%ROWTYPE;

Line 9386: l_full_name per_all_people_f.full_name%TYPE;

9382: SELECT full_name
9383: FROM per_all_people_f
9384: WHERE person_id = p_person_id AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
9385:
9386: l_full_name per_all_people_f.full_name%TYPE;
9387: l_plan_rec csr_plan_det%ROWTYPE;
9388: --bug14046867 declaring a variable to hold the source plan details
9389: l_src_plan_rec csr_plan_det%ROWTYPE;
9390: --bug14046867

Line 9510: CURSOR get_supervisor_id (person_id per_all_people_f.person_id%TYPE)

9506: p_assignment_id per_all_assignments_f.assignment_id%TYPE
9507: )
9508: RETURN NUMBER
9509: IS
9510: CURSOR get_supervisor_id (person_id per_all_people_f.person_id%TYPE)
9511: IS
9512: --8262552 Changes to get the correct supervisor Id based on assignment Id
9513: SELECT supervisor_id
9514: FROM per_all_assignments_f

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

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;
10417:
10418: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
10419: IS
10420: SELECT full_name
10421: FROM per_all_people_f ppf
10422: WHERE ppf.person_id = p_person_id AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;

Line 10421: FROM per_all_people_f ppf

10417:
10418: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
10419: IS
10420: SELECT full_name
10421: FROM per_all_people_f ppf
10422: WHERE ppf.person_id = p_person_id AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
10423: CURSOR csr_find_appr_for_scorecard (
10424: p_plan_id per_appraisals.plan_id%TYPE,
10425: p_scorecard_id per_personal_scorecards.scorecard_id%TYPE

Line 10448: l_person_name per_all_people_f.full_name%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;
10452: l_check_elig VARCHAR2 (1);

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

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;
10938:
10939: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
10940: IS
10941: SELECT full_name
10942: FROM per_all_people_f ppf
10943: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;

Line 10942: FROM per_all_people_f ppf

10938:
10939: CURSOR get_person_name (p_person_id IN per_all_people_f.person_id%TYPE)
10940: IS
10941: SELECT full_name
10942: FROM per_all_people_f ppf
10943: WHERE ppf.person_id = p_person_id AND l_effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date;
10944:
10945: l_plan_rec per_perf_mgmt_plans%ROWTYPE;
10946: l_obj_date DATE := TRUNC (SYSDATE);

Line 10956: l_person_name per_all_people_f.full_name%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;
10960: BEGIN