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: --
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
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,
247: end if;
248: --
249: END sum_query;
250: --
251: end ben_sum;