APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIGY_PRFL_F

Line 2359: hr_utility.set_location(' BEN_ELIGY_PRFL_F CREATE_ELIGY_PROFILE ',20);

2355: else
2356: l_pr_flag := 'N';
2357: end if;
2358: if l_dml_operation = 'INSERT' then
2359: hr_utility.set_location(' BEN_ELIGY_PRFL_F CREATE_ELIGY_PROFILE ',20);
2360: begin
2361: BEN_ELIGY_PROFILE_API.CREATE_ELIGY_PROFILE(
2362: P_EFFECTIVE_DATE => l_effective_date
2363: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 2544: l_dt_mode := get_update_mode(p_table_name => 'BEN_ELIGY_PRFL_F',

2540: hr_utility.set_location('After plsql table ',222);
2541: elsif l_dml_operation = 'UPDATE' then
2542: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
2543: if p_datetrack_mode <> 'CORRECTION' then
2544: l_dt_mode := get_update_mode(p_table_name => 'BEN_ELIGY_PRFL_F',
2545: p_key_column_name => 'ELIGY_PRFL_ID',
2546: p_key_column_value => l_elp_id,
2547: p_effective_date => l_effective_date);
2548: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 2552: l_db_ovn := get_ovn(p_table_name => 'BEN_ELIGY_PRFL_F',

2548: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
2549: else
2550: l_dt_mode := p_datetrack_mode;
2551: end if;
2552: l_db_ovn := get_ovn(p_table_name => 'BEN_ELIGY_PRFL_F',
2553: p_key_column_name => 'ELIGY_PRFL_ID',
2554: p_key_column_value => l_elp_id,
2555: p_effective_date => l_effective_date);
2556: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 2564: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);

2560: fnd_message.set_token('OBJECT ',l_object);
2561: fnd_message.set_token('OBJECT_NAME ',r_ELP.INFORMATION151);
2562: fnd_message.raise_error;
2563: else
2564: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);
2565: begin
2566: BEN_ELIGY_PROFILE_API.UPDATE_ELIGY_PROFILE(
2567: P_EFFECTIVE_DATE => l_effective_date
2568: ,P_BUSINESS_GROUP_ID => p_business_group_id

Line 3865: from BEN_ELIGY_PRFL_F elp

3861:
3862: update ben_copy_entity_results cer
3863: set information263 =
3864: ( select ELIGY_PRFL_ID
3865: from BEN_ELIGY_PRFL_F elp
3866: where elp.BUSINESS_GROUP_ID = p_business_group_id
3867: and elp.name = cer.information5
3868: and p_effective_date between
3869: elp.effective_start_date and elp.effective_end_date)

Line 3876: from BEN_ELIGY_PRFL_F elp

3872: and cer.table_alias = 'CEP'
3873: and p_effective_date between
3874: cer.information2 and nvl(cer.information3,to_date('4712/12/31','YYYY/MM/DD'))
3875: and exists ( select ELIGY_PRFL_ID
3876: from BEN_ELIGY_PRFL_F elp
3877: where elp.BUSINESS_GROUP_ID = p_business_group_id
3878: and elp.name = cer.information5
3879: and p_effective_date between
3880: elp.effective_start_date and elp.effective_end_date);