DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_HR dependencies on BEN_LER_F

Line 128: from ben_ler_f

124: begin
125: begin
126: select ler_id,name,effective_start_date
127: into l_ler_id,l_ler_name,l_effective_start_date
128: from ben_ler_f
129: where effective_end_date = hr_general.end_of_time
130: and business_group_id = p_business_group_id
131: and typ_cd ='GSP'
132: and lf_evt_oper_cd ='PROG';

Line 157: from ben_ler_f

153: if l_status is null then
154: begin
155: select ler_id,name,effective_start_date
156: into l_ler_id,l_ler_name,l_effective_start_date
157: from ben_ler_f
158: where effective_end_date = hr_general.end_of_time
159: and business_group_id = p_business_group_id
160: and typ_cd ='GSP'
161: and lf_evt_oper_cd ='SYNC';