APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_GD_OR_SVC_TYP

Line 753: -- START OF BEN_GD_OR_SVC_TYP ----------------------

749: ---------------------------------------------------------------
750: -- END OF BEN_ELIG_TO_PRTE_RSN_F ----------------------
751: ---------------------------------------------------------------
752: ---------------------------------------------------------------
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

Line 763: from BEN_GD_OR_SVC_TYP gos

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
762: select gos.*
763: from BEN_GD_OR_SVC_TYP gos
764: where gos.gd_or_svc_typ_id = c_gd_or_svc_typ_id
765: -- and gos.business_group_id = p_business_group_id
766: and not exists (
767: select /*+ */ null

Line 774: -- and trt.where_clause = 'BEN_GD_OR_SVC_TYP'

770: where copy_entity_txn_id = p_copy_entity_txn_id
771: -- and trt.table_route_id = cpe.table_route_id
772: and ( -- c_mirror_src_entity_result_id is null or
773: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
774: -- and trt.where_clause = 'BEN_GD_OR_SVC_TYP'
775: and cpe.table_alias = c_table_alias
776: and information1 = c_gd_or_svc_typ_id
777: -- and information4 = gos.business_group_id
778: );

Line 782: -- END OF BEN_GD_OR_SVC_TYP ----------------------

778: );
779:
780: l_out_gos_result_id number(15);
781: ---------------------------------------------------------------
782: -- END OF BEN_GD_OR_SVC_TYP ----------------------
783: ---------------------------------------------------------------
784: ---------------------------------------------------------------
785: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
786: ---------------------------------------------------------------

Line 3220: -- START OF BEN_GD_OR_SVC_TYP ----------------------

3216:
3217: end loop;
3218:
3219: ---------------------------------------------------------------
3220: -- START OF BEN_GD_OR_SVC_TYP ----------------------
3221: ---------------------------------------------------------------
3222: --
3223: for l_parent_rec in c_gos_from_parent(l_PL_GD_OR_SVC_ID) loop
3224: --

Line 3319: -- END OF BEN_GD_OR_SVC_TYP ----------------------

3315: end loop;
3316: --
3317: end loop;
3318: ---------------------------------------------------------------
3319: -- END OF BEN_GD_OR_SVC_TYP ----------------------
3320: ---------------------------------------------------------------
3321: ---------------------------------------------------------------
3322: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
3323: ---------------------------------------------------------------