eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_PL_F

Line 7: From Ben_Pl_F

3: --
4: Function delete_plan_for_grade(p_grade_id in number) RETURN varchar2 is
5: Cursor Pl is
6: Select PL_Id, Effective_Start_Date, Effective_End_Date, Object_version_number
7: From Ben_Pl_F
8: Where MAPPING_TABLE_NAME = 'PER_GRADES'
9: and MAPPING_TABLE_PK_ID = p_grade_id
10: and Hr_general.Effective_Date
11: between Effective_Start_Date and Effective_End_Date;

Line 21: L_Plan_Ovn_No Ben_Pl_F.Object_Version_Number%TYPE;

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);
25: l_eot date;

Line 22: L_Effective_Start_Date Ben_Pl_F.Effective_Start_date%TYPE;

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);
25: l_eot date;
26: Begin

Line 23: L_Effective_End_Date Ben_Pl_F.Effective_End_date%TYPE;

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);
25: l_eot date;
26: Begin
27: --

Line 286: From Ben_Oipl_F Oipl, Ben_Opt_F opt, Ben_pl_F Pl

282:
283: Cursor Oipl Is
284: Select Oipl.Oipl_id , Oipl.Effective_Start_Date,
285: Oipl.Effective_End_Date, Oipl.Object_version_number
286: From Ben_Oipl_F Oipl, Ben_Opt_F opt, Ben_pl_F Pl
287: Where Opt.MAPPING_TABLE_NAME = 'PER_SPINAL_POINTS'
288: and Opt.MAPPING_TABLE_PK_ID = p_spinal_point_id
289: and p_effective_date
290: between Opt.Effective_Start_Date and Opt.Effective_End_Date

Line 511: From Ben_Pl_F

507: RETURN varchar2 is
508:
509: Cursor Pl is
510: Select PL_Id, Effective_Start_Date, Effective_End_Date,business_group_id
511: From Ben_Pl_F
512: Where MAPPING_TABLE_NAME = 'PER_GRADES'
513: and MAPPING_TABLE_PK_ID = p_grade_id
514: and p_effective_date between Effective_Start_Date and Effective_End_Date;
515: