DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_HR dependencies on BEN_ACTY_BASE_RT_F

Line 322: l_Acty_Base_Rate_Ovn ben_acty_base_rt_f.Object_version_Number%TYPE;

318: L_FUTURE_CHANGE BOOLEAN;
319: L_DELETE_NEXT_CHANGE BOOLEAN;
320: l_Plcmt_Cnt Number;
321: -- Bug7674132
322: l_Acty_Base_Rate_Ovn ben_acty_base_rt_f.Object_version_Number%TYPE;
323: l_Acty_Base_Rate_Id ben_acty_base_rt_f.Acty_Base_Rt_Id%TYPE;
324:
325: Cursor csr_Del_Oipl (P_Plip_Cer_Id IN Number) is
326: Select information253 Step_id,

Line 323: l_Acty_Base_Rate_Id ben_acty_base_rt_f.Acty_Base_Rt_Id%TYPE;

319: L_DELETE_NEXT_CHANGE BOOLEAN;
320: l_Plcmt_Cnt Number;
321: -- Bug7674132
322: l_Acty_Base_Rate_Ovn ben_acty_base_rt_f.Object_version_Number%TYPE;
323: l_Acty_Base_Rate_Id ben_acty_base_rt_f.Acty_Base_Rt_Id%TYPE;
324:
325: Cursor csr_Del_Oipl (P_Plip_Cer_Id IN Number) is
326: Select information253 Step_id,
327: information254 Step_Ovn

Line 388: From ben_acty_base_rt_f

384: And dml_operation = 'DELETE';
385:
386: Cursor Acty_Rt_Nam_Dtl (Acty_Rate_Id IN NUMBER) is
387: Select Acty_Base_Rt_Id, Object_version_Number
388: From ben_acty_base_rt_f
389: Where Acty_Base_Rt_Id = Acty_Rate_Id;
390:
391: Begin
392: