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 DUAL

Line 274: FROM DUAL

270: --
271: CURSOR csr_chk_emp_sup (p_supervisor_id IN NUMBER)
272: IS
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

Line 287: FROM DUAL

283: --
284: CURSOR csr_chk_emp_sup_asg (p_supervisor_asg_id IN NUMBER)
285: IS
286: SELECT 'Y'
287: FROM DUAL
288: WHERE EXISTS (
289: SELECT 'x'
290: FROM per_all_assignments_f paaf, per_periods_of_service pps
291: WHERE paaf.assignment_id = p_supervisor_asg_id

Line 300: FROM DUAL

296: --
297: CURSOR csr_chk_cwk_sup (p_supervisor_id IN NUMBER)
298: IS
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

Line 313: FROM DUAL

309: --
310: CURSOR csr_chk_cwk_sup_asg (p_supervisor_asg_id IN NUMBER)
311: IS
312: SELECT 'Y'
313: FROM DUAL
314: WHERE EXISTS (
315: SELECT 'x'
316: FROM per_all_assignments_f paaf, per_periods_of_placement ppp
317: WHERE paaf.assignment_id = p_supervisor_asg_id

Line 751: FROM DUAL

747: DECODE (p_plan_rec.assignment_types_code,
748: 'E', ppf.current_employee_flag,
749: 'C', ppf.current_npw_flag,
750: 'EC', (SELECT 'Y'
751: FROM DUAL
752: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
753: )
754: ))) o
755: CONNECT BY o.supervisor_id = PRIOR o.person_id AND LEVEL <= NVL (p_plan_rec.hierarchy_levels, LEVEL) + 1

Line 784: FROM DUAL

780: DECODE (p_plan_rec.assignment_types_code,
781: 'E', ppf.current_employee_flag,
782: 'C', ppf.current_npw_flag,
783: 'EC', (SELECT 'Y'
784: FROM DUAL
785: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
786: )
787: ))) o
788: CONNECT BY o.supervisor_assignment_id = PRIOR o.assignment_id AND LEVEL <= NVL (p_plan_rec.hierarchy_levels, LEVEL) + 1

Line 815: FROM DUAL

811: DECODE (p_plan_rec.assignment_types_code,
812: 'E', ppf.current_employee_flag,
813: 'C', ppf.current_npw_flag,
814: 'EC', (SELECT 'Y'
815: FROM DUAL
816: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
817: )
818: ))
819: AND asg.organization_id IN (

Line 830: FROM DUAL) o,

826: START WITH o.organization_id_parent = p_plan_rec.top_organization_id
827: AND o.org_structure_version_id = p_plan_rec.org_structure_version_id
828: UNION
829: SELECT p_plan_rec.top_organization_id organization_id_child
830: FROM DUAL) o,
831: hr_organization_units org
832: WHERE o.organization_id_child = org.organization_id
833: AND p_effective_date BETWEEN org.date_from AND NVL (org.date_to, p_effective_date));
834:

Line 859: FROM DUAL

855: DECODE (p_plan_rec.assignment_types_code,
856: 'E', ppf.current_employee_flag,
857: 'C', ppf.current_npw_flag,
858: 'EC', (SELECT 'Y'
859: FROM DUAL
860: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
861: )
862: ))
863: AND (asg.position_id IN (

Line 877: FROM DUAL)

873: WHERE o.subordinate_position_id = pos.position_id
874: AND p_effective_date BETWEEN pos.date_effective AND NVL (pos.date_end, p_effective_date)
875: UNION
876: SELECT p_plan_rec.top_position_id subordinate_position_id
877: FROM DUAL)
878: );
879:
880: CURSOR csr_apprl_periods (p_pln_id per_perf_mgmt_plans.plan_id%TYPE)
881: IS

Line 3975: FROM DUAL;

3971: -- Derive the item key
3972: --
3973: SELECT hr_workflow_item_key_s.NEXTVAL
3974: INTO l_item_key
3975: FROM DUAL;
3976:
3977: --
3978: -- Derive the other values based on plan action
3979: --

Line 4427: FROM DUAL

4423:
4424: CURSOR csr_chk_sc_exists (p_assignment_id NUMBER, p_plan_id NUMBER)
4425: IS
4426: SELECT 'Y'
4427: FROM DUAL
4428: WHERE EXISTS (SELECT 'X'
4429: FROM per_personal_scorecards
4430: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id);
4431: --

Line 4678: FROM DUAL;

4674: -- WPM Logging Changes
4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
4676: SELECT per_wpm_batch_actions_s.NEXTVAL
4677: INTO l_wpm_batch_action_id
4678: FROM DUAL;
4679:
4680: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
4681:
4682: INSERT INTO per_wpm_batch_actions

