APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_VRBL_RT_PRFL_F

Line 5717: -- START OF BEN_VRBL_RT_PRFL_F ----------------------

5713: l_mapping_column_name1 pqh_attributes.attribute_name%type;
5714: l_mapping_column_name2 pqh_attributes.attribute_name%type;
5715:
5716: ---------------------------------------------------------------
5717: -- START OF BEN_VRBL_RT_PRFL_F ----------------------
5718: ---------------------------------------------------------------
5719: cursor c_vpf(c_vrbl_rt_prfl_id number,c_mirror_src_entity_result_id number,
5720: c_table_alias varchar2 ) is
5721: select vpf.*

Line 5722: from BEN_VRBL_RT_PRFL_F vpf

5718: ---------------------------------------------------------------
5719: cursor c_vpf(c_vrbl_rt_prfl_id number,c_mirror_src_entity_result_id number,
5720: c_table_alias varchar2 ) is
5721: select vpf.*
5722: from BEN_VRBL_RT_PRFL_F vpf
5723: where vpf.vrbl_rt_prfl_id = c_vrbl_rt_prfl_id
5724: -- and vpf.business_group_id = p_business_group_id
5725: and not exists (
5726: select /* */ null

Line 5733: -- and trt.where_clause = 'BEN_VRBL_RT_PRFL_F'

5729: where copy_entity_txn_id = p_copy_entity_txn_id
5730: -- and trt.table_route_id = cpe.table_route_id
5731: and ( -- c_mirror_src_entity_result_id is null or
5732: mirror_src_entity_result_id = c_mirror_src_entity_result_id )
5733: -- and trt.where_clause = 'BEN_VRBL_RT_PRFL_F'
5734: and cpe.table_alias = c_table_alias
5735: and information1 = c_vrbl_rt_prfl_id
5736: -- and information4 = vpf.business_group_id
5737: and information2 = vpf.effective_start_date

Line 5742: -- END OF BEN_VRBL_RT_PRFL_F ----------------------

5738: and information3 = vpf.effective_end_date);
5739: l_vrbl_rt_prfl_id number(15);
5740: l_out_vpf_result_id number(15);
5741: ---------------------------------------------------------------
5742: -- END OF BEN_VRBL_RT_PRFL_F ----------------------
5743: ---------------------------------------------------------------
5744: ---------------------------------------------------------------
5745: -- START OF BEN_AGE_RT_F ----------------------
5746: ---------------------------------------------------------------

Line 7964: -- START OF BEN_VRBL_RT_PRFL_F ----------------------

7960: end if;
7961:
7962: l_number_of_copies := p_number_of_copies ;
7963: ---------------------------------------------------------------
7964: -- START OF BEN_VRBL_RT_PRFL_F ----------------------
7965: ---------------------------------------------------------------
7966: --
7967: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
7968: l_vrbl_rt_prfl_id := p_vrbl_rt_prfl_id ;

Line 15071: -- END OF BEN_VRBL_RT_PRFL_F ----------------------

15067: ---------------------------------------------------------------
15068: -- END OF BEN_OTHR_PTIP_RT_F ----------------------
15069: ---------------------------------------------------------------
15070: ---------------------------------------------------------------
15071: -- END OF BEN_VRBL_RT_PRFL_F ----------------------
15072: ---------------------------------------------------------------
15073: hr_utility.set_location(' end create_vapro_results ',100);
15074: end create_vapro_results;
15075: --