APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DPNT_CVRD_PLIP_F

Line 1701: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------

1697: ---------------------------------------------------------------
1698: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
1699: ---------------------------------------------------------------
1700: ---------------------------------------------------------------
1701: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
1702: ---------------------------------------------------------------
1703: cursor c_edi_from_parent(c_ELIGY_PRFL_ID number) is
1704: select elig_dpnt_cvrd_plip_id
1705: from BEN_ELIG_DPNT_CVRD_PLIP_F

Line 1705: from BEN_ELIG_DPNT_CVRD_PLIP_F

1701: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
1702: ---------------------------------------------------------------
1703: cursor c_edi_from_parent(c_ELIGY_PRFL_ID number) is
1704: select elig_dpnt_cvrd_plip_id
1705: from BEN_ELIG_DPNT_CVRD_PLIP_F
1706: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1707: --
1708: cursor c_edi(c_elig_dpnt_cvrd_plip_id number,c_mirror_src_entity_result_id number ,
1709: c_table_alias varchar2 ) is

Line 1711: from BEN_ELIG_DPNT_CVRD_PLIP_F edi

1707: --
1708: cursor c_edi(c_elig_dpnt_cvrd_plip_id number,c_mirror_src_entity_result_id number ,
1709: c_table_alias varchar2 ) is
1710: select edi.*
1711: from BEN_ELIG_DPNT_CVRD_PLIP_F edi
1712: where edi.elig_dpnt_cvrd_plip_id = c_elig_dpnt_cvrd_plip_id
1713: -- and edi.business_group_id = p_business_group_id
1714: and not exists (
1715: select /* */ null

Line 1722: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_PLIP_F'

1718: where copy_entity_txn_id = p_copy_entity_txn_id
1719: -- and trt.table_route_id = cpe.table_route_id
1720: and ( -- c_mirror_src_entity_result_id is null or
1721: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1722: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_PLIP_F'
1723: and cpe.table_alias = c_table_alias
1724: and information1 = c_elig_dpnt_cvrd_plip_id
1725: -- and information4 = edi.business_group_id
1726: and information2 = edi.effective_start_date

Line 1732: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------

1728: );
1729: l_elig_dpnt_cvrd_plip_id number(15);
1730: l_out_edi_result_id number(15);
1731: ---------------------------------------------------------------
1732: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
1733: ---------------------------------------------------------------
1734: ---------------------------------------------------------------
1735: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
1736: ---------------------------------------------------------------

Line 5549: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------

5545: ---------------------------------------------------------------
5546: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F ----------------------
5547: ---------------------------------------------------------------
5548: ---------------------------------------------------------------
5549: -- START OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
5550: ---------------------------------------------------------------
5551: --
5552: for l_parent_rec in c_edi_from_parent(l_ELIGY_PRFL_ID) loop
5553: --

Line 5652: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------

5648: end loop;
5649: --
5650: end loop;
5651: ---------------------------------------------------------------
5652: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
5653: ---------------------------------------------------------------
5654: ---------------------------------------------------------------
5655: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
5656: ---------------------------------------------------------------