DBA Data[Home] [Help]

APPS.PQH_GSP_STAGE_TO_HR dependencies on BEN_ACTY_VRBL_RT_F

Line 556: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;

552: and Table_Alias = 'HRRATE'
553: and Nvl(Dml_operation,'XX') <> 'DELETE'
554: and Information293 = P_Rate_Id);
555:
556: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;

Line 557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;

553: and Nvl(Dml_operation,'XX') <> 'DELETE'
554: and Information293 = P_Rate_Id);
555:
556: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;
561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;

Line 558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;

554: and Information293 = P_Rate_Id);
555:
556: L_Hr_Rt_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
557: L_Hr_Rt_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
558: l_Hr_RT_Ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
559:
560: l_Rate_type Pay_Rates.Rate_Type%TYPE;
561: l_Rate_Ovn PAy_rates.Object_version_Number%TYPE;
562: l_rate_Id Pay_rates.Rate_Id%TYPE;