APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 3031: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------

3027: ---------------------------------------------------------------
3028: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
3029: ---------------------------------------------------------------
3030: ---------------------------------------------------------------
3031: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3032: ---------------------------------------------------------------
3033: cursor c_ewl_from_parent(c_ELIGY_PRFL_ID number) is
3034: select elig_wk_loc_prte_id
3035: from BEN_ELIG_WK_LOC_PRTE_F

Line 3035: from BEN_ELIG_WK_LOC_PRTE_F

3031: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3032: ---------------------------------------------------------------
3033: cursor c_ewl_from_parent(c_ELIGY_PRFL_ID number) is
3034: select elig_wk_loc_prte_id
3035: from BEN_ELIG_WK_LOC_PRTE_F
3036: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3037: --
3038: cursor c_ewl(c_elig_wk_loc_prte_id number,c_mirror_src_entity_result_id number ,
3039: c_table_alias varchar2 ) is

Line 3041: from BEN_ELIG_WK_LOC_PRTE_F ewl

3037: --
3038: cursor c_ewl(c_elig_wk_loc_prte_id number,c_mirror_src_entity_result_id number ,
3039: c_table_alias varchar2 ) is
3040: select ewl.*
3041: from BEN_ELIG_WK_LOC_PRTE_F ewl
3042: where ewl.elig_wk_loc_prte_id = c_elig_wk_loc_prte_id
3043: -- and ewl.business_group_id = p_business_group_id
3044: and not exists (
3045: select /* */ null

Line 3052: -- and trt.where_clause = 'BEN_ELIG_WK_LOC_PRTE_F'

3048: where copy_entity_txn_id = p_copy_entity_txn_id
3049: -- and trt.table_route_id = cpe.table_route_id
3050: and ( -- c_mirror_src_entity_result_id is null or
3051: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3052: -- and trt.where_clause = 'BEN_ELIG_WK_LOC_PRTE_F'
3053: and cpe.table_alias = c_table_alias
3054: and information1 = c_elig_wk_loc_prte_id
3055: -- and information4 = ewl.business_group_id
3056: and information2 = ewl.effective_start_date

Line 3077: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------

3073: where location_id = c_location_id;
3074:
3075: l_location_inactive_date hr_locations.inactive_date%type;
3076: ---------------------------------------------------------------
3077: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3078: ---------------------------------------------------------------
3079: ---------------------------------------------------------------
3080: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3081: ---------------------------------------------------------------

Line 9598: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------

9594: ---------------------------------------------------------------
9595: -- END OF BEN_ELIG_SVC_AREA_PRTE_F ----------------------
9596: ---------------------------------------------------------------
9597: ---------------------------------------------------------------
9598: -- START OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
9599: ---------------------------------------------------------------
9600: --
9601: for l_parent_rec in c_ewl_from_parent(l_ELIGY_PRFL_ID) loop
9602: --

Line 9742: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------

9738: end loop;
9739: --
9740: end loop;
9741: ---------------------------------------------------------------
9742: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
9743: ---------------------------------------------------------------
9744: ---------------------------------------------------------------
9745: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
9746: ---------------------------------------------------------------