APPS.PQH_GSP_HR_TO_STAGE dependencies on BEN_OPT_F

Line 2129: from ben_opt_f

2125: hr_utility.set_location('opt id is'||p_option_id,10);
2126: hr_utility.set_location('effdate is'||to_char(p_effective_date,'DD-MM-RRRRy'),10);
2127: select mapping_table_pk_id
2128: into l_spinal_point_id
2129: from ben_opt_f
2130: where opt_id = p_option_id
2131: and p_effective_date between effective_start_date and effective_end_date
2132: and mapping_table_name ='PER_SPINAL_POINTS';
2133: hr_utility.set_location('spinal point id is'||l_spinal_point_id,10);

Line 2151: from ben_opt_f

2147: hr_utility.set_location('pt id is'||p_point_id,10);
2148: hr_utility.set_location('effdt is'||to_char(p_effective_date,'DD-MM-RRRR'),20);
2149: select opt_id
2150: into l_opt_id
2151: from ben_opt_f
2152: where mapping_table_pk_id = p_point_id
2153: and p_effective_date between effective_start_date and effective_end_date
2154: and mapping_table_name ='PER_SPINAL_POINTS';
2155: hr_utility.set_location('opt id is'||l_opt_id,30);