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_SUMMARY_PKG dependencies on BEN_CWB_SUMMARY_S

Line 146: (ben_cwb_summary_s.nextval

142: ,lf_evt_ocrd_dt
143: ,status
144: ,person_id)
145: values
146: (ben_cwb_summary_s.nextval
147: ,-1
148: ,p_group_pl_id
149: ,p_lf_evt_ocrd_dt
150: ,'R'

Line 280: update ben_cwb_summary summ

276: hr_utility.set_location(l_proc, 40);
277: end if;
278: --
279: -- Found one unlocked record. So update the summary.
280: update ben_cwb_summary summ
281: set elig_count_direct = nvl2(summ.elig_count_direct,
282: summ.elig_count_direct+
283: nvl(p_sum_rec.elig_count_direct,0),
284: p_sum_rec.elig_count_direct)

Line 465: ben_cwb_summary_s.nextval

461: ,misc3_val_all
462: ,person_id
463: ,lf_evt_ocrd_dt)
464: values (
465: ben_cwb_summary_s.nextval
466: ,p_sum_rec.group_per_in_ler_id
467: ,p_sum_rec.group_pl_id
468: ,p_sum_rec.group_oipl_id
469: ,l_status

Line 521: from ben_cwb_summary summ

517:
518: -- get the records with status P
519: cursor csr_pending_recs(p_person_id number) is
520: select summ.*
521: from ben_cwb_summary summ
522: where summ.person_id = p_person_id
523: and summ.status = 'P'
524: order by summ.group_per_in_ler_id, summ.group_pl_id, summ.group_oipl_id;
525: --

Line 852: ,ben_cwb_summary summ

848: ws_bdgt_iss_val_direct
849: from ben_cwb_group_hrchy hrchy
850: ,ben_cwb_person_groups grp
851: ,ben_cwb_person_info info
852: ,ben_cwb_summary summ
853: where info.group_pl_id = p_group_pl_id
854: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
855: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id
856: and hrchy.lvl_num = 1

Line 906: ,ben_cwb_summary summ

902: ,sum(misc1_val_direct) misc1_val_all
903: ,sum(misc2_val_direct) misc2_val_all
904: ,sum(misc3_val_direct) misc3_val_all
905: from ben_cwb_group_hrchy hrchy
906: ,ben_cwb_summary summ
907: ,ben_cwb_person_info info
908: where info.group_pl_id = p_group_pl_id
909: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
910: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 931: ,ben_cwb_summary summ

927: summ.elig_sal_val_direct,summ.elig_sal_val_all) /100)
928: bdgt_iss_val_direct
929: from ben_cwb_group_hrchy hrchy
930: ,ben_cwb_person_groups grp
931: ,ben_cwb_summary summ
932: ,ben_cwb_person_info info
933: where info.group_pl_id = p_group_pl_id
934: and info.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
935: and info.group_per_in_ler_id = hrchy.emp_per_in_ler_id

Line 971: ben_cwb_summary.stat_sal_val_all%type;

967: ben_cwb_summary.bdgt_val_direct%type;
968: type bdgt_iss_val_direct_type is table of
969: ben_cwb_summary.bdgt_iss_val_direct%type;
970: type stat_sal_val_all_type is table of
971: ben_cwb_summary.stat_sal_val_all%type;
972: type oth_comp_val_all_type is table of
973: ben_cwb_summary.oth_comp_val_all%type;
974: type tot_comp_val_all_type is table of
975: ben_cwb_summary.tot_comp_val_all%type;

Line 1341: ben_cwb_summary.stat_sal_val_direct%type;

1337: type elig_sal_val_direct_type is table of
1338: ben_cwb_summary.elig_sal_val_direct%type;
1339: type ws_val_direct_type is table of ben_cwb_summary.ws_val_direct%type;
1340: type stat_sal_val_direct_type is table of
1341: ben_cwb_summary.stat_sal_val_direct%type;
1342: type oth_comp_val_direct_type is table of
1343: ben_cwb_summary.oth_comp_val_direct%type;
1344: type tot_comp_val_direct_type is table of
1345: ben_cwb_summary.tot_comp_val_direct%type;

Line 1416: select ben_cwb_summary_s.nextval

1412: ,group_pl_id
1413: ,group_oipl_id
1414: ,person_id
1415: ,lf_evt_ocrd_dt)
1416: select ben_cwb_summary_s.nextval
1417: ,hrchy.emp_per_in_ler_id
1418: ,p_group_pl_id
1419: ,grp.group_oipl_id
1420: ,pil.person_id

Line 1554: ,ben_cwb_summary summ

1550: summ.elig_sal_val_direct, summ.elig_sal_val_all) / 100)
1551: bdgt_iss_val_direct
1552: from ben_cwb_group_hrchy hrchy
1553: ,ben_cwb_person_groups grp
1554: ,ben_cwb_summary summ
1555: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1556: and hrchy.lvl_num = 1
1557: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1558: and summ.group_per_in_ler_id (+)= grp.group_per_in_ler_id

