APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PGM_F

Line 1599: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------

1595: ---------------------------------------------------------------
1596: -- END OF BEN_ELIG_COMP_LVL_PRTE_F ----------------------
1597: ---------------------------------------------------------------
1598: ---------------------------------------------------------------
1599: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
1600: ---------------------------------------------------------------
1601: cursor c_edg_from_parent(c_ELIGY_PRFL_ID number) is
1602: select elig_dpnt_cvrd_othr_pgm_id
1603: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F

Line 1603: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F

1599: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
1600: ---------------------------------------------------------------
1601: cursor c_edg_from_parent(c_ELIGY_PRFL_ID number) is
1602: select elig_dpnt_cvrd_othr_pgm_id
1603: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F
1604: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
1605: --
1606: cursor c_edg(c_elig_dpnt_cvrd_othr_pgm_id number,c_mirror_src_entity_result_id number ,
1607: c_table_alias varchar2 ) is

Line 1609: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F edg

1605: --
1606: cursor c_edg(c_elig_dpnt_cvrd_othr_pgm_id number,c_mirror_src_entity_result_id number ,
1607: c_table_alias varchar2 ) is
1608: select edg.*
1609: from BEN_ELIG_DPNT_CVRD_OTHR_PGM_F edg
1610: where edg.elig_dpnt_cvrd_othr_pgm_id = c_elig_dpnt_cvrd_othr_pgm_id
1611: -- and edg.business_group_id = p_business_group_id
1612: and not exists (
1613: select /* */ null

Line 1620: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PGM_F'

1616: where copy_entity_txn_id = p_copy_entity_txn_id
1617: -- and trt.table_route_id = cpe.table_route_id
1618: and ( -- c_mirror_src_entity_result_id is null or
1619: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
1620: -- and trt.where_clause = 'BEN_ELIG_DPNT_CVRD_OTHR_PGM_F'
1621: and cpe.table_alias = c_table_alias
1622: and information1 = c_elig_dpnt_cvrd_othr_pgm_id
1623: -- and information4 = edg.business_group_id
1624: and information2 = edg.effective_start_date

Line 1630: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------

1626: );
1627: l_elig_dpnt_cvrd_othr_pgm_id number(15);
1628: l_out_edg_result_id number(15);
1629: ---------------------------------------------------------------
1630: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
1631: ---------------------------------------------------------------
1632: ---------------------------------------------------------------
1633: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
1634: ---------------------------------------------------------------

Line 5227: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------

5223: ---------------------------------------------------------------
5224: -- END OF BEN_ELIG_COMP_LVL_PRTE_F ----------------------
5225: ---------------------------------------------------------------
5226: ---------------------------------------------------------------
5227: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
5228: ---------------------------------------------------------------
5229: --
5230: for l_parent_rec in c_edg_from_parent(l_ELIGY_PRFL_ID) loop
5231: --

Line 5332: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------

5328: end loop;
5329: --
5330: end loop;
5331: ---------------------------------------------------------------
5332: -- END OF BEN_ELIG_DPNT_CVRD_OTHR_PGM_F ----------------------
5333: ---------------------------------------------------------------
5334: ---------------------------------------------------------------
5335: -- START OF BEN_ELIG_DPNT_CVRD_OTHR_PL_F ----------------------
5336: ---------------------------------------------------------------