eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_SVC_AREA_PRTE_F

Line 2983: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------

2979: ---------------------------------------------------------------
2980: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
2981: ---------------------------------------------------------------
2982: ---------------------------------------------------------------
2983: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
2984: ---------------------------------------------------------------
2985: cursor c_esa_from_parent(c_ELIGY_PRFL_ID number) is
2986: select distinct elig_svc_area_prte_id
2987: from BEN_ELIG_SVC_AREA_PRTE_F

Line 2987: from BEN_ELIG_SVC_AREA_PRTE_F

2983: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
2984: ---------------------------------------------------------------
2985: cursor c_esa_from_parent(c_ELIGY_PRFL_ID number) is
2986: select distinct elig_svc_area_prte_id
2987: from BEN_ELIG_SVC_AREA_PRTE_F
2988: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2989: --
2990: cursor c_esa(c_elig_svc_area_prte_id number,c_mirror_src_entity_result_id number ,
2991: c_table_alias varchar2 ) is

Line 2993: from BEN_ELIG_SVC_AREA_PRTE_F esa

2989: --
2990: cursor c_esa(c_elig_svc_area_prte_id number,c_mirror_src_entity_result_id number ,
2991: c_table_alias varchar2 ) is
2992: select esa.*
2993: from BEN_ELIG_SVC_AREA_PRTE_F esa
2994: where esa.elig_svc_area_prte_id = c_elig_svc_area_prte_id
2995: -- and esa.business_group_id = p_business_group_id
2996: and not exists (
2997: select /* */ null

Line 3004: -- and trt.where_clause = 'BEN_ELIG_SVC_AREA_PRTE_F'

3000: where copy_entity_txn_id = p_copy_entity_txn_id
3001: -- and trt.table_route_id = cpe.table_route_id
3002: and ( -- c_mirror_src_entity_result_id is null or
3003: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3004: -- and trt.where_clause = 'BEN_ELIG_SVC_AREA_PRTE_F'
3005: and cpe.table_alias = c_table_alias
3006: and information1 = c_elig_svc_area_prte_id
3007: -- and information4 = esa.business_group_id
3008: and information2 = esa.effective_start_date

Line 3022: -- and trt.where_clause = 'BEN_ELIG_SVC_AREA_PRTE_F'

3018: -- pqh_table_route trt
3019: where copy_entity_txn_id = p_copy_entity_txn_id
3020: -- and trt.table_route_id = cpe.table_route_id
3021: and mirror_src_entity_result_id = c_mirror_src_entity_result_id
3022: -- and trt.where_clause = 'BEN_ELIG_SVC_AREA_PRTE_F'
3023: and cpe.table_alias = c_table_alias
3024: and information1 = c_elig_svc_area_prte_id
3025: -- and information4 = p_business_group_id
3026: ;

Line 3028: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------

3024: and information1 = c_elig_svc_area_prte_id
3025: -- and information4 = p_business_group_id
3026: ;
3027: ---------------------------------------------------------------
3028: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
3029: ---------------------------------------------------------------
3030: ---------------------------------------------------------------
3031: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3032: ---------------------------------------------------------------

Line 9479: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------

9475: ---------------------------------------------------------------
9476: -- END OF BEN_ELIG_SCHEDD_HRS_PRTE_F ----------------------
9477: ---------------------------------------------------------------
9478: ---------------------------------------------------------------
9479: -- START OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
9480: ---------------------------------------------------------------
9481: --
9482: for l_parent_rec in c_esa_from_parent(l_ELIGY_PRFL_ID) loop
9483: --

Line 9595: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------

9591: );
9592: end loop;
9593: end loop;
9594: ---------------------------------------------------------------
9595: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
9596: ---------------------------------------------------------------
9597: ---------------------------------------------------------------
9598: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
9599: ---------------------------------------------------------------