APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_CWB_WKSHT_GRP

Line 220: -- START OF BEN_CWB_WKSHT_GRP ----------------------

216:
217: l_out_vgs_result_id number(15);
218: --
219: ---------------------------------------------------------------
220: -- START OF BEN_CWB_WKSHT_GRP ----------------------
221: ---------------------------------------------------------------
222: cursor c_cwg_from_parent(c_PL_ID number) is
223: select cwb_wksht_grp_id
224: from BEN_CWB_WKSHT_GRP

Line 224: from BEN_CWB_WKSHT_GRP

220: -- START OF BEN_CWB_WKSHT_GRP ----------------------
221: ---------------------------------------------------------------
222: cursor c_cwg_from_parent(c_PL_ID number) is
223: select cwb_wksht_grp_id
224: from BEN_CWB_WKSHT_GRP
225: where PL_ID = c_PL_ID ;
226: --
227: cursor c_cwg(c_cwb_wksht_grp_id number,c_mirror_src_entity_result_id number,
228: c_table_alias varchar2) is

Line 230: from BEN_CWB_WKSHT_GRP cwg

226: --
227: cursor c_cwg(c_cwb_wksht_grp_id number,c_mirror_src_entity_result_id number,
228: c_table_alias varchar2) is
229: select cwg.*
230: from BEN_CWB_WKSHT_GRP cwg
231: where cwg.cwb_wksht_grp_id = c_cwb_wksht_grp_id
232: and cwg.business_group_id = p_business_group_id
233: and not exists (
234: select /*+ */ null

Line 241: -- and trt.where_clause = 'BEN_CWB_WKSHT_GRP'

237: where copy_entity_txn_id = p_copy_entity_txn_id
238: -- and trt.table_route_id = cpe.table_route_id
239: and ( --c_mirror_src_entity_result_id is null or
240: c_mirror_src_entity_result_id = c_mirror_src_entity_result_id )
241: -- and trt.where_clause = 'BEN_CWB_WKSHT_GRP'
242: and cpe.table_alias = c_table_alias
243: and information1 = c_cwb_wksht_grp_id
244: --and information4 = cwg.business_group_id
245: );

Line 268: -- END OF BEN_CWB_WKSHT_GRP ----------------------

264: l_cri_result_type_cd varchar2(30);
265: l_out_cri_result_id number(15);
266: l_out_cwg_result_id number(15);
267: ---------------------------------------------------------------
268: -- END OF BEN_CWB_WKSHT_GRP ----------------------
269: ---------------------------------------------------------------
270:
271: ---------------------------------------------------------------
272: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------

Line 2097: -- START OF BEN_CWB_WKSHT_GRP ----------------------

2093: ,p_effective_date => p_effective_date
2094: ,p_parent_entity_result_id => l_parent_entity_result_id
2095: );
2096: ---------------------------------------------------------------
2097: -- START OF BEN_CWB_WKSHT_GRP ----------------------
2098: ---------------------------------------------------------------
2099: --
2100:
2101: for l_parent_rec in c_cwg_from_parent(l_PL_ID) loop

Line 2258: -- END OF BEN_CWB_WKSHT_GRP ----------------------

2254: --
2255: end loop;
2256:
2257: ---------------------------------------------------------------
2258: -- END OF BEN_CWB_WKSHT_GRP ----------------------
2259: ---------------------------------------------------------------
2260:
2261: ---------------------------------------------------------------
2262: -- START OF BEN_PL_TYP_F ----------------------