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_SUM dependencies on BEN_BENEFITS_SUMMARY_V

Line 5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE

1: PACKAGE ben_sum AUTHID CURRENT_USER AS
2: /* $Header: bensumfm.pkh 115.1 2003/02/12 10:30:40 rpgupta noship $ */
3: --
4: TYPE sum_rec IS RECORD (
5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE
6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE

Line 6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE

2: /* $Header: bensumfm.pkh 115.1 2003/02/12 10:30:40 rpgupta noship $ */
3: --
4: TYPE sum_rec IS RECORD (
5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE
6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE

Line 7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE

3: --
4: TYPE sum_rec IS RECORD (
5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE
6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE

Line 8: ,NAME ben_benefits_summary_v.NAME%TYPE

4: TYPE sum_rec IS RECORD (
5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE
6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE

Line 9: ,ID ben_benefits_summary_v.ID%TYPE

5: ORDER_NUM1 ben_benefits_summary_v.ORDER_NUM1%TYPE
6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE

Line 10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE

6: ,ORDER_NUM2 ben_benefits_summary_v.ORDER_NUM2%TYPE
7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE
14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE

Line 11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE

7: ,ORDER_NUM3 ben_benefits_summary_v.ORDER_NUM3%TYPE
8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE
14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE
15: );

Line 12: ,MEANING ben_benefits_summary_v.MEANING%TYPE

8: ,NAME ben_benefits_summary_v.NAME%TYPE
9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE
14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE
15: );
16: --

Line 13: ,TYPE ben_benefits_summary_v.TYPE%TYPE

9: ,ID ben_benefits_summary_v.ID%TYPE
10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE
14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE
15: );
16: --
17: TYPE sumtab IS TABLE OF sum_rec INDEX BY BINARY_INTEGER;

Line 14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE

10: ,BUSINESS_GROUP_ID ben_benefits_summary_v.BUSINESS_GROUP_ID%TYPE
11: ,PERSON_ID ben_benefits_summary_v.PERSON_ID%TYPE
12: ,MEANING ben_benefits_summary_v.MEANING%TYPE
13: ,TYPE ben_benefits_summary_v.TYPE%TYPE
14: ,OBJECT_TYPE_CD ben_benefits_summary_v.OBJECT_TYPE_CD%TYPE
15: );
16: --
17: TYPE sumtab IS TABLE OF sum_rec INDEX BY BINARY_INTEGER;
18: --