APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_POPL_ORG_ROLE_F

Line 6127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------

6123: ---------------------------------------------------------------
6124: -- END OF BEN_YR_PERD ----------------------
6125: ---------------------------------------------------------------
6126: ---------------------------------------------------------------
6127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------
6128: ---------------------------------------------------------------
6129: cursor c_cpr_from_parent(c_POPL_ORG_ID number) is
6130: select popl_org_role_id
6131: from BEN_POPL_ORG_ROLE_F

Line 6131: from BEN_POPL_ORG_ROLE_F

6127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------
6128: ---------------------------------------------------------------
6129: cursor c_cpr_from_parent(c_POPL_ORG_ID number) is
6130: select popl_org_role_id
6131: from BEN_POPL_ORG_ROLE_F
6132: where POPL_ORG_ID = c_POPL_ORG_ID ;
6133: --
6134: cursor c_cpr(c_popl_org_role_id number ,c_mirror_src_entity_result_id number,
6135: c_table_alias varchar2) is

Line 6137: from BEN_POPL_ORG_ROLE_F cpr

6133: --
6134: cursor c_cpr(c_popl_org_role_id number ,c_mirror_src_entity_result_id number,
6135: c_table_alias varchar2) is
6136: select cpr.*
6137: from BEN_POPL_ORG_ROLE_F cpr
6138: where cpr.popl_org_role_id = c_popl_org_role_id
6139: -- and cpr.business_group_id = p_business_group_id
6140: and not exists (
6141: select /*+ */ null

Line 6148: -- and trt.where_clause = 'BEN_POPL_ORG_ROLE_F'

6144: where copy_entity_txn_id = p_copy_entity_txn_id
6145: -- and trt.table_route_id = cpe.table_route_id
6146: and ( -- c_mirror_src_entity_result_id is null or
6147: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
6148: -- and trt.where_clause = 'BEN_POPL_ORG_ROLE_F'
6149: and cpe.table_alias = c_table_alias
6150: and information1 = c_popl_org_role_id
6151: -- and information4 = cpr.business_group_id
6152: and information2 = cpr.effective_start_date

Line 6157: -- END OF BEN_POPL_ORG_ROLE_F ----------------------

6153: and information3 = cpr.effective_end_date
6154: );
6155: l_out_cpr_result_id number(15);
6156: ---------------------------------------------------------------
6157: -- END OF BEN_POPL_ORG_ROLE_F ----------------------
6158: ---------------------------------------------------------------
6159: ---------------------------------------------------------------
6160: -- START OF BEN_RPTG_GRP ----------------------
6161: ---------------------------------------------------------------

Line 8127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------

8123:
8124: end loop;
8125: --
8126: ---------------------------------------------------------------
8127: -- START OF BEN_POPL_ORG_ROLE_F ----------------------
8128: ---------------------------------------------------------------
8129: --
8130: for l_parent_rec in c_cpr_from_parent(l_POPL_ORG_ID) loop
8131: --

Line 8220: -- END OF BEN_POPL_ORG_ROLE_F ----------------------

8216: end loop;
8217: --
8218: end loop;
8219: ---------------------------------------------------------------
8220: -- END OF BEN_POPL_ORG_ROLE_F ----------------------
8221: ---------------------------------------------------------------
8222: end loop;
8223: ---------------------------------------------------------------
8224: -- END OF BEN_POPL_ORG_F ----------------------