APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DPNT_OTHR_PTIP_F

Line 1735: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------

1731: ---------------------------------------------------------------
1732: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
1733: ---------------------------------------------------------------
1734: ---------------------------------------------------------------
1735: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
1736: ---------------------------------------------------------------
1737: cursor c_etd_from_parent(c_ELIGY_PRFL_ID number) is
1738: select elig_dpnt_othr_ptip_id
1739: from BEN_ELIG_DPNT_OTHR_PTIP_F

Line 1739: from BEN_ELIG_DPNT_OTHR_PTIP_F

1735: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
1736: ---------------------------------------------------------------
1737: cursor c_etd_from_parent(c_ELIGY_PRFL_ID number) is
1738: select elig_dpnt_othr_ptip_id
1739: from BEN_ELIG_DPNT_OTHR_PTIP_F
1740: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1741: --
1742: cursor c_etd(c_elig_dpnt_othr_ptip_id number,c_mirror_src_entity_result_id number ,
1743: c_table_alias varchar2 ) is

Line 1745: from BEN_ELIG_DPNT_OTHR_PTIP_F etd

1741: --
1742: cursor c_etd(c_elig_dpnt_othr_ptip_id number,c_mirror_src_entity_result_id number ,
1743: c_table_alias varchar2 ) is
1744: select etd.*
1745: from BEN_ELIG_DPNT_OTHR_PTIP_F etd
1746: where etd.elig_dpnt_othr_ptip_id = c_elig_dpnt_othr_ptip_id
1747: -- and etd.business_group_id = p_business_group_id
1748: and not exists (
1749: select /* */ null

Line 1756: -- and trt.where_clause = 'BEN_ELIG_DPNT_OTHR_PTIP_F'

1752: where copy_entity_txn_id = p_copy_entity_txn_id
1753: -- and trt.table_route_id = cpe.table_route_id
1754: and ( -- c_mirror_src_entity_result_id is null or
1755: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1756: -- and trt.where_clause = 'BEN_ELIG_DPNT_OTHR_PTIP_F'
1757: and cpe.table_alias = c_table_alias
1758: and information1 = c_elig_dpnt_othr_ptip_id
1759: -- and information4 = etd.business_group_id
1760: and information2 = etd.effective_start_date

Line 1766: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------

1762: );
1763: l_elig_dpnt_othr_ptip_id number(15);
1764: l_out_etd_result_id number(15);
1765: ---------------------------------------------------------------
1766: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
1767: ---------------------------------------------------------------
1768: ---------------------------------------------------------------
1769: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
1770: ---------------------------------------------------------------

Line 5655: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------

5651: ---------------------------------------------------------------
5652: -- END OF BEN_ELIG_DPNT_CVRD_PLIP_F ----------------------
5653: ---------------------------------------------------------------
5654: ---------------------------------------------------------------
5655: -- START OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
5656: ---------------------------------------------------------------
5657: --
5658: for l_parent_rec in c_etd_from_parent(l_ELIGY_PRFL_ID) loop
5659: --

Line 5751: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------

5747: end loop;
5748: --
5749: end loop;
5750: ---------------------------------------------------------------
5751: -- END OF BEN_ELIG_DPNT_OTHR_PTIP_F ----------------------
5752: ---------------------------------------------------------------
5753: ---------------------------------------------------------------
5754: -- START OF BEN_ELIG_DSBLD_STAT_PRTE_F ----------------------
5755: ---------------------------------------------------------------