APPS.PER_ASG_BUS3 dependencies on BEN_PGM_F

Line 2417: from ben_pgm_f

2413: -- cursor declare
2414: --
2415: cursor csr_pgm is
2416: select null
2417: from ben_pgm_f
2418: where business_group_id = p_business_group_id
2419: and pgm_typ_cd = 'GSP'
2420: and pgm_id = p_grade_ladder_pgm_id
2421: and p_effective_date

Line 2430: ,ben_pgm_f pgm

2426: cursor csr_plip is
2427: select null
2428: from ben_plip_f plip
2429: ,ben_pl_f plan
2430: ,ben_pgm_f pgm
2431: where plan.mapping_table_name = 'PER_GRADES'
2432: and plan.mapping_table_pk_id = p_grade_id
2433: and plan.business_group_id = p_business_group_id
2434: and plan.pl_stat_cd = 'A'

Line 2470: -- grade_ladder_pgm_id is no in ben_pgm_f table

2466: if csr_pgm%notfound then
2467: close csr_pgm;
2468: hr_utility.set_location(l_proc, 30);
2469: --
2470: -- grade_ladder_pgm_id is no in ben_pgm_f table
2471: --
2472: -- Bug 2661569
2473: -- Changed the calls to hr_utility.set_message and hr_utility.raise_error
2474: hr_utility.set_message(801, 'HR_289561_GRADE_LADDER_INVALID');

Line 2491: -- grade_ladder_pgm_id is no in ben_pgm_f table

2487: if csr_pgm%notfound then
2488: close csr_pgm;
2489: hr_utility.set_location(l_proc, 50);
2490: --
2491: -- grade_ladder_pgm_id is no in ben_pgm_f table
2492: --
2493: -- Bug 2661569
2494: -- Changed the calls to hr_utility.set_message and hr_utility.raise_error
2495: hr_utility.set_message(801, 'HR_289561_GRADE_LADDER_INVALID');