APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 279: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------

275: ---------------------------------------------------------------
276: -- END OF BEN_PRTN_ELIG_F ----------------------
277: ---------------------------------------------------------------
278: ---------------------------------------------------------------
279: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------
280: ---------------------------------------------------------------
281: cursor c_cep_from_parent(c_PRTN_ELIG_ID number) is
282: select distinct prtn_elig_prfl_id
283: from BEN_PRTN_ELIG_PRFL_F

Line 283: from BEN_PRTN_ELIG_PRFL_F

279: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------
280: ---------------------------------------------------------------
281: cursor c_cep_from_parent(c_PRTN_ELIG_ID number) is
282: select distinct prtn_elig_prfl_id
283: from BEN_PRTN_ELIG_PRFL_F
284: where PRTN_ELIG_ID = c_PRTN_ELIG_ID;
285: --
286: cursor c_cep(c_prtn_elig_prfl_id number,c_mirror_src_entity_result_id number ,
287: c_table_alias varchar2 ) is

Line 289: from BEN_PRTN_ELIG_PRFL_F cep

285: --
286: cursor c_cep(c_prtn_elig_prfl_id number,c_mirror_src_entity_result_id number ,
287: c_table_alias varchar2 ) is
288: select cep.*
289: from BEN_PRTN_ELIG_PRFL_F cep
290: where cep.prtn_elig_prfl_id = c_prtn_elig_prfl_id
291: -- and cep.business_group_id = p_business_group_id
292: and not exists (
293: select /* */ null

Line 300: -- and trt.where_clause = 'BEN_PRTN_ELIG_PRFL_F'

296: where copy_entity_txn_id = p_copy_entity_txn_id
297: -- and trt.table_route_id = cpe.table_route_id
298: and ( -- c_mirror_src_entity_result_id is null or
299: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
300: -- and trt.where_clause = 'BEN_PRTN_ELIG_PRFL_F'
301: and cpe.table_alias = c_table_alias
302: and information1 = c_prtn_elig_prfl_id
303: -- and information4 = cep.business_group_id
304: and information2 = cep.effective_start_date

Line 310: -- END OF BEN_PRTN_ELIG_PRFL_F ----------------------

306: );
307: l_prtn_elig_prfl_id number(15);
308: l_out_cep_result_id number(15);
309: ---------------------------------------------------------------
310: -- END OF BEN_PRTN_ELIG_PRFL_F ----------------------
311: ---------------------------------------------------------------
312:
313: cursor c_elp_from_parent(c_PRTN_ELIG_PRFL_ID number) is
314: select distinct eligy_prfl_id

Line 315: from BEN_PRTN_ELIG_PRFL_F

311: ---------------------------------------------------------------
312:
313: cursor c_elp_from_parent(c_PRTN_ELIG_PRFL_ID number) is
314: select distinct eligy_prfl_id
315: from BEN_PRTN_ELIG_PRFL_F
316: where PRTN_ELIG_PRFL_ID = c_PRTN_ELIG_PRFL_ID;
317:
318: ---------------------------------------------------------------
319: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------

Line 359: l_mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type;

355: l_result_type_cd varchar2(30);
356: l_information5 ben_copy_entity_results.information5%type;
357: l_number_of_copies number(15);
358:
359: l_mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type;
360:
361: TYPE rt_ref_csr_typ IS REF CURSOR;
362: c_parent_rec rt_ref_csr_typ;
363: l_parent_rec BEN_PRTN_ELIG_F%ROWTYPE;

Line 636: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------

632:
633: end loop;
634: --
635: ---------------------------------------------------------------
636: -- START OF BEN_PRTN_ELIG_PRFL_F ----------------------
637: ---------------------------------------------------------------
638: --
639: for l_parent_rec in c_cep_from_parent(l_PRTN_ELIG_ID) loop
640: --

Line 678: p_parent_entity_result_id => l_dummy_parent_entity_rslt_id, -- 4990825 SHOW BEN_PRTN_ELIG_PRFL_F as child for HGrid

674: p_copy_entity_result_id => l_copy_entity_result_id,
675: p_copy_entity_txn_id => p_copy_entity_txn_id,
676: p_result_type_cd => l_result_type_cd,
677: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
678: p_parent_entity_result_id => l_dummy_parent_entity_rslt_id, -- 4990825 SHOW BEN_PRTN_ELIG_PRFL_F as child for HGrid
679: p_number_of_copies => l_number_of_copies,
680: p_table_route_id => l_table_route_id,
681: P_TABLE_ALIAS => 'CEP',
682: p_information1 => l_cep_rec.prtn_elig_prfl_id,

Line 781: -- END OF BEN_PRTN_ELIG_PRFL_F ----------------------

777: --reset the global allow dup results to as it was before
778:
779: end loop;
780: ---------------------------------------------------------------
781: -- END OF BEN_PRTN_ELIG_PRFL_F ----------------------
782: ---------------------------------------------------------------
783: ---------------------------------------------------------------
784: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------
785: ---------------------------------------------------------------