APPS.BEN_POPULATE_RBV dependencies on BEN_PTNL_LER_FOR_PER

Line 6: Type t_ppl_tab is table of ben_ptnl_ler_for_per%rowtype index by binary_integer;

2: /* $Header: benrbvpo.pkb 120.0 2005/05/28 09:25:06 appldev noship $ */
3: --
4: g_package varchar2(50) := 'ben_populate_rbv.';
5: --
6: Type t_ppl_tab is table of ben_ptnl_ler_for_per%rowtype index by binary_integer;
7: Type t_pil_tab is table of ben_per_in_ler%rowtype index by binary_integer;
8: Type t_crp_tab is table of ben_cbr_per_in_ler%rowtype index by binary_integer;
9: Type t_cqb_tab is table of ben_cbr_quald_bnf%rowtype index by binary_integer;
10: Type t_pep_tab is table of ben_elig_per_f%rowtype index by binary_integer;

Line 42: insert into ben_ptnl_ler_for_per_rbv

38: --
39: for elenum in p_ppl_set.first..p_ppl_set.last
40: loop
41: --
42: insert into ben_ptnl_ler_for_per_rbv
43: (ptnl_ler_for_per_id
44: ,business_group_id
45: ,lf_evt_ocrd_dt
46: ,ler_id

Line 2970: from ben_ptnl_ler_for_per ppl

2966: ,c_lu_dt date
2967: )
2968: is
2969: select ppl.*
2970: from ben_ptnl_ler_for_per ppl
2971: where ppl.person_id = c_per_id
2972: and ppl.last_update_date
2973: between c_lu_dt and sysdate
2974: order by ppl.ptnl_ler_for_per_id;

Line 3448: l_table_name := 'BEN_PTNL_LER_FOR_PER_RBV';

3444: ||' l_bft_ludtm: '||to_char(l_bft_ludtm,'DD-MON-YYYY-HH24-MI-SS')
3445: );
3446: --
3447: */
3448: l_table_name := 'BEN_PTNL_LER_FOR_PER_RBV';
3449: l_elenum := 0;
3450: --
3451: for row in c_pplrbv
3452: (c_per_id => l_person_id