APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_DSBLD_PRTE_F

Line 3714: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------

3710: ---------------------------------------------------------------
3711: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
3712: ---------------------------------------------------------------
3713: ---------------------------------------------------------------
3714: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
3715: ---------------------------------------------------------------
3716: cursor c_edb_from_parent(c_ELIGY_PRFL_ID number) is
3717: select elig_dsbld_prte_id
3718: from BEN_ELIG_DSBLD_PRTE_F

Line 3718: from BEN_ELIG_DSBLD_PRTE_F

3714: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
3715: ---------------------------------------------------------------
3716: cursor c_edb_from_parent(c_ELIGY_PRFL_ID number) is
3717: select elig_dsbld_prte_id
3718: from BEN_ELIG_DSBLD_PRTE_F
3719: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3720: --
3721: cursor c_edb(c_elig_dsbld_prte_id number,c_mirror_src_entity_result_id number ,
3722: c_table_alias varchar2 ) is

Line 3724: from BEN_ELIG_DSBLD_PRTE_F edb

3720: --
3721: cursor c_edb(c_elig_dsbld_prte_id number,c_mirror_src_entity_result_id number ,
3722: c_table_alias varchar2 ) is
3723: select edb.*
3724: from BEN_ELIG_DSBLD_PRTE_F edb
3725: where edb.elig_dsbld_prte_id = c_elig_dsbld_prte_id
3726: -- and edb.business_group_id = p_business_group_id
3727: and not exists (
3728: select /* */ null

Line 3735: -- and trt.where_clause = 'BEN_ELIG_DSBLD_PRTE_F'

3731: where copy_entity_txn_id = p_copy_entity_txn_id
3732: -- and trt.table_route_id = cpe.table_route_id
3733: and ( -- c_mirror_src_entity_result_id is null or
3734: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3735: -- and trt.where_clause = 'BEN_ELIG_DSBLD_PRTE_F'
3736: and cpe.table_alias = c_table_alias
3737: and information1 = c_elig_dsbld_prte_id
3738: -- and information4 = edb.business_group_id
3739: and information2 = edb.effective_start_date

Line 3745: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------

3741: );
3742: l_elig_dsbld_prte_id number(15);
3743: l_out_edb_result_id number(15);
3744: ---------------------------------------------------------------
3745: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------
3746: ---------------------------------------------------------------
3747: ---------------------------------------------------------------
3748: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F ----------------------
3749: ---------------------------------------------------------------

Line 11543: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------

11539: ---------------------------------------------------------------
11540: -- END OF BEN_ELIG_TTL_PRTT_PRTE_F ----------------------
11541: ---------------------------------------------------------------
11542: ---------------------------------------------------------------
11543: -- START OF BEN_ELIG_DSBLD_PRTE_F ----------------------
11544: ---------------------------------------------------------------
11545: --
11546: for l_parent_rec in c_edb_from_parent(l_ELIGY_PRFL_ID) loop
11547: --

Line 11645: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------

11641: end loop;
11642: --
11643: end loop;
11644: ---------------------------------------------------------------
11645: -- END OF BEN_ELIG_DSBLD_PRTE_F ----------------------
11646: ---------------------------------------------------------------
11647: ---------------------------------------------------------------
11648: -- START OF BEN_ELIG_HLTH_CVG_PRTE_F -------------------------
11649: ---------------------------------------------------------------