APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 235: FROM pay_input_values_f

231: CURSOR c_ip_val
232: ( c_element_type_id IN NUMBER
233: ,c_name IN VARCHAR2) IS
234: SELECT input_value_id
235: FROM pay_input_values_f
236: WHERE element_type_id = c_element_type_id
237: AND trunc(p_scheme_start_date) BETWEEN
238: effective_start_date AND effective_end_date
239: AND name = c_name;

Line 381: from pay_input_values_f piv

377: ,c_iv_name varchar2) is
378: select input_value_id
379: ,piv.name
380: ,piv.element_type_id
381: from pay_input_values_f piv
382: ,pay_element_types_f pet
383: where element_name = c_ele_name
384: and piv.element_type_id = pet.element_type_id
385: and (piv.business_group_id = p_business_group_id or

Line 394: from pay_input_values_f

390:
391: cursor csr_updinput(c_ip_id number
392: ,c_element_type_id number) is
393: select rowid
394: from pay_input_values_f
395: where input_value_id = c_ip_id
396: and element_type_id = c_element_type_id
397: for update nowait;
398:

Line 424: update pay_input_values_f

420: exit when csr_updinput%notfound;
421: --
422: hr_utility.set_location (l_proc_name, 30);
423: --
424: update pay_input_values_f
425: set default_value = p_def_value
426: where rowid = csr_updinput_rec.rowid;
427: end loop;
428: close csr_updinput;

Line 587: from pay_input_values_f

583: --
584: cursor csr_ipv (c_ele_typeid number
585: ,c_effective_date date) is
586: select input_value_id
587: from pay_input_values_f
588: where element_type_id = c_ele_typeid
589: and business_group_id = p_business_group_id
590: and name = 'Pay Value'
591: and c_effective_date between effective_start_date

Line 598: from pay_input_values_f

594: cursor csr_ipv1 (c_ele_typeid number
595: ,c_ipv_name varchar2
596: ,c_effective_date date) is
597: select input_value_id
598: from pay_input_values_f
599: where element_type_id = c_ele_typeid
600: and business_group_id = p_business_group_id
601: and name = c_ipv_name
602: and c_effective_date between effective_start_date