APPS.PQH_GSP_STAGE_TO_BEN dependencies on BEN_PL_F

Line 1257: hr_utility.set_location(' BEN_PL_F CREATE_PLAN ',4);

1253: l_pl_name := nvl(r_PLN.INFORMATION170,r_PLN.INFORMATION5);
1254: begin
1255: if l_pl_id is null and r_pln.dml_operation in ('INSERT','COPIED','UPD_INS')
1256: and r_pln.information294 is not null then
1257: hr_utility.set_location(' BEN_PL_F CREATE_PLAN ',4);
1258: BEN_PLAN_API.CREATE_PLAN(
1259: P_EFFECTIVE_DATE => l_effective_date
1260: ,P_BUSINESS_GROUP_ID => p_business_group_id
1261: ,P_ACTL_PREM_ID => r_PLN.INFORMATION250

Line 1412: hr_utility.set_location(' BEN_PL_F UPDATE_PLAN ',30);

1408: p_plip_cer_id => r_PLN.gs_mirror_src_entity_result_id);
1409: hr_utility.set_location('pl wrtback comp ',15);
1410: elsif r_pln.dml_operation = 'UPDATE' and l_pl_id is not null
1411: and r_pln.information294 is not null then
1412: hr_utility.set_location(' BEN_PL_F UPDATE_PLAN ',30);
1413: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1414: if p_datetrack_mode <> 'CORRECTION' then
1415: l_dt_mode := get_update_mode(p_table_name => 'BEN_PL_F',
1416: p_key_column_name => 'PL_ID',

Line 1415: l_dt_mode := get_update_mode(p_table_name => 'BEN_PL_F',

1411: and r_pln.information294 is not null then
1412: hr_utility.set_location(' BEN_PL_F UPDATE_PLAN ',30);
1413: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
1414: if p_datetrack_mode <> 'CORRECTION' then
1415: l_dt_mode := get_update_mode(p_table_name => 'BEN_PL_F',
1416: p_key_column_name => 'PL_ID',
1417: p_key_column_value => l_pl_id,
1418: p_effective_date => l_effective_date);
1419: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 1423: l_db_ovn := get_ovn(p_table_name => 'BEN_PL_F',

1419: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1420: else
1421: l_dt_mode := p_datetrack_mode;
1422: end if;
1423: l_db_ovn := get_ovn(p_table_name => 'BEN_PL_F',
1424: p_key_column_name => 'PL_ID',
1425: p_key_column_value => l_pl_id,
1426: p_effective_date => l_effective_date);
1427: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1846: ben_pl_f pln

1842: begin
1843: SELECT grd.date_from
1844: INTO l_grd_effstdt
1845: FROM per_grades grd,
1846: ben_pl_f pln
1847: WHERE pln.pl_id = l_pl_id
1848: AND p_effective_date BETWEEN pln.effective_start_date
1849: AND pln.effective_end_date
1850: AND grd.grade_id = pln.mapping_table_pk_id;