APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_GD_OR_SVC_F

Line 192: from BEN_PL_GD_OR_SVC_F

188: -- END OF BEN_PL_TYP_F ----------------------
189: ---------------------------------------------------------------
190: cursor c_vgs_from_parent(c_PL_ID number) is
191: select pl_gd_or_svc_id
192: from BEN_PL_GD_OR_SVC_F
193: where PL_ID = c_PL_ID ;
194: --
195: cursor c_vgs(c_pl_gd_or_svc_id number,c_mirror_src_entity_result_id number,
196: c_table_alias varchar2) is

Line 198: from BEN_PL_GD_OR_SVC_F vgs

194: --
195: cursor c_vgs(c_pl_gd_or_svc_id number,c_mirror_src_entity_result_id number,
196: c_table_alias varchar2) is
197: select vgs.*
198: from BEN_PL_GD_OR_SVC_F vgs
199: where vgs.pl_gd_or_svc_id = c_pl_gd_or_svc_id
200: -- and vgs.business_group_id = p_business_group_id
201: and not exists (
202: select /*+ */ null

Line 209: -- and trt.where_clause = 'BEN_PL_GD_OR_SVC_F'

205: where copy_entity_txn_id = p_copy_entity_txn_id
206: -- and trt.table_route_id = cpe.table_route_id
207: and ( -- c_mirror_src_entity_result_id is null or
208: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
209: -- and trt.where_clause = 'BEN_PL_GD_OR_SVC_F'
210: and cpe.table_alias = c_table_alias
211: and information1 = c_pl_gd_or_svc_id
212: -- and information4 = vgs.business_group_id
213: and information2 = vgs.effective_start_date

Line 757: from BEN_PL_GD_OR_SVC_F

753: -- START OF BEN_GD_OR_SVC_TYP ----------------------
754: ---------------------------------------------------------------
755: cursor c_gos_from_parent(c_PL_GD_OR_SVC_ID number) is
756: select gd_or_svc_typ_id
757: from BEN_PL_GD_OR_SVC_F
758: where PL_GD_OR_SVC_ID = c_PL_GD_OR_SVC_ID ;
759: --
760: cursor c_gos(c_gd_or_svc_typ_id number,c_mirror_src_entity_result_id number,
761: c_table_alias varchar2) is