Line 1592: ,ben_cwb_summary summ

1588: ,sum(grp.ws_bdgt_iss_val * summ.elig_sal_val_direct / 100)
1589: ws_bdgt_iss_val_all
1590: from ben_cwb_group_hrchy hrchy
1591: ,ben_cwb_person_groups grp
1592: ,ben_cwb_summary summ
1593: where hrchy.mgr_per_in_ler_id = p_group_per_in_ler_id
1594: and hrchy.lvl_num >= 1
1595: and grp.group_per_in_ler_id = hrchy.emp_per_in_ler_id
1596: and summ.group_per_in_ler_id (+)= grp.group_per_in_ler_id

Line 1859: from ben_cwb_summary sm

1855: and grp.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
1856: and grp.group_per_in_ler_id = pil.per_in_ler_id
1857: and pil.per_in_ler_stat_cd in ('PROCD','STRTD')
1858: and not exists (select 'Y'
1859: from ben_cwb_summary sm
1860: where sm.group_per_in_ler_id = grp.group_per_in_ler_id
1861: and sm.group_pl_id = grp.group_pl_id
1862: and sm.group_oipl_id = grp.group_oipl_id)
1863: group by hrchy.mgr_per_in_ler_id, group_oipl_id, pil.person_id;

Line 1928: ,ben_cwb_summary summ

1924: ,sum(misc1_val_direct) misc1_val
1925: ,sum(misc2_val_direct) misc2_val
1926: ,sum(misc3_val_direct) misc3_val
1927: from ben_cwb_group_hrchy hrchy
1928: ,ben_cwb_summary summ
1929: where hrchy.mgr_per_in_ler_id = v_group_per_in_ler_id
1930: and hrchy.lvl_num >=0
1931: and hrchy.emp_per_in_ler_id = summ.group_per_in_ler_id
1932: group by hrchy.mgr_per_in_ler_id, summ.group_pl_id, summ.group_oipl_id;

Line 2007: values (ben_cwb_summary_s.nextval

2003: ,group_pl_id
2004: ,group_oipl_id
2005: ,person_id
2006: ,lf_evt_ocrd_dt)
2007: values (ben_cwb_summary_s.nextval
2008: ,l_empty_summ.mgr_per_in_ler_id
2009: ,l_empty_summ.group_pl_id
2010: ,l_empty_summ.group_oipl_id
2011: ,l_empty_summ.person_id

Line 2474: from ben_cwb_summary sm

2470: cursor c_summary is
2471: select sum(sm.elig_count_all)-sum(sm.elig_count_direct) indirect_count
2472: ,sum(sm.elig_count_all) all_count
2473: ,max(grp.bdgt_pop_cd) bdgt_pop_cd
2474: from ben_cwb_summary sm
2475: ,ben_cwb_person_groups grp
2476: where sm.group_per_in_ler_id = l_per_in_ler_id
2477: and sm.group_oipl_id = -1
2478: and sm.group_per_in_ler_id = grp.group_per_in_ler_id

Line 2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

2656: ben_cwb_summary.ws_val_direct%type index by binary_integer;
2657: type ws_val_all_type is table of
2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;

Line 2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;

2658: ben_cwb_summary.ws_val_all%type index by binary_integer;
2659: type stat_sal_val_direct_type is table of
2660: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
2661: type stat_sal_val_all_type is table of
2662: ben_cwb_summary.stat_sal_val_all%type index by binary_integer;
2663: type oth_comp_val_direct_type is table of
2664: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
2665: type oth_comp_val_all_type is table of
2666: ben_cwb_summary.oth_comp_val_all%type index by binary_integer;

Line 3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;

3158: ben_cwb_summary.elig_sal_val_direct%type index by binary_integer;
3159: type ws_val_direct_type is table of
3160: ben_cwb_summary.ws_val_direct%type index by binary_integer;
3161: type stat_sal_val_direct_type is table of
3162: ben_cwb_summary.stat_sal_val_direct%type index by binary_integer;
3163: type oth_comp_val_direct_type is table of
3164: ben_cwb_summary.oth_comp_val_direct%type index by binary_integer;
3165: type tot_comp_val_direct_type is table of
3166: ben_cwb_summary.tot_comp_val_direct%type index by binary_integer;

Line 3611: select ben_cwb_summary_s.nextval

3607: ,group_pl_id
3608: ,group_oipl_id
3609: ,person_id
3610: ,lf_evt_ocrd_dt)
3611: select ben_cwb_summary_s.nextval
3612: ,grp.group_per_in_ler_id
3613: ,grp.group_pl_id
3614: ,grp.group_oipl_id
3615: ,pil.person_id