eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 5960: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------

5956: ---------------------------------------------------------------
5957: -- END OF BEN_POPL_ACTN_TYP_F ----------------------
5958: ---------------------------------------------------------------
5959: ---------------------------------------------------------------
5960: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5961: ---------------------------------------------------------------
5962: cursor c_pet_from_parent(c_PL_ID number, c_PGM_ID number ) is
5963: select distinct popl_enrt_typ_cycl_id
5964: from BEN_POPL_ENRT_TYP_CYCL_F

Line 5964: from BEN_POPL_ENRT_TYP_CYCL_F

5960: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5961: ---------------------------------------------------------------
5962: cursor c_pet_from_parent(c_PL_ID number, c_PGM_ID number ) is
5963: select distinct popl_enrt_typ_cycl_id
5964: from BEN_POPL_ENRT_TYP_CYCL_F
5965: where ( c_PL_ID is not null and c_PL_ID = PL_ID ) or
5966: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
5967: --
5968: cursor c_pet(c_popl_enrt_typ_cycl_id number ,c_mirror_src_entity_result_id number,c_table_alias varchar2) is

Line 5970: from BEN_POPL_ENRT_TYP_CYCL_F pet

5966: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
5967: --
5968: cursor c_pet(c_popl_enrt_typ_cycl_id number ,c_mirror_src_entity_result_id number,c_table_alias varchar2) is
5969: select pet.*
5970: from BEN_POPL_ENRT_TYP_CYCL_F pet
5971: where pet.popl_enrt_typ_cycl_id = c_popl_enrt_typ_cycl_id
5972: -- and pet.business_group_id = p_business_group_id
5973: and not exists (
5974: select /*+ */ null

Line 5981: -- and trt.where_clause = 'BEN_POPL_ENRT_TYP_CYCL_F'

5977: where copy_entity_txn_id = p_copy_entity_txn_id
5978: -- and trt.table_route_id = cpe.table_route_id
5979: and ( -- c_mirror_src_entity_result_id is null or
5980: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5981: -- and trt.where_clause = 'BEN_POPL_ENRT_TYP_CYCL_F'
5982: and cpe.table_alias = c_table_alias
5983: and information1 = c_popl_enrt_typ_cycl_id
5984: -- and information4 = pet.business_group_id
5985: and information2 = pet.effective_start_date

Line 5988: l_pet_popl_enrt_typ_cycl_esd ben_popl_enrt_typ_cycl_f.effective_start_date%type;

5984: -- and information4 = pet.business_group_id
5985: and information2 = pet.effective_start_date
5986: and information3 = pet.effective_end_date
5987: );
5988: l_pet_popl_enrt_typ_cycl_esd ben_popl_enrt_typ_cycl_f.effective_start_date%type;
5989: l_out_pet_result_id number(15);
5990: ---------------------------------------------------------------
5991: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5992: ---------------------------------------------------------------

Line 5991: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------

5987: );
5988: l_pet_popl_enrt_typ_cycl_esd ben_popl_enrt_typ_cycl_f.effective_start_date%type;
5989: l_out_pet_result_id number(15);
5990: ---------------------------------------------------------------
5991: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5992: ---------------------------------------------------------------
5993: ---------------------------------------------------------------
5994: -- START OF BEN_POPL_ORG_F ----------------------
5995: ---------------------------------------------------------------

Line 6914: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------

6910: ---------------------------------------------------------------
6911: -- END OF BEN_POPL_ACTN_TYP_F ----------------------
6912: ---------------------------------------------------------------
6913: ---------------------------------------------------------------
6914: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
6915: ---------------------------------------------------------------
6916: --
6917: for l_parent_rec in c_pet_from_parent(p_pl_id,p_pgm_id) loop
6918: --

Line 7979: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------

7975: ---------------------------------------------------------------
7976: --
7977: end loop;
7978: ---------------------------------------------------------------
7979: -- END OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
7980: ---------------------------------------------------------------
7981: ---------------------------------------------------------------
7982: -- START OF BEN_POPL_ORG_F ----------------------
7983: ---------------------------------------------------------------