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_UTIL dependencies on PER_SHARED_TYPES

Line 354: FROM per_shared_types

350: --
351: CURSOR csr_9box_new_potential (p_potential VARCHAR2)
352: IS
353: SELECT information1 --- return from BG specific. If not defined then Global
354: FROM per_shared_types
355: WHERE lookup_type = 'READINESS_LEVEL'
356: AND system_type_cd = p_potential
357: AND business_group_id = hr_general.get_business_group_id
358: UNION ALL

Line 360: FROM per_shared_types

356: AND system_type_cd = p_potential
357: AND business_group_id = hr_general.get_business_group_id
358: UNION ALL
359: SELECT information1
360: FROM per_shared_types
361: WHERE lookup_type = 'READINESS_LEVEL'
362: AND system_type_cd = p_potential
363: AND business_group_id IS NULL;
364:

Line 369: FROM per_shared_types

365: --
366: CURSOR csr_9box_old_potential (p_potential VARCHAR2)
367: IS
368: SELECT information1 --- return from BG specific. If not defined then Global
369: FROM per_shared_types
370: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
371: AND system_type_cd = p_potential
372: AND business_group_id = hr_general.get_business_group_id
373: UNION ALL

Line 375: FROM per_shared_types

371: AND system_type_cd = p_potential
372: AND business_group_id = hr_general.get_business_group_id
373: UNION ALL
374: SELECT information1
375: FROM per_shared_types
376: WHERE lookup_type = 'PER_SUCC_PLAN_POTENTIAL'
377: AND system_type_cd = p_potential
378: AND business_group_id IS NULL;
379: BEGIN

Line 459: FROM per_shared_types