Line 7064: FROM DUAL

7060: --sussuman 13657400
7061: CURSOR csr_sc_exists (p_plan_id IN NUMBER)
7062: IS
7063: SELECT 'Y'
7064: FROM DUAL
7065: WHERE EXISTS (SELECT NULL
7066: FROM per_personal_scorecards
7067: WHERE plan_id = p_plan_id);
7068:

Line 7747: FROM DUAL

7743: --
7744: CURSOR csr_apprs_exist (p_plan_id IN NUMBER)
7745: IS
7746: SELECT 'Y'
7747: FROM DUAL
7748: WHERE EXISTS (SELECT 'x'
7749: FROM per_appraisals
7750: WHERE plan_id = p_plan_id);
7751:

Line 8447: FROM DUAL

8443: DECODE (g_plan_dtls (1).assignment_types_code,
8444: 'E', ppf.current_employee_flag,
8445: 'C', ppf.current_npw_flag,
8446: 'EC', (SELECT 'Y'
8447: FROM DUAL
8448: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
8449: )
8450: ))) o
8451: CONNECT BY o.supervisor_id = PRIOR o.person_id AND LEVEL <= NVL (g_plan_dtls (1).hierarchy_levels, LEVEL) + 1

Line 8480: FROM DUAL

8476: DECODE (g_plan_dtls (1).assignment_types_code,
8477: 'E', ppf.current_employee_flag,
8478: 'C', ppf.current_npw_flag,
8479: 'EC', (SELECT 'Y'
8480: FROM DUAL
8481: WHERE ppf.current_employee_flag = 'Y' OR ppf.current_npw_flag = 'Y')
8482: )
8483: ))) o
8484: CONNECT BY o.supervisor_assignment_id = PRIOR o.assignment_id

Line 8700: FROM DUAL

8696: BEGIN
8697: l_exists := 'N';
8698: SELECT 'Y'
8699: INTO l_exists
8700: FROM DUAL
8701: WHERE EXISTS (Select 'x'
8702: FROM per_objectives
8703: WHERE scorecard_id = p_target_sc_id
8704: AND (copied_from_library_id = i.copied_from_library_id

Line 8819: FROM DUAL

8815:
8816: CURSOR csr_chk_appr_in_progress (p_scorecard_id IN NUMBER, p_eff_date IN DATE)
8817: IS
8818: SELECT 'Y'
8819: FROM DUAL
8820: WHERE EXISTS (
8821: SELECT 'x'
8822: FROM per_personal_scorecards sc, per_perf_mgmt_plans pl, per_appraisal_periods ap
8823: WHERE sc.scorecard_id = p_scorecard_id

Line 8893: FROM dual

8889: AND participation_type <> 'MAINAP'
8890: AND participation_status = 'OPEN';
8891: CURSOR csr_chek_appr_exist (p_plan_id IN NUMBER) IS
8892: SELECT 'Y'
8893: FROM dual
8894: WHERE EXISTS (SELECT 'X'
8895: FROM per_appraisals
8896: WHERE plan_id = p_plan_id
8897: AND appraisal_system_status <> 'DELETED');

Line 9621: FROM DUAL

9617:
9618: CURSOR csr_chk_sc_exists (p_assignment_id NUMBER, p_plan_id NUMBER)
9619: IS
9620: SELECT 'Y'
9621: FROM DUAL
9622: WHERE EXISTS (SELECT 'X'
9623: FROM per_personal_scorecards
9624: WHERE plan_id = p_plan_id AND assignment_id = p_assignment_id);
9625: BEGIN

Line 9718: FROM DUAL

9714:
9715: CURSOR csr_sc_exist (p_plan_id IN NUMBER)
9716: IS
9717: SELECT 'Y'
9718: FROM DUAL
9719: WHERE EXISTS (SELECT 'x'
9720: FROM per_personal_scorecards
9721: WHERE plan_id = p_plan_id);
9722:

Line 11101: FROM DUAL

11097:
11098: CURSOR csr_sc_exist (p_plan_id IN NUMBER)
11099: IS
11100: SELECT 'Y'
11101: FROM DUAL
11102: WHERE EXISTS (SELECT 'x'
11103: FROM per_personal_scorecards
11104: WHERE plan_id = p_plan_id);
11105:

Line 11129: FROM DUAL;

11125: --
11126: -- WPM Logging Changes
11127: SELECT per_wpm_batch_actions_s.NEXTVAL
11128: INTO l_wpm_batch_action_id
11129: FROM DUAL;
11130:
11131: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
11132:
11133: INSERT INTO per_wpm_batch_actions