APPS.PQH_GSP_SYNC_COMPENSATION_OBJ dependencies on BEN_ACTY_BASE_RT_F

Line 93: l_Business_group_id Ben_Acty_base_Rt_F.business_group_id%TYPE;

89: p_effective_date in date,
90: p_datetrack_mode in varchar2)
91: RETURN varchar2 is
92:
93: l_Business_group_id Ben_Acty_base_Rt_F.business_group_id%TYPE;
94:
95: Cursor csr_business_group_id
96: is
97: select business_group_id

Line 108: From Ben_Acty_base_Rt_F

104:
105: Cursor Rates Is
106: Select ACTY_BASE_RT_ID, Effective_Start_Date,
107: Effective_End_Date, Object_version_number
108: From Ben_Acty_base_Rt_F
109: Where PAY_RATE_GRADE_RULE_ID = p_grade_rule_id
110: and p_effective_date
111: Between Effective_Start_Date and Effective_End_Date
112: and business_group_id = l_business_group_id;

Line 123: L_Effective_Start_Date Ben_Acty_base_Rt_F.Effective_Start_Date%TYPE;

119: and P_Effective_Date
120: Between Effective_Start_Date
121: and Effective_End_Date;
122:
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;

Line 124: L_Effective_End_Date Ben_Acty_base_Rt_F.Effective_End_Date%TYPE;

120: Between Effective_Start_Date
121: and Effective_End_Date;
122:
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;

Line 125: l_Object_version_Number Ben_Acty_base_Rt_F.Object_version_Number%TYPE;

121: and Effective_End_Date;
122:
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;