455: CURSOR csr_9box_perf (p_perf VARCHAR2)
456: IS
457: SELECT information1 --- return from BG specific. If not defined then
458: GLOBAL
459: FROM per_shared_types
460: WHERE lookup_type = 'PERFORMANCE_RATING'
461: AND system_type_cd = p_perf
462: AND NVL (business_group_id, -1) =
463: NVL2 (business_group_id, hr_general.get_business_group_id,

Line 467: FROM per_shared_types

463: NVL2 (business_group_id, hr_general.get_business_group_id,
464: -1)
465: UNION ALL
466: SELECT information1
467: FROM per_shared_types
468: WHERE lookup_type = 'PERFORMANCE_RATING'
469: AND system_type_cd = p_perf
470: AND business_group_id IS NULL;
471: BEGIN

Line 532: FROM per_shared_types

528: --
529: CURSOR csr_9box_new_retention (p_retention VARCHAR2)
530: IS
531: SELECT information1 --- return from BG specific. If not defined then Global
532: FROM per_shared_types
533: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
534: AND system_type_cd = p_retention
535: AND business_group_id = hr_general.get_business_group_id
536: UNION ALL

Line 538: FROM per_shared_types

534: AND system_type_cd = p_retention
535: AND business_group_id = hr_general.get_business_group_id
536: UNION ALL
537: SELECT information1
538: FROM per_shared_types
539: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
540: AND system_type_cd = p_retention
541: AND business_group_id IS NULL;
542:

Line 547: FROM per_shared_types

543: --
544: CURSOR csr_9box_old_retention (p_retention VARCHAR2)
545: IS
546: SELECT information1 --- return from BG specific. If not defined then Global
547: FROM per_shared_types
548: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
549: AND system_type_cd = p_retention
550: AND business_group_id = hr_general.get_business_group_id
551: UNION ALL

Line 553: FROM per_shared_types

549: AND system_type_cd = p_retention
550: AND business_group_id = hr_general.get_business_group_id
551: UNION ALL
552: SELECT information1
553: FROM per_shared_types
554: WHERE lookup_type = 'PER_SUCC_PLAN_RISK_LEVEL'
555: AND system_type_cd = p_retention
556: AND business_group_id IS NULL;
557: BEGIN

Line 662: FROM per_shared_types

658:
659: CURSOR csr_9box_potential (p_potential VARCHAR2)
660: IS
661: SELECT information1 --- return from BG specific. If not defined then Global
662: FROM per_shared_types
663: WHERE lookup_type = 'READINESS_LEVEL'
664: AND system_type_cd = p_potential
665: AND business_group_id = hr_general.get_business_group_id
666: UNION ALL

Line 668: FROM per_shared_types

664: AND system_type_cd = p_potential
665: AND business_group_id = hr_general.get_business_group_id
666: UNION ALL
667: SELECT information1
668: FROM per_shared_types
669: WHERE lookup_type = 'READINESS_LEVEL'
670: AND system_type_cd = p_potential
671: AND business_group_id IS NULL;
672:

Line 728: FROM per_shared_types

724: --
725: CURSOR csr_9box_iol (p_iol VARCHAR2)
726: IS
727: SELECT information1 --- return from BG specific. If not defined then Global
728: FROM per_shared_types
729: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
730: AND system_type_cd = p_iol
731: AND business_group_id = hr_general.get_business_group_id
732: UNION ALL

Line 734: FROM per_shared_types

730: AND system_type_cd = p_iol
731: AND business_group_id = hr_general.get_business_group_id
732: UNION ALL
733: SELECT information1
734: FROM per_shared_types
735: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
736: AND system_type_cd = p_iol
737: AND business_group_id IS NULL;
738: BEGIN

Line 779: FROM per_shared_types

775: CURSOR csr_9box_perf (p_perf VARCHAR2)
776: IS
777: SELECT information1 --- return from BG specific. If not defined then
778: GLOBAL
779: FROM per_shared_types
780: WHERE lookup_type = 'PERFORMANCE_RATING'
781: AND system_type_cd = p_perf
782: AND NVL (business_group_id, -1) =
783: NVL2 (business_group_id, hr_general.get_business_group_id,

Line 787: FROM per_shared_types

783: NVL2 (business_group_id, hr_general.get_business_group_id,
784: -1)
785: UNION ALL
786: SELECT information1
787: FROM per_shared_types
788: WHERE lookup_type = 'PERFORMANCE_RATING'
789: AND system_type_cd = p_perf
790: AND business_group_id IS NULL;
791: BEGIN

Line 830: FROM per_shared_types

826:
827: CURSOR csr_9box_retention (p_retention VARCHAR2)
828: IS
829: SELECT information1 --- return from BG specific. If not defined then Global
830: FROM per_shared_types
831: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
832: AND system_type_cd = p_retention
833: AND business_group_id = hr_general.get_business_group_id
834: UNION ALL

Line 836: FROM per_shared_types

832: AND system_type_cd = p_retention
833: AND business_group_id = hr_general.get_business_group_id
834: UNION ALL
835: SELECT information1
836: FROM per_shared_types
837: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
838: AND system_type_cd = p_retention
839: AND business_group_id IS NULL;
840:

Line 889: FROM per_shared_types

885:
886: CURSOR csr_9box_iol (p_iol VARCHAR2)
887: IS
888: SELECT information1 --- return from BG specific. If not defined then Global
889: FROM per_shared_types
890: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
891: AND system_type_cd = p_iol
892: AND business_group_id = hr_general.get_business_group_id
893: UNION ALL

Line 895: FROM per_shared_types

891: AND system_type_cd = p_iol
892: AND business_group_id = hr_general.get_business_group_id
893: UNION ALL
894: SELECT information1
895: FROM per_shared_types
896: WHERE lookup_type = 'PER_SP_IMPACT_OF_LOSS'
897: AND system_type_cd = p_iol
898: AND business_group_id IS NULL;
899:

Line 903: FROM per_shared_types

899:
900: CURSOR csr_9box_retention (p_retention VARCHAR2)
901: IS
902: SELECT information1 --- return from BG specific. If not defined then Global
903: FROM per_shared_types
904: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
905: AND system_type_cd = p_retention
906: AND business_group_id = hr_general.get_business_group_id
907: UNION ALL

Line 909: FROM per_shared_types

905: AND system_type_cd = p_retention
906: AND business_group_id = hr_general.get_business_group_id
907: UNION ALL
908: SELECT information1
909: FROM per_shared_types
910: WHERE lookup_type = 'PER_RETENTION_POTENTIAL'
911: AND system_type_cd = p_retention
912: AND business_group_id IS NULL;
913: