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.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_GROUP_HRCHY

Line 735: , ben_cwb_group_hrchy bcgh

731: ,
732: (
733: SELECT bcpi.full_name
734: FROM ben_cwb_person_info bcpi
735: , ben_cwb_group_hrchy bcgh
736: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
737: AND bcgh.lvl_num =
738: (
739: SELECT max (lvl_num) - 1 + 1

Line 740: FROM ben_cwb_group_hrchy

736: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
737: AND bcgh.lvl_num =
738: (
739: SELECT max (lvl_num) - 1 + 1
740: FROM ben_cwb_group_hrchy
741: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
742: )
743: AND bcgh.lvl_num > 0
744: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 750: , ben_cwb_group_hrchy bcgh

746: ,
747: (
748: SELECT bcpi.full_name
749: FROM ben_cwb_person_info bcpi
750: , ben_cwb_group_hrchy bcgh
751: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
752: AND bcgh.lvl_num =
753: (
754: SELECT max (lvl_num) - 2 + 1

Line 755: FROM ben_cwb_group_hrchy

751: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
752: AND bcgh.lvl_num =
753: (
754: SELECT max (lvl_num) - 2 + 1
755: FROM ben_cwb_group_hrchy
756: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
757: )
758: AND bcgh.lvl_num > 0
759: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 765: , ben_cwb_group_hrchy bcgh

761: ,
762: (
763: SELECT bcpi.full_name
764: FROM ben_cwb_person_info bcpi
765: , ben_cwb_group_hrchy bcgh
766: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
767: AND bcgh.lvl_num =
768: (
769: SELECT max (lvl_num) - 3 + 1

Line 770: FROM ben_cwb_group_hrchy

766: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
767: AND bcgh.lvl_num =
768: (
769: SELECT max (lvl_num) - 3 + 1
770: FROM ben_cwb_group_hrchy
771: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
772: )
773: AND bcgh.lvl_num > 0
774: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 780: , ben_cwb_group_hrchy bcgh

776: ,
777: (
778: SELECT bcpi.full_name
779: FROM ben_cwb_person_info bcpi
780: , ben_cwb_group_hrchy bcgh
781: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
782: AND bcgh.lvl_num =
783: (
784: SELECT max (lvl_num) - 4 + 1

Line 785: FROM ben_cwb_group_hrchy

781: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
782: AND bcgh.lvl_num =
783: (
784: SELECT max (lvl_num) - 4 + 1
785: FROM ben_cwb_group_hrchy
786: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
787: )
788: AND bcgh.lvl_num > 0
789: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 795: , ben_cwb_group_hrchy bcgh

791: ,
792: (
793: SELECT bcpi.full_name
794: FROM ben_cwb_person_info bcpi
795: , ben_cwb_group_hrchy bcgh
796: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
797: AND bcgh.lvl_num =
798: (
799: SELECT max (lvl_num) - 5 + 1

Line 800: FROM ben_cwb_group_hrchy

796: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
797: AND bcgh.lvl_num =
798: (
799: SELECT max (lvl_num) - 5 + 1
800: FROM ben_cwb_group_hrchy
801: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
802: )
803: AND bcgh.lvl_num > 0
804: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 810: , ben_cwb_group_hrchy bcgh

806: ,
807: (
808: SELECT bcpi.full_name
809: FROM ben_cwb_person_info bcpi
810: , ben_cwb_group_hrchy bcgh
811: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
812: AND bcgh.lvl_num =
813: (
814: SELECT max (lvl_num) - 6 + 1

Line 815: FROM ben_cwb_group_hrchy

811: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
812: AND bcgh.lvl_num =
813: (
814: SELECT max (lvl_num) - 6 + 1
815: FROM ben_cwb_group_hrchy
816: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
817: )
818: AND bcgh.lvl_num > 0
819: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 825: , ben_cwb_group_hrchy bcgh

821: ,
822: (
823: SELECT bcpi.full_name
824: FROM ben_cwb_person_info bcpi
825: , ben_cwb_group_hrchy bcgh
826: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
827: AND bcgh.lvl_num =
828: (
829: SELECT max (lvl_num) - 7 + 1

Line 830: FROM ben_cwb_group_hrchy

826: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
827: AND bcgh.lvl_num =
828: (
829: SELECT max (lvl_num) - 7 + 1
830: FROM ben_cwb_group_hrchy
831: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
832: )
833: AND bcgh.lvl_num > 0
834: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 840: , ben_cwb_group_hrchy bcgh

836: ,
837: (
838: SELECT bcpi.full_name
839: FROM ben_cwb_person_info bcpi
840: , ben_cwb_group_hrchy bcgh
841: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
842: AND bcgh.lvl_num =
843: (
844: SELECT max (lvl_num) - 8 + 1

Line 845: FROM ben_cwb_group_hrchy

841: WHERE bcgh.emp_per_in_ler_id = per.group_per_in_ler_id
842: AND bcgh.lvl_num =
843: (
844: SELECT max (lvl_num) - 8 + 1
845: FROM ben_cwb_group_hrchy
846: WHERE emp_per_in_ler_id = per.group_per_in_ler_id
847: )
848: AND bcgh.lvl_num > 0
849: AND bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id

Line 862: FROM ben_cwb_group_hrchy hrchy1

858: (
859: SELECT decode (temp.name_profile, 'BN'
860: , mgrper.brief_name, 'CN'
861: , mgrper.custom_name, mgrper.full_name)
862: FROM ben_cwb_group_hrchy hrchy1
863: , ben_cwb_person_info mgrper
864: WHERE hrchy1.emp_per_in_ler_id = per.group_per_in_ler_id
865: AND hrchy1.lvl_num = 1
866: AND hrchy1.mgr_per_in_ler_id = mgrper.group_per_in_ler_id