APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on HR_GENERAL

Line 10: and Hr_general.Effective_Date

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;
12:
13: Cursor Plip (P_Pl_id in Number) Is
14: Select plip_Id, Effective_Start_Date, Effective_End_Date, Object_version_number

Line 17: and Hr_general.Effective_Date

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:
20: L_plip_Ovn_No Ben_Plip_F.Object_Version_Number%TYPE;
21: L_Plan_Ovn_No Ben_Pl_F.Object_Version_Number%TYPE;

Line 51: ,p_effective_date => Hr_general.Effective_Date

47: (p_plip_id => PLip_rec.Plip_Id
48: ,p_effective_start_date => L_Effective_Start_Date
49: ,p_effective_end_date => L_Effective_End_Date
50: ,p_object_version_number => L_plip_Ovn_No
51: ,p_effective_date => Hr_general.Effective_Date
52: ,p_datetrack_mode => l_datetrack_mode);
53: exception
54: when others then
55: hr_utility.set_location('issues in deleting plip ',30);

Line 73: ,p_effective_date => Hr_general.Effective_Date

69: (p_pl_id => Pl_Rec.Pl_Id
70: ,p_effective_start_date => L_Effective_Start_Date
71: ,p_effective_end_date => L_Effective_End_Date
72: ,p_object_version_number => L_Plan_Ovn_No
73: ,p_effective_date => Hr_general.Effective_Date
74: ,p_datetrack_mode => l_datetrack_mode);
75: End Loop;
76: --
77: Return 'SUCCESS';

Line 221: l_effective_date := Hr_general.Effective_Date;

217: l_Opt_Typ_Eed Ben_Pl_Typ_Opt_Typ_F.Effective_End_Date%TYPE;
218: l_Opt_typ_Ovn Ben_Pl_Typ_Opt_Typ_F.Object_Version_Number%TYPE;
219: Begin
220: --
221: l_effective_date := Hr_general.Effective_Date;
222: l_eot := to_date('31/12/4712','dd/mm/RRRR');
223: --
224: --1. Find the option corresponding to the spinal point.
225: --2. Delete the option. No need to delete option in plan records