APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_PLIP_F

Line 15: From Ben_plip_F

11: between Effective_Start_Date and Effective_End_Date;
12:
13: Cursor Plip (P_Pl_id in Number) Is
14: Select plip_Id, Effective_Start_Date, Effective_End_Date, Object_version_number
15: From Ben_plip_F
16: Where Pl_Id = P_Pl_Id
17: and Hr_general.Effective_Date
18: between Effective_Start_Date and Effective_End_Date;
19:

Line 20: L_plip_Ovn_No Ben_Plip_F.Object_Version_Number%TYPE;

16: Where Pl_Id = P_Pl_Id
17: and Hr_general.Effective_Date
18: between Effective_Start_Date and Effective_End_Date;
19:
20: L_plip_Ovn_No Ben_Plip_F.Object_Version_Number%TYPE;
21: L_Plan_Ovn_No Ben_Pl_F.Object_Version_Number%TYPE;
22: L_Effective_Start_Date Ben_Pl_F.Effective_Start_date%TYPE;
23: L_Effective_End_Date Ben_Pl_F.Effective_End_date%TYPE;
24: l_datetrack_mode varchar2(30);