582: and Table_Alias = 'HRRATE'
583: and Nvl(Dml_operation,'XX') <> 'DELETE'
584: and Information293 = P_Rate_Id);
585:
586: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
587: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
583: and Nvl(Dml_operation,'XX') <> 'DELETE'
584: and Information293 = P_Rate_Id);
585:
586: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
587: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
584: and Information293 = P_Rate_Id);
585:
586: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
587: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
588: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
589:
590: l_Rate_type Pay_Rates.Rate_Type%TYPE;
591: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
592: l_rate_Id Pay_rates.Rate_Id%TYPE;