DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_VALD_RLSHP_FOR_REIMB_F

Line 272: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------

268: -- END OF BEN_CWB_WKSHT_GRP ----------------------
269: ---------------------------------------------------------------
270:
271: ---------------------------------------------------------------
272: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
273: ---------------------------------------------------------------
274: cursor c_vrp_from_parent(c_PL_ID number) is
275: select vald_rlshp_for_reimb_id
276: from BEN_VALD_RLSHP_FOR_REIMB_F

Line 276: from BEN_VALD_RLSHP_FOR_REIMB_F

272: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
273: ---------------------------------------------------------------
274: cursor c_vrp_from_parent(c_PL_ID number) is
275: select vald_rlshp_for_reimb_id
276: from BEN_VALD_RLSHP_FOR_REIMB_F
277: where PL_ID = c_PL_ID ;
278: --
279: cursor c_vrp(c_vald_rlshp_for_reimb_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
280: select vrp.*

Line 281: from BEN_VALD_RLSHP_FOR_REIMB_F vrp

277: where PL_ID = c_PL_ID ;
278: --
279: cursor c_vrp(c_vald_rlshp_for_reimb_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
280: select vrp.*
281: from BEN_VALD_RLSHP_FOR_REIMB_F vrp
282: where vrp.vald_rlshp_for_reimb_id = c_vald_rlshp_for_reimb_id
283: -- and vrp.business_group_id = p_business_group_id
284: and not exists (
285: select /*+ */ null

Line 292: -- and trt.where_clause ='BEN_VALD_RLSHP_FOR_REIMB_F'

288: where copy_entity_txn_id = p_copy_entity_txn_id
289: -- and trt.table_route_id = cpe.table_route_id
290: and ( -- c_mirror_src_entity_result_id is null or
291: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
292: -- and trt.where_clause ='BEN_VALD_RLSHP_FOR_REIMB_F'
293: and cpe.table_alias = c_table_alias
294: and information1 = c_vald_rlshp_for_reimb_id
295: -- and information4 = vrp.business_group_id
296: and information2 = vrp.effective_start_date

Line 302: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------

298: );
299:
300: l_out_vrp_result_id number(15);
301: ---------------------------------------------------------------
302: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
303: ---------------------------------------------------------------
304: ---------------------------------------------------------------
305: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------
306: ---------------------------------------------------------------

Line 3450: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------

3446: ---------------------------------------------------------------
3447: end loop;
3448:
3449: ---------------------------------------------------------------
3450: -- START OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
3451: ---------------------------------------------------------------
3452: --
3453: for l_parent_rec in c_vrp_from_parent(l_PL_ID) loop
3454: --

Line 3542: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------

3538: end loop;
3539: --
3540: end loop;
3541: ---------------------------------------------------------------
3542: -- END OF BEN_VALD_RLSHP_FOR_REIMB_F ----------------------
3543: ---------------------------------------------------------------
3544:
3545: ---------------------------------------------------------------
3546: -- START OF BEN_WV_PRTN_RSN_PL_F ----------------------