APPS.PAY_ACCRUAL_PLANS_PKG dependencies on PAY_INPUT_VALUES_F

Line 755: UPDATE pay_input_values_f

751: -- and UPDATE. Changed to a single UPDATE, because non-US accrual plans
752: -- create all element as non-payment, hence have no PAY INPUT VALUE. The
753: -- SELECT was failing with NO_DATA_FOUND. RMF 27-Nov-1995.
754: --
755: UPDATE pay_input_values_f
756: SET mandatory_flag = 'X'
757: WHERE input_value_id =
758: ( SELECT piv.input_value_id
759: FROM pay_input_values_f piv,

Line 759: FROM pay_input_values_f piv,

755: UPDATE pay_input_values_f
756: SET mandatory_flag = 'X'
757: WHERE input_value_id =
758: ( SELECT piv.input_value_id
759: FROM pay_input_values_f piv,
760: pay_accrual_plans pap,
761: hr_lookups hrl
762: WHERE pap.accrual_plan_id = p_accrual_plan_id
763: AND pap.accrual_plan_element_type_id = piv.element_type_id