APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 1434: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------

1430: ---------------------------------------------------------------
1431: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
1432: ---------------------------------------------------------------
1433: ---------------------------------------------------------------
1434: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
1435: ---------------------------------------------------------------
1436: cursor c_ebu_from_parent(c_ELIGY_PRFL_ID number) is
1437: select elig_brgng_unit_prte_id
1438: from BEN_ELIG_BRGNG_UNIT_PRTE_F

Line 1438: from BEN_ELIG_BRGNG_UNIT_PRTE_F

1434: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
1435: ---------------------------------------------------------------
1436: cursor c_ebu_from_parent(c_ELIGY_PRFL_ID number) is
1437: select elig_brgng_unit_prte_id
1438: from BEN_ELIG_BRGNG_UNIT_PRTE_F
1439: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1440: --
1441: cursor c_ebu(c_elig_brgng_unit_prte_id number,c_mirror_src_entity_result_id number ,
1442: c_table_alias varchar2 ) is

Line 1444: from BEN_ELIG_BRGNG_UNIT_PRTE_F ebu

1440: --
1441: cursor c_ebu(c_elig_brgng_unit_prte_id number,c_mirror_src_entity_result_id number ,
1442: c_table_alias varchar2 ) is
1443: select ebu.*
1444: from BEN_ELIG_BRGNG_UNIT_PRTE_F ebu
1445: where ebu.elig_brgng_unit_prte_id = c_elig_brgng_unit_prte_id
1446: -- and ebu.business_group_id = p_business_group_id
1447: and not exists (
1448: select /* */ null

Line 1455: -- and trt.where_clause = 'BEN_ELIG_BRGNG_UNIT_PRTE_F'

1451: where copy_entity_txn_id = p_copy_entity_txn_id
1452: -- and trt.table_route_id = cpe.table_route_id
1453: and ( -- c_mirror_src_entity_result_id is null or
1454: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1455: -- and trt.where_clause = 'BEN_ELIG_BRGNG_UNIT_PRTE_F'
1456: and cpe.table_alias = c_table_alias
1457: and information1 = c_elig_brgng_unit_prte_id
1458: -- and information4 = ebu.business_group_id
1459: and information2 = ebu.effective_start_date

Line 1465: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------

1461: );
1462: l_elig_brgng_unit_prte_id number(15);
1463: l_out_ebu_result_id number(15);
1464: ---------------------------------------------------------------
1465: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
1466: ---------------------------------------------------------------
1467: ---------------------------------------------------------------
1468: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
1469: ---------------------------------------------------------------

Line 4760: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------

4756: ---------------------------------------------------------------
4757: -- END OF BEN_ELIG_BENFTS_GRP_PRTE_F ----------------------
4758: ---------------------------------------------------------------
4759: ---------------------------------------------------------------
4760: -- START OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
4761: ---------------------------------------------------------------
4762: --
4763: for l_parent_rec in c_ebu_from_parent(l_ELIGY_PRFL_ID) loop
4764: --

Line 4862: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------

4858: end loop;
4859: --
4860: end loop;
4861: ---------------------------------------------------------------
4862: -- END OF BEN_ELIG_BRGNG_UNIT_PRTE_F ----------------------
4863: ---------------------------------------------------------------
4864: ---------------------------------------------------------------
4865: -- START OF BEN_ELIG_CBR_QUALD_BNF_F ----------------------
4866: ---------------------------------------------------------------