APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 1633: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------

1629: ---------------------------------------------------------------
1630: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
1631: ---------------------------------------------------------------
1632: ---------------------------------------------------------------
1633: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
1634: ---------------------------------------------------------------
1635: cursor c_edp_from_parent(c_ELIGY_PRFL_ID number) is
1636: select elig_dpnt_cvrd_othr_pl_id
1637: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 1637: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F

1633: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
1634: ---------------------------------------------------------------
1635: cursor c_edp_from_parent(c_ELIGY_PRFL_ID number) is
1636: select elig_dpnt_cvrd_othr_pl_id
1637: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F
1638: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1639: --
1640: cursor c_edp(c_elig_dpnt_cvrd_othr_pl_id number,c_mirror_src_entity_result_id number ,
1641: c_table_alias varchar2 ) is

Line 1643: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F edp

1639: --
1640: cursor c_edp(c_elig_dpnt_cvrd_othr_pl_id number,c_mirror_src_entity_result_id number ,
1641: c_table_alias varchar2 ) is
1642: select edp.*
1643: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F edp
1644: where edp.elig_dpnt_cvrd_othr_pl_id = c_elig_dpnt_cvrd_othr_pl_id
1645: -- and edp.business_group_id = p_business_group_id
1646: and not exists (
1647: select /* */ null

Line 1654: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PL_F'

1650: where copy_entity_txn_id = p_copy_entity_txn_id
1651: -- and trt.table_route_id = cpe.table_route_id
1652: and ( -- c_mirror_src_entity_result_id is null or
1653: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1654: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PL_F'
1655: and cpe.table_alias = c_table_alias
1656: and information1 = c_elig_dpnt_cvrd_othr_pl_id
1657: -- and information4 = edp.business_group_id
1658: and information2 = edp.effective_start_date

Line 1664: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------

1660: );
1661: l_elig_dpnt_cvrd_othr_pl_id number(15);
1662: l_out_edp_result_id number(15);
1663: ---------------------------------------------------------------
1664: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
1665: ---------------------------------------------------------------
1666: ---------------------------------------------------------------
1667: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
1668: ---------------------------------------------------------------

Line 5335: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------

5331: ---------------------------------------------------------------
5332: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
5333: ---------------------------------------------------------------
5334: ---------------------------------------------------------------
5335: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
5336: ---------------------------------------------------------------
5337: --
5338: for l_parent_rec in c_edp_from_parent(l_ELIGY_PRFL_ID) loop
5339: --

Line 5438: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------

5434: end loop;
5435: --
5436: end loop;
5437: ---------------------------------------------------------------
5438: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
5439: ---------------------------------------------------------------
5440: ---------------------------------------------------------------
5441: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
5442: ---------------------------------------------------------------