DBA Data[Home] [Help]

APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_PLIP_F

Line 2327: from ben_plip_f

2323: begin
2324: begin
2325: select pl_id
2326: into p_plan_id
2327: from ben_plip_f
2328: where plip_id = p_plip_id
2329: and p_effective_date between effective_start_date and effective_end_date;
2330: hr_utility.set_location('plan is '||p_plan_id,10);
2331: exception

Line 5967: from ben_plip_f

5963: begin
5964: begin
5965: select plip_id
5966: into l_plip_id
5967: from ben_plip_f
5968: where pgm_id = p_pgm_id
5969: and pl_id = p_plan_id
5970: and p_effective_date between effective_start_date and effective_end_date;
5971: hr_utility.set_location('plip is '||l_plip_id,10);