APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_PRTN_ELIGY_RL_F

Line 319: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------

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 ----------------------
320: ---------------------------------------------------------------
321: cursor c_cer_from_parent(c_PRTN_ELIG_ID number) is
322: select prtn_eligy_rl_id
323: from BEN_PRTN_ELIGY_RL_F

Line 323: from BEN_PRTN_ELIGY_RL_F

319: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------
320: ---------------------------------------------------------------
321: cursor c_cer_from_parent(c_PRTN_ELIG_ID number) is
322: select prtn_eligy_rl_id
323: from BEN_PRTN_ELIGY_RL_F
324: where PRTN_ELIG_ID = c_PRTN_ELIG_ID ;
325: --
326: cursor c_cer(c_prtn_eligy_rl_id number,c_mirror_src_entity_result_id number ,
327: c_table_alias varchar2 ) is

Line 329: from BEN_PRTN_ELIGY_RL_F cer

325: --
326: cursor c_cer(c_prtn_eligy_rl_id number,c_mirror_src_entity_result_id number ,
327: c_table_alias varchar2 ) is
328: select cer.*
329: from BEN_PRTN_ELIGY_RL_F cer
330: where cer.prtn_eligy_rl_id = c_prtn_eligy_rl_id
331: -- and cpe.business_group_id = p_business_group_id
332: and not exists (
333: select /* */ null

Line 340: -- and trt.where_clause = 'BEN_PRTN_ELIGY_RL_F'

336: where copy_entity_txn_id = p_copy_entity_txn_id
337: -- and trt.table_route_id = cpe1.table_route_id
338: and ( -- c_mirror_src_entity_result_id is null or
339: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
340: -- and trt.where_clause = 'BEN_PRTN_ELIGY_RL_F'
341: and cpe1.table_alias = c_table_alias
342: and information1 = c_prtn_eligy_rl_id
343: -- and information4 = cpe.business_group_id
344: and information2 = cer.effective_start_date

Line 350: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------

346: );
347: l_prtn_eligy_rl_id number(15);
348: l_out_cer_result_id number(15);
349: ---------------------------------------------------------------
350: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
351: ---------------------------------------------------------------
352: --
353: l_mirror_src_entity_result_id number(15);
354: l_table_route_id number(15);

Line 784: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------

780: ---------------------------------------------------------------
781: -- END OF BEN_PRTN_ELIG_PRFL_F ----------------------
782: ---------------------------------------------------------------
783: ---------------------------------------------------------------
784: -- START OF BEN_PRTN_ELIGY_RL_F ----------------------
785: ---------------------------------------------------------------
786: --
787: for l_parent_rec in c_cer_from_parent(l_PRTN_ELIG_ID) loop
788: --

Line 897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------

893: --
894: hr_utility.set_location('end of per',10);
895: end loop;
896: ---------------------------------------------------------------
897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
898: ---------------------------------------------------------------
899: hr_utility.set_location('end of pe',10);
900: end loop;
901: ---------------------------------------------------------------