APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 949: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------

945: -- where -- trt.from_clause = 'OAB'
946: -- trt.table_alias = c_parent_table_alias ;
947: ---
948: ---------------------------------------------------------------
949: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
950: ---------------------------------------------------------------
951: cursor c_ade_from_parent(c_pgm_id number,c_ptip_id number,c_pl_id number ) is
952: select distinct apld_dpnt_cvg_elig_prfl_id
953: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

Line 953: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

949: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
950: ---------------------------------------------------------------
951: cursor c_ade_from_parent(c_pgm_id number,c_ptip_id number,c_pl_id number ) is
952: select distinct apld_dpnt_cvg_elig_prfl_id
953: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
954: where (c_pgm_id is not null and pgm_id = c_pgm_id ) or
955: (c_ptip_id is not null and ptip_id = c_ptip_id) or
956: (c_pl_id is not null and pl_id = c_pl_id) ;
957: --

Line 961: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ade

957: --
958: cursor c_ade(c_apld_dpnt_cvg_elig_prfl_id number,c_mirror_src_entity_result_id number ,
959: c_table_alias varchar2 ) is
960: select ade.*
961: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F ade
962: where ade.apld_dpnt_cvg_elig_prfl_id = c_apld_dpnt_cvg_elig_prfl_id
963: -- and ade.business_group_id = p_business_group_id
964: and not exists (
965: select /* */ null

Line 972: -- and trt.where_clause = 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F'

968: where copy_entity_txn_id = p_copy_entity_txn_id
969: -- and trt.table_route_id = cpe.table_route_id
970: and ( -- c_mirror_src_entity_result_id is null or
971: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
972: -- and trt.where_clause = 'BEN_APLD_DPNT_CVG_ELIG_PRFL_F'
973: and cpe.table_alias = c_table_alias
974: and information1 = c_apld_dpnt_cvg_elig_prfl_id
975: -- and information4 = ade.business_group_id
976: and information2 = ade.effective_start_date

Line 982: -- END OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------

978: );
979: l_apld_dpnt_cvg_elig_prfl_id number(15);
980: l_out_ade_result_id number(15);
981: ---------------------------------------------------------------
982: -- END OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
983: ---------------------------------------------------------------
984: ---------------------------------------------------------------
985: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
986: ---------------------------------------------------------------

Line 989: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F

985: -- START OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------
986: ---------------------------------------------------------------
987: cursor c_dce_from_parent(c_APLD_DPNT_CVG_ELIG_PRFL_ID number) is
988: select distinct dpnt_cvg_eligy_prfl_id
989: from BEN_APLD_DPNT_CVG_ELIG_PRFL_F
990: where APLD_DPNT_CVG_ELIG_PRFL_ID = c_APLD_DPNT_CVG_ELIG_PRFL_ID ;
991: --
992: ---------------------------------------------------------------
993: -- END OF BEN_DPNT_CVG_ELIGY_PRFL_F ----------------------

Line 1005: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------

1001:
1002: begin
1003: l_number_of_copies := p_number_of_copies ;
1004: ---------------------------------------------------------------
1005: -- START OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
1006: ---------------------------------------------------------------
1007: --
1008: for l_parent_rec in c_ade_from_parent(p_pgm_id,p_ptip_id,p_pl_id) loop
1009: --

Line 1040: p_parent_entity_result_id => null, -- Hide BEN_APLD_DPNT_CVG_ELIG_PRFL_F for HGrid

1036: p_copy_entity_result_id => l_copy_entity_result_id,
1037: p_copy_entity_txn_id => p_copy_entity_txn_id,
1038: p_result_type_cd => l_result_type_cd,
1039: p_mirror_src_entity_result_id => l_mirror_src_entity_result_id,
1040: p_parent_entity_result_id => null, -- Hide BEN_APLD_DPNT_CVG_ELIG_PRFL_F for HGrid
1041: p_number_of_copies => l_number_of_copies,
1042: p_table_route_id => l_table_route_id,
1043: P_TABLE_ALIAS => 'ADE',
1044: p_information1 => l_ade_rec.apld_dpnt_cvg_elig_prfl_id,

Line 1137: -- END OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------

1133: end loop;
1134: --
1135: end loop;
1136: ---------------------------------------------------------------
1137: -- END OF BEN_APLD_DPNT_CVG_ELIG_PRFL_F ----------------------
1138: ---------------------------------------------------------------
1139: null ;
1140: end ;
1141: