APPS.PQP_EARNINGS_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 467: UPDATE pay_input_values_f

463: -- t_def_val(3) := NULL; -- default value
464: --
465: hr_utility.set_location(l_proc, 170);
466: FOR i in 1..2 LOOP
467: UPDATE pay_input_values_f
468: SET formula_id = t_form_id(i)
469: ,warning_or_error = t_we_flag(i)
470: ,default_value = t_def_val(i)
471: WHERE input_value_id = t_ipv_id(i);

Line 512: FROM pay_input_values_f piv

508: AND business_group_id = g_bg_id;
509: --
510: CURSOR c_get_ipv_id IS -- Gets the input value id
511: SELECT piv.input_value_id
512: FROM pay_input_values_f piv
513: WHERE piv.name = p_object_name
514: AND piv.element_type_id = p_object_id
515: AND piv.business_group_id = g_bg_id;
516: --

Line 578: pay_input_values_f piv

574: AND pbt.balance_type_id = pbf.balance_type_id
575: AND pbf.input_value_id IN
576: (SELECT piv.input_value_id
577: FROM pay_element_types_f pet,
578: pay_input_values_f piv
579: WHERE pet.element_name IN ('Regular Salary', 'Regular Wages')
580: AND p_ele_eff_start_date BETWEEN pet.effective_start_date
581: AND pet.effective_end_date
582: AND pet.business_group_id is NULL