APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_TBCO_USE_PRTE_F

Line 3612: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------

3608: ---------------------------------------------------------------
3609: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
3610: ---------------------------------------------------------------
3611: ---------------------------------------------------------------
3612: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
3613: ---------------------------------------------------------------
3614: cursor c_etu_from_parent(c_ELIGY_PRFL_ID number) is
3615: select elig_tbco_use_prte_id
3616: from BEN_ELIG_TBCO_USE_PRTE_F

Line 3616: from BEN_ELIG_TBCO_USE_PRTE_F

3612: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
3613: ---------------------------------------------------------------
3614: cursor c_etu_from_parent(c_ELIGY_PRFL_ID number) is
3615: select elig_tbco_use_prte_id
3616: from BEN_ELIG_TBCO_USE_PRTE_F
3617: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3618: --
3619: cursor c_etu(c_elig_tbco_use_prte_id number,c_mirror_src_entity_result_id number ,
3620: c_table_alias varchar2 ) is

Line 3622: from BEN_ELIG_TBCO_USE_PRTE_F etu

3618: --
3619: cursor c_etu(c_elig_tbco_use_prte_id number,c_mirror_src_entity_result_id number ,
3620: c_table_alias varchar2 ) is
3621: select etu.*
3622: from BEN_ELIG_TBCO_USE_PRTE_F etu
3623: where etu.elig_tbco_use_prte_id = c_elig_tbco_use_prte_id
3624: -- and etu.business_group_id = p_business_group_id
3625: and not exists (
3626: select /* */ null

Line 3633: -- and trt.where_clause = 'BEN_ELIG_TBCO_USE_PRTE_F'

3629: where copy_entity_txn_id = p_copy_entity_txn_id
3630: -- and trt.table_route_id = cpe.table_route_id
3631: and ( -- c_mirror_src_entity_result_id is null or
3632: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3633: -- and trt.where_clause = 'BEN_ELIG_TBCO_USE_PRTE_F'
3634: and cpe.table_alias = c_table_alias
3635: and information1 = c_elig_tbco_use_prte_id
3636: -- and information4 = etu.business_group_id
3637: and information2 = etu.effective_start_date

Line 3643: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------

3639: );
3640: l_elig_tbco_use_prte_id number(15);
3641: l_out_etu_result_id number(15);
3642: ---------------------------------------------------------------
3643: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
3644: ---------------------------------------------------------------
3645: ---------------------------------------------------------------
3646: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
3647: ---------------------------------------------------------------

Line 11197: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------

11193: -- END OF BEN_ELIG_QUA_IN_GR_PRTE_F ----------------------
11194: ---------------------------------------------------------------
11195:
11196: ---------------------------------------------------------------
11197: -- START OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
11198: ---------------------------------------------------------------
11199: --
11200: for l_parent_rec in c_etu_from_parent(l_ELIGY_PRFL_ID) loop
11201: --

Line 11299: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------

11295: end loop;
11296: --
11297: end loop;
11298: ---------------------------------------------------------------
11299: -- END OF BEN_ELIG_TBCO_USE_PRTE_F ----------------------
11300: ---------------------------------------------------------------
11301: ---------------------------------------------------------------
11302: -- START OF BEN_ELIG_TTL_CVG_VOL_PRTE_F ----------------------
11303: ---------------------------------------------------------------