APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_ACTY_VRBL_RT_F

Line 117: From Ben_Acty_Vrbl_Rt_F

113:
114: Cursor Csr_Var_rt (P_Acty_Base_Rt_Id IN Number) is
115: Select Acty_Vrbl_Rt_Id,
116: Object_Version_Number
117: From Ben_Acty_Vrbl_Rt_F
118: Where Acty_base_rt_Id = P_Acty_Base_rt_Id
119: and P_Effective_Date
120: Between Effective_Start_Date
121: and Effective_End_Date;

Line 127: L_Vrbl_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;

123: L_Effective_Start_Date Ben_Acty_base_Rt_F.Effective_Start_Date%TYPE;
124: L_Effective_End_Date Ben_Acty_base_Rt_F.Effective_End_Date%TYPE;
125: l_Object_version_Number Ben_Acty_base_Rt_F.Object_version_Number%TYPE;
126:
127: L_Vrbl_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
128: L_Vrbl_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
129: l_Vrbl_ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
130:
131: Begin

Line 128: L_Vrbl_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;

124: L_Effective_End_Date Ben_Acty_base_Rt_F.Effective_End_Date%TYPE;
125: l_Object_version_Number Ben_Acty_base_Rt_F.Object_version_Number%TYPE;
126:
127: L_Vrbl_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
128: L_Vrbl_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
129: l_Vrbl_ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
130:
131: Begin
132: --

Line 129: l_Vrbl_ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;

125: l_Object_version_Number Ben_Acty_base_Rt_F.Object_version_Number%TYPE;
126:
127: L_Vrbl_Esd Ben_Acty_Vrbl_Rt_F.Effective_Start_Date%TYPE;
128: L_Vrbl_Eed Ben_Acty_Vrbl_Rt_F.Effective_End_Date%TYPE;
129: l_Vrbl_ovn Ben_Acty_Vrbl_Rt_F.Object_version_Number%TYPE;
130:
131: Begin
132: --
133: -- 1. Find the Standard rate which references the grade rule.