APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_SCHEDD_ENRT_RL_F

Line 6343: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------

6339: ---------------------------------------------------------------
6340: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
6341: ---------------------------------------------------------------
6342: ---------------------------------------------------------------
6343: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
6344: ---------------------------------------------------------------
6345: cursor c_ser_from_parent(c_ENRT_PERD_ID number) is
6346: select schedd_enrt_rl_id
6347: from BEN_SCHEDD_ENRT_RL_F

Line 6347: from BEN_SCHEDD_ENRT_RL_F

6343: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
6344: ---------------------------------------------------------------
6345: cursor c_ser_from_parent(c_ENRT_PERD_ID number) is
6346: select schedd_enrt_rl_id
6347: from BEN_SCHEDD_ENRT_RL_F
6348: where ENRT_PERD_ID = c_ENRT_PERD_ID ;
6349: --
6350: cursor c_ser(c_schedd_enrt_rl_id number,c_mirror_src_entity_result_id number,
6351: c_table_alias varchar2) is

Line 6353: from BEN_SCHEDD_ENRT_RL_F ser

6349: --
6350: cursor c_ser(c_schedd_enrt_rl_id number,c_mirror_src_entity_result_id number,
6351: c_table_alias varchar2) is
6352: select ser.*
6353: from BEN_SCHEDD_ENRT_RL_F ser
6354: where ser.schedd_enrt_rl_id = c_schedd_enrt_rl_id
6355: -- and ser.business_group_id = p_business_group_id
6356: and not exists (
6357: select /*+ */ null

Line 6364: -- and trt.where_clause = 'BEN_SCHEDD_ENRT_RL_F'

6360: where copy_entity_txn_id = p_copy_entity_txn_id
6361: -- and trt.table_route_id = cpe.table_route_id
6362: and ( -- c_mirror_src_entity_result_id is null or
6363: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6364: -- and trt.where_clause = 'BEN_SCHEDD_ENRT_RL_F'
6365: and cpe.table_alias = c_table_alias
6366: and information1 = c_schedd_enrt_rl_id
6367: -- and information4 = ser.business_group_id
6368: and information2 = ser.effective_start_date

Line 6373: -- END OF BEN_SCHEDD_ENRT_RL_F ----------------------

6369: and information3 = ser.effective_end_date
6370: );
6371: l_out_ser_result_id number(15);
6372: ---------------------------------------------------------------
6373: -- END OF BEN_SCHEDD_ENRT_RL_F ----------------------
6374: ---------------------------------------------------------------
6375: ---------------------------------------------------------------
6376: -- START OF BEN_LEE_RSN_RL_F ----------------------
6377: ---------------------------------------------------------------

Line 7440: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------

7436: ---------------------------------------------------------------
7437: -- END OF BEN_ENRT_PERD_FOR_PL_F ----------------------
7438: ---------------------------------------------------------------
7439: ---------------------------------------------------------------
7440: -- START OF BEN_SCHEDD_ENRT_RL_F ----------------------
7441: ---------------------------------------------------------------
7442: --
7443: for l_parent_rec in c_ser_from_parent(l_ENRT_PERD_ID) loop
7444: --

Line 7547: -- END OF BEN_SCHEDD_ENRT_RL_F ----------------------

7543: end loop;
7544: --
7545: end loop;
7546: ---------------------------------------------------------------
7547: -- END OF BEN_SCHEDD_ENRT_RL_F ----------------------
7548: ---------------------------------------------------------------
7549: end loop;
7550: ---------------------------------------------------------------
7551: -- END OF BEN_ENRT_PERD ----------------------