APPS.PQP_GB_OSP_TEMPLATE dependencies on BEN_ACTY_BASE_RT_F

Line 150: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;

146: ,p_base_name IN VARCHAR2
147: )
148: IS
149:
150: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
151: l_proc_step NUMBER(20,10);
152: l_proc_name VARCHAR2(61):=
153: g_package_name||'del_automated_plan_setup_data';
154:

Line 183: FROM ben_acty_base_rt_f

179: END IF;
180:
181: SELECT acty_base_rt_id
182: INTO l_acty_base_rt_id
183: FROM ben_acty_base_rt_f
184: WHERE pl_id = p_pl_id
185: AND p_effective_date BETWEEN effective_start_date
186: AND effective_end_date;
187: -- the above select will fail if there is more than one standard rate

Line 210: UPDATE ben_acty_base_rt_f

206: IF g_debug THEN
207: debug(l_proc_name,l_proc_step);
208: END IF;
209:
210: UPDATE ben_acty_base_rt_f
211: SET element_type_id = NULL
212: ,input_value_id = NULL
213: ,ele_rqd_flag = 'N'
214: ,object_version_number = object_version_number + 1

Line 263: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;

259: ,p_plan_class IN VARCHAR2 DEFAULT 'OSP'
260: )
261: IS
262:
263: l_acty_base_rt_id ben_acty_base_rt_f.acty_base_rt_id%TYPE;
264: l_proc_step NUMBER(20,10);
265: l_proc_name VARCHAR2(61):=
266: g_package_name||'automate_plan_setup';
267: l_input_name VARCHAR2(40);

Line 308: FROM ben_acty_base_rt_f

304:
305:
306: SELECT acty_base_rt_id
307: INTO l_acty_base_rt_id
308: FROM ben_acty_base_rt_f
309: WHERE pl_id = p_pl_id
310: AND p_effective_date BETWEEN effective_start_date
311: AND effective_end_date;
312:

Line 327: UPDATE ben_acty_base_rt_f

323: ELSE
324: l_input_name := 'LENGTH OF SERVICE' ;
325: END IF;
326:
327: UPDATE ben_acty_base_rt_f
328: SET element_type_id = p_element_type_id
329: ,input_value_id = (SELECT input_value_id
330: FROM pay_input_values_f
331: WHERE element_type_id = p_element_type_id

Line 3353: FROM ben_acty_base_rt_f

3349:
3350: CURSOR csr_chk_ele_in_ben (c_element_type_id number)
3351: IS
3352: SELECT 'X'
3353: FROM ben_acty_base_rt_f
3354: WHERE pl_id = p_plan_id
3355: AND element_type_id = c_element_type_id
3356: AND business_group_id = p_business_group_id;
3357:

Line 3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');

3866:
3867: -- Raise Error
3868: Close csr_chk_ele_in_ben;
3869: hr_utility.set_message (800,'PER_74880_CHILD_RECORD');
3870: hr_utility.set_message_token('TYPE','Standard Rates, Table: BEN_ACTY_BASE_RT_F');
3871: hr_utility.raise_error;
3872:
3873: END IF; -- End if of element in ben check ...
3874: CLOSE csr_chk_ele_in_ben;