APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F

Line 1667: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------

1663: ---------------------------------------------------------------
1664: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
1665: ---------------------------------------------------------------
1666: ---------------------------------------------------------------
1667: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
1668: ---------------------------------------------------------------
1669: cursor c_edt_from_parent(c_ELIGY_PRFL_ID number) is
1670: select elig_dpnt_cvrd_othr_ptip_id
1671: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F

Line 1671: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F

1667: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
1668: ---------------------------------------------------------------
1669: cursor c_edt_from_parent(c_ELIGY_PRFL_ID number) is
1670: select elig_dpnt_cvrd_othr_ptip_id
1671: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F
1672: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1673: --
1674: cursor c_edt(c_elig_dpnt_cvrd_othr_ptip_id number,c_mirror_src_entity_result_id number ,
1675: c_table_alias varchar2 ) is

Line 1677: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F edt

1673: --
1674: cursor c_edt(c_elig_dpnt_cvrd_othr_ptip_id number,c_mirror_src_entity_result_id number ,
1675: c_table_alias varchar2 ) is
1676: select edt.*
1677: from BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F edt
1678: where edt.elig_dpnt_cvrd_othr_ptip_id = c_elig_dpnt_cvrd_othr_ptip_id
1679: -- and edt.business_group_id = p_business_group_id
1680: and not exists (
1681: select /* */ null

Line 1688: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F'

1684: where copy_entity_txn_id = p_copy_entity_txn_id
1685: -- and trt.table_route_id = cpe.table_route_id
1686: and ( -- c_mirror_src_entity_result_id is null or
1687: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1688: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F'
1689: and cpe.table_alias = c_table_alias
1690: and information1 = c_elig_dpnt_cvrd_othr_ptip_id
1691: -- and information4 = edt.business_group_id
1692: and information2 = edt.effective_start_date

Line 1698: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------

1694: );
1695: l_elig_dpnt_cvrd_othr_ptip_id number(15);
1696: l_out_edt_result_id number(15);
1697: ---------------------------------------------------------------
1698: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
1699: ---------------------------------------------------------------
1700: ---------------------------------------------------------------
1701: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
1702: ---------------------------------------------------------------

Line 5441: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------

5437: ---------------------------------------------------------------
5438: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
5439: ---------------------------------------------------------------
5440: ---------------------------------------------------------------
5441: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
5442: ---------------------------------------------------------------
5443: --
5444: for l_parent_rec in c_edt_from_parent(l_ELIGY_PRFL_ID) loop
5445: --

Line 5546: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------

5542: end loop;
5543: --
5544: end loop;
5545: ---------------------------------------------------------------
5546: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
5547: ---------------------------------------------------------------
5548: ---------------------------------------------------------------
5549: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
5550: ---------------------------------------------------------------