APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_OIPL_F

Line 344: from ben_oipl_f

340: hr_utility.set_location('opt id is '||p_opt_id,1);
341: hr_utility.set_location('pl id is '||p_pl_id,2);
342: select oipl_id
343: into l_oipl_id
344: from ben_oipl_f
345: where pl_id = p_pl_id
346: and opt_id = p_opt_id
347: and p_effective_date between effective_start_date and effective_end_date;
348: hr_utility.set_location('oipl is '||l_oipl_id,3);

Line 1840: hr_utility.set_location(' BEN_OIPL_F CREATE_OPTION_IN_PLAN ',20);

1836: and l_pl_id is not null
1837: and l_ovn is null
1838: and l_opt_id is not null then
1839: if l_oipl_id is null then
1840: hr_utility.set_location(' BEN_OIPL_F CREATE_OPTION_IN_PLAN ',20);
1841: --DN: Start code for BugId: 3242976
1842: begin
1843: SELECT grd.date_from
1844: INTO l_grd_effstdt

Line 1907: hr_utility.set_location(' BEN_OIPL_F UPDATE_OPTION_IN_PLAN ',30);

1903: elsif l_oipl_id is not null and r_cop.dml_operation ='UPDATE'
1904: and l_ovn is not null
1905: and l_pl_id is not null
1906: and l_opt_id is not null then
1907: hr_utility.set_location(' BEN_OIPL_F UPDATE_OPTION_IN_PLAN ',30);
1908: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1909: if p_datetrack_mode <> 'CORRECTION' then
1910: l_dt_mode := get_update_mode(p_table_name => 'BEN_OIPL_F',
1911: p_key_column_name => 'OIPL_ID',

Line 1910: l_dt_mode := get_update_mode(p_table_name => 'BEN_OIPL_F',

1906: and l_opt_id is not null then
1907: hr_utility.set_location(' BEN_OIPL_F UPDATE_OPTION_IN_PLAN ',30);
1908: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1909: if p_datetrack_mode <> 'CORRECTION' then
1910: l_dt_mode := get_update_mode(p_table_name => 'BEN_OIPL_F',
1911: p_key_column_name => 'OIPL_ID',
1912: p_key_column_value => l_oipl_id,
1913: p_effective_date => l_effective_date);
1914: else

Line 1918: l_db_ovn := get_ovn(p_table_name => 'BEN_OIPL_F',

1914: else
1915: l_dt_mode := p_datetrack_mode;
1916: end if;
1917: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1918: l_db_ovn := get_ovn(p_table_name => 'BEN_OIPL_F',
1919: p_key_column_name => 'OIPL_ID',
1920: p_key_column_value => l_oipl_id,
1921: p_effective_date => l_effective_date);
1922: hr_utility.set_location(' ovn is '||l_db_ovn,30);