APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 226: FROM pay_input_values_f

222: CURSOR c_ip_val
223: ( c_element_type_id IN NUMBER
224: ,c_name IN VARCHAR2) IS
225: SELECT input_value_id
226: FROM pay_input_values_f
227: WHERE element_type_id = c_element_type_id
228: AND trunc(p_scheme_start_date) BETWEEN
229: effective_start_date AND effective_end_date
230: AND name = c_name;

Line 372: from pay_input_values_f piv

368: ,c_iv_name varchar2) is
369: select input_value_id
370: ,piv.name
371: ,piv.element_type_id
372: from pay_input_values_f piv
373: ,pay_element_types_f pet
374: where element_name = c_ele_name
375: and piv.element_type_id = pet.element_type_id
376: and (piv.business_group_id = p_business_group_id or

Line 385: from pay_input_values_f

381:
382: cursor csr_updinput(c_ip_id number
383: ,c_element_type_id number) is
384: select rowid
385: from pay_input_values_f
386: where input_value_id = c_ip_id
387: and element_type_id = c_element_type_id
388: for update nowait;
389:

Line 415: update pay_input_values_f

411: exit when csr_updinput%notfound;
412: --
413: hr_utility.set_location (l_proc_name, 30);
414: --
415: update pay_input_values_f
416: set default_value = p_def_value
417: where rowid = csr_updinput_rec.rowid;
418: end loop;
419: close csr_updinput;

Line 578: from pay_input_values_f

574: --
575: cursor csr_ipv (c_ele_typeid number
576: ,c_effective_date date) is
577: select input_value_id
578: from pay_input_values_f
579: where element_type_id = c_ele_typeid
580: and business_group_id = p_business_group_id
581: and name = 'Pay Value'
582: and c_effective_date between effective_start_date

Line 589: from pay_input_values_f

585: cursor csr_ipv1 (c_ele_typeid number
586: ,c_ipv_name varchar2
587: ,c_effective_date date) is
588: select input_value_id
589: from pay_input_values_f
590: where element_type_id = c_ele_typeid
591: and business_group_id = p_business_group_id
592: and name = c_ipv_name
593: and c_effective_date between effective_start_date