DBA Data[Home] [Help]

APPS.BEN_SUM dependencies on BEN_SUM

Line 1: package body ben_sum as

1: package body ben_sum as
2: /* $Header: bensumfm.pkb 115.1 2003/02/12 10:30:35 rpgupta noship $ */
3: --
4: g_package varchar2(50) := 'ben_sum.';
5: --

Line 4: g_package varchar2(50) := 'ben_sum.';

1: package body ben_sum as
2: /* $Header: bensumfm.pkb 115.1 2003/02/12 10:30:35 rpgupta noship $ */
3: --
4: g_package varchar2(50) := 'ben_sum.';
5: --
6: PROCEDURE sum_query
7: (block_data IN OUT NOCOPY sumtab
8: ,p_person_id IN NUMBER

Line 36: SELECT /*+ ben_sum.sumselect */

32: (c_per_id number
33: ,c_eff_date date
34: )
35: is
36: SELECT /*+ ben_sum.sumselect */
37: pep.pgm_id order_num1,
38: -1 order_num2,
39: -1 order_num3,
40: pgm.name name,

Line 251: end ben_sum;

247: end if;
248: --
249: END sum_query;
250: --
251: end ben_sum;