APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 2558: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------

2554: ---------------------------------------------------------------
2555: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
2556: ---------------------------------------------------------------
2557: ---------------------------------------------------------------
2558: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
2559: ---------------------------------------------------------------
2560: cursor c_eou_from_parent(c_ELIGY_PRFL_ID number) is
2561: select elig_org_unit_prte_id
2562: from BEN_ELIG_ORG_UNIT_PRTE_F

Line 2562: from BEN_ELIG_ORG_UNIT_PRTE_F

2558: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
2559: ---------------------------------------------------------------
2560: cursor c_eou_from_parent(c_ELIGY_PRFL_ID number) is
2561: select elig_org_unit_prte_id
2562: from BEN_ELIG_ORG_UNIT_PRTE_F
2563: where ELIGY_PRFL_ID = c_ELIGY_PRFL_ID ;
2564: --
2565: cursor c_eou(c_elig_org_unit_prte_id number,c_mirror_src_entity_result_id number ,
2566: c_table_alias varchar2 ) is

Line 2568: from BEN_ELIG_ORG_UNIT_PRTE_F eou

2564: --
2565: cursor c_eou(c_elig_org_unit_prte_id number,c_mirror_src_entity_result_id number ,
2566: c_table_alias varchar2 ) is
2567: select eou.*
2568: from BEN_ELIG_ORG_UNIT_PRTE_F eou
2569: where eou.elig_org_unit_prte_id = c_elig_org_unit_prte_id
2570: -- and eou.business_group_id = p_business_group_id
2571: and not exists (
2572: select /* */ null

Line 2579: -- and trt.where_clause = 'BEN_ELIG_ORG_UNIT_PRTE_F'

2575: where copy_entity_txn_id = p_copy_entity_txn_id
2576: -- and trt.table_route_id = cpe.table_route_id
2577: and ( -- c_mirror_src_entity_result_id is null or
2578: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
2579: -- and trt.where_clause = 'BEN_ELIG_ORG_UNIT_PRTE_F'
2580: and cpe.table_alias = c_table_alias
2581: and information1 = c_elig_org_unit_prte_id
2582: -- and information4 = eou.business_group_id
2583: and information2 = eou.effective_start_date

Line 2604: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------

2600: order by name;
2601:
2602: --
2603: ---------------------------------------------------------------
2604: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
2605: ---------------------------------------------------------------
2606: ---------------------------------------------------------------
2607: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
2608: ---------------------------------------------------------------

Line 8191: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------

8187: ---------------------------------------------------------------
8188: -- END OF BEN_ELIG_OPTD_MDCR_PRTE_F ----------------------
8189: ---------------------------------------------------------------
8190: ---------------------------------------------------------------
8191: -- START OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
8192: ---------------------------------------------------------------
8193: --
8194: for l_parent_rec in c_eou_from_parent(l_ELIGY_PRFL_ID) loop
8195: --

Line 8336: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------

8332: end loop;
8333: --
8334: end loop;
8335: ---------------------------------------------------------------
8336: -- END OF BEN_ELIG_ORG_UNIT_PRTE_F ----------------------
8337: ---------------------------------------------------------------
8338: ---------------------------------------------------------------
8339: -- START OF BEN_ELIG_OTHR_PTIP_PRTE_F ----------------------
8340: ---------------------------------------------------------------