APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_PL_GD_R_SVC_CTFN_F

Line 785: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------

781: ---------------------------------------------------------------
782: -- END OF BEN_GD_OR_SVC_TYP ----------------------
783: ---------------------------------------------------------------
784: ---------------------------------------------------------------
785: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
786: ---------------------------------------------------------------
787: cursor c_pct_from_parent(c_PL_GD_OR_SVC_ID number) is
788: select pl_gd_r_svc_ctfn_id
789: from BEN_PL_GD_R_SVC_CTFN_F

Line 789: from BEN_PL_GD_R_SVC_CTFN_F

785: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
786: ---------------------------------------------------------------
787: cursor c_pct_from_parent(c_PL_GD_OR_SVC_ID number) is
788: select pl_gd_r_svc_ctfn_id
789: from BEN_PL_GD_R_SVC_CTFN_F
790: where PL_GD_OR_SVC_ID = c_PL_GD_OR_SVC_ID ;
791: --
792: cursor c_pct(c_pl_gd_r_svc_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
793: select pct.*

Line 794: from BEN_PL_GD_R_SVC_CTFN_F pct

790: where PL_GD_OR_SVC_ID = c_PL_GD_OR_SVC_ID ;
791: --
792: cursor c_pct(c_pl_gd_r_svc_ctfn_id number,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
793: select pct.*
794: from BEN_PL_GD_R_SVC_CTFN_F pct
795: where pct.pl_gd_r_svc_ctfn_id = c_pl_gd_r_svc_ctfn_id
796: -- and pct.business_group_id = p_business_group_id
797: and not exists (
798: select /*+ */ null

Line 805: -- and trt.where_clause = 'BEN_PL_GD_R_SVC_CTFN_F'

801: where copy_entity_txn_id = p_copy_entity_txn_id
802: -- and trt.table_route_id = cpe.table_route_id
803: and ( -- c_mirror_src_entity_result_id is null or
804: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
805: -- and trt.where_clause = 'BEN_PL_GD_R_SVC_CTFN_F'
806: and cpe.table_alias = c_table_alias
807: and information1 = c_pl_gd_r_svc_ctfn_id
808: -- and information4 = pct.business_group_id
809: and information2 = pct.effective_start_date

Line 815: -- END OF BEN_PL_GD_R_SVC_CTFN_F ----------------------

811: );
812:
813: l_out_pct_result_id number(15);
814: ---------------------------------------------------------------
815: -- END OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
816: ---------------------------------------------------------------
817: ---------------------------------------------------------------
818: -- START OF BEN_PL_REGN_F ----------------------
819: ---------------------------------------------------------------

Line 3322: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------

3318: ---------------------------------------------------------------
3319: -- END OF BEN_GD_OR_SVC_TYP ----------------------
3320: ---------------------------------------------------------------
3321: ---------------------------------------------------------------
3322: -- START OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
3323: ---------------------------------------------------------------
3324: --
3325: for l_parent_rec in c_pct_from_parent(l_PL_GD_OR_SVC_ID) loop
3326: --

Line 3445: -- END OF BEN_PL_GD_R_SVC_CTFN_F ----------------------

3441: end loop;
3442: --
3443: end loop;
3444: ---------------------------------------------------------------
3445: -- END OF BEN_PL_GD_R_SVC_CTFN_F ----------------------
3446: ---------------------------------------------------------------
3447: end loop;
3448:
3449: ---------------------------------------------------------------