APPS.BEN_POPULATE_RBV dependencies on BEN_CBR_PER_IN_LER

Line 8: Type t_crp_tab is table of ben_cbr_per_in_ler%rowtype index by binary_integer;

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;
11: Type t_epo_tab is table of ben_elig_per_opt_f%rowtype index by binary_integer;
12: Type t_epe_tab is table of ben_elig_per_elctbl_chc%rowtype index by binary_integer;

Line 262: insert into ben_cbr_per_in_ler_rbv

258: --
259: for elenum in p_crp_set.first ..p_crp_set.last
260: loop
261: --
262: insert into ben_cbr_per_in_ler_rbv
263: (cbr_per_in_ler_id
264: ,init_evt_flag
265: ,per_in_ler_id
266: ,cbr_quald_bnf_id

Line 2994: from ben_cbr_per_in_ler crp,

2990: ,c_lu_dt date
2991: )
2992: is
2993: select crp.*
2994: from ben_cbr_per_in_ler crp,
2995: ben_per_in_ler pil
2996: where pil.person_id = c_per_id
2997: and crp.per_in_ler_id = pil.per_in_ler_id
2998: and crp.last_update_date

Line 3500: l_table_name := 'BEN_CBR_PER_IN_LER_RBV';

3496: ,p_person_action_id => p_person_action_id
3497: ,p_pil_set => l_pil_set
3498: );
3499: --
3500: l_table_name := 'BEN_CBR_PER_IN_LER_RBV';
3501: l_elenum := 0;
3502: --
3503: for row in c_crprbv
3504: (c_per_id => l_person_id