APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_ELIGY_PRFL_F

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

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

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

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

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

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

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

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

Line 3864: from BEN_ELIGY_PRFL_F elp

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

Line 3875: from BEN_ELIGY_PRFL_F elp

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