APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_SP_CLNG_PRG_PRTE_F

Line 3080: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------

3076: ---------------------------------------------------------------
3077: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3078: ---------------------------------------------------------------
3079: ---------------------------------------------------------------
3080: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3081: ---------------------------------------------------------------
3082: cursor c_esp_from_parent(c_ELIGY_PRFL_ID number) is
3083: select elig_sp_clng_prg_prte_id
3084: from BEN_ELIG_SP_CLNG_PRG_PRTE_F

Line 3084: from BEN_ELIG_SP_CLNG_PRG_PRTE_F

3080: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3081: ---------------------------------------------------------------
3082: cursor c_esp_from_parent(c_ELIGY_PRFL_ID number) is
3083: select elig_sp_clng_prg_prte_id
3084: from BEN_ELIG_SP_CLNG_PRG_PRTE_F
3085: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
3086: --
3087: cursor c_esp(c_elig_sp_clng_prg_prte_id number,c_mirror_src_entity_result_id number ,
3088: c_table_alias varchar2 ) is

Line 3090: from BEN_ELIG_SP_CLNG_PRG_PRTE_F esp

3086: --
3087: cursor c_esp(c_elig_sp_clng_prg_prte_id number,c_mirror_src_entity_result_id number ,
3088: c_table_alias varchar2 ) is
3089: select esp.*
3090: from BEN_ELIG_SP_CLNG_PRG_PRTE_F esp
3091: where esp.elig_sp_clng_prg_prte_id = c_elig_sp_clng_prg_prte_id
3092: -- and esp.business_group_id = p_business_group_id
3093: and not exists (
3094: select /* */ null

Line 3101: -- and trt.where_clause = 'BEN_ELIG_SP_CLNG_PRG_PRTE_F'

3097: where copy_entity_txn_id = p_copy_entity_txn_id
3098: -- and trt.table_route_id = cpe.table_route_id
3099: and ( -- c_mirror_src_entity_result_id is null or
3100: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
3101: -- and trt.where_clause = 'BEN_ELIG_SP_CLNG_PRG_PRTE_F'
3102: and cpe.table_alias = c_table_alias
3103: and information1 = c_elig_sp_clng_prg_prte_id
3104: -- and information4 = esp.business_group_id
3105: and information2 = esp.effective_start_date

Line 3137: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------

3133: where step_id = c_step_id;
3134:
3135: l_step_start_date per_spinal_point_steps_f.effective_start_date%type;
3136: ---------------------------------------------------------------
3137: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
3138: ---------------------------------------------------------------
3139: ---------------------------------------------------------------
3140: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
3141: ---------------------------------------------------------------

Line 9745: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------

9741: ---------------------------------------------------------------
9742: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
9743: ---------------------------------------------------------------
9744: ---------------------------------------------------------------
9745: -- START OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
9746: ---------------------------------------------------------------
9747: --
9748: for l_parent_rec in c_esp_from_parent(l_ELIGY_PRFL_ID) loop
9749: --

Line 9893: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------

9889: end loop;
9890: --
9891: end loop;
9892: ---------------------------------------------------------------
9893: -- END OF BEN_ELIG_SP_CLNG_PRG_PRTE_F ----------------------
9894: ---------------------------------------------------------------
9895: ---------------------------------------------------------------
9896: -- START OF BEN_ELIG_PSTN_PRTE_F ----------------------
9897: ---------------------------------------------------------------