APPS.BEN_PLAN_DESIGN_PLAN_MODULE dependencies on BEN_POPL_ACTN_TYP_F

Line 5925: -- START OF BEN_POPL_ACTN_TYP_F ----------------------

5921: -- and trt.where_clause = upper(c_parent_table_name) ;
5922: ---
5923: ---
5924: ---------------------------------------------------------------
5925: -- START OF BEN_POPL_ACTN_TYP_F ----------------------
5926: ---------------------------------------------------------------
5927: cursor c_pat_from_parent(c_PL_ID number, c_PGM_ID number ) is
5928: select popl_actn_typ_id
5929: from BEN_POPL_ACTN_TYP_F

Line 5929: from BEN_POPL_ACTN_TYP_F

5925: -- START OF BEN_POPL_ACTN_TYP_F ----------------------
5926: ---------------------------------------------------------------
5927: cursor c_pat_from_parent(c_PL_ID number, c_PGM_ID number ) is
5928: select popl_actn_typ_id
5929: from BEN_POPL_ACTN_TYP_F
5930: -- where PL_ID = c_PL_ID ;
5931: where ( c_PL_ID is not null and c_PL_ID = PL_ID ) or
5932: ( c_PGM_ID is not null and c_PGM_ID = PGM_ID);
5933: --

Line 5937: from BEN_POPL_ACTN_TYP_F pat

5933: --
5934: cursor c_pat(c_popl_actn_typ_id number,c_mirror_src_entity_result_id number,
5935: c_table_alias varchar2) is
5936: select pat.*
5937: from BEN_POPL_ACTN_TYP_F pat
5938: where pat.popl_actn_typ_id = c_popl_actn_typ_id
5939: -- and pat.business_group_id = p_business_group_id
5940: and not exists (
5941: select /*+ */ null

Line 5948: -- and trt.where_clause = 'BEN_POPL_ACTN_TYP_F'

5944: where copy_entity_txn_id = p_copy_entity_txn_id
5945: -- and trt.table_route_id = cpe.table_route_id
5946: and ( -- c_mirror_src_entity_result_id is null or
5947: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5948: -- and trt.where_clause = 'BEN_POPL_ACTN_TYP_F'
5949: and cpe.table_alias = c_table_alias
5950: and information1 = c_popl_actn_typ_id
5951: -- and information4 = pat.business_group_id
5952: and information2 = pat.effective_start_date

Line 5957: -- END OF BEN_POPL_ACTN_TYP_F ----------------------

5953: and information3 = pat.effective_end_date
5954: );
5955: l_out_pat_result_id number(15);
5956: ---------------------------------------------------------------
5957: -- END OF BEN_POPL_ACTN_TYP_F ----------------------
5958: ---------------------------------------------------------------
5959: ---------------------------------------------------------------
5960: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
5961: ---------------------------------------------------------------

Line 6452: from BEN_POPL_ACTN_TYP_F

6448: -- START OF BEN_ACTN_TYP ----------------------
6449: ---------------------------------------------------------------
6450: cursor c_eat_from_parent(c_POPL_ACTN_TYP_ID number) is
6451: select actn_typ_id
6452: from BEN_POPL_ACTN_TYP_F
6453: where POPL_ACTN_TYP_ID = c_POPL_ACTN_TYP_ID ;
6454: --
6455: cursor c_eat(c_actn_typ_id number,c_mirror_src_entity_result_id number,
6456: c_table_alias varchar2) is

Line 6697: -- START OF BEN_POPL_ACTN_TYP_F ----------------------

6693: l_number_of_copies := p_number_of_copies ;
6694:
6695: --
6696: ---------------------------------------------------------------
6697: -- START OF BEN_POPL_ACTN_TYP_F ----------------------
6698: ---------------------------------------------------------------
6699: --
6700: --
6701: for l_parent_rec in c_pat_from_parent(p_pl_id,p_pgm_id) loop

Line 6911: -- END OF BEN_POPL_ACTN_TYP_F ----------------------

6907: -- END OF BEN_ACTN_TYP ----------------------
6908: ---------------------------------------------------------------
6909: end loop;
6910: ---------------------------------------------------------------
6911: -- END OF BEN_POPL_ACTN_TYP_F ----------------------
6912: ---------------------------------------------------------------
6913: ---------------------------------------------------------------
6914: -- START OF BEN_POPL_ENRT_TYP_CYCL_F ----------------------
6915: ---------------------------------------------------------------