DBA Data[Home] [Help]

APPS.HRI_OPL_CMNTS_ACTLS dependencies on PAY_INPUT_VALUES_F

Line 157: FROM pay_input_values_f

153: FROM hri_mb_actls_ct actls
154: WHERE actls.assignment_id = cmnts.assignment_id
155: AND actls.element_type_id = cmnts.element_type_id
156: AND actls.input_value_id = NVL(( SELECT input_value_id
157: FROM pay_input_values_f
158: WHERE element_type_id = actls.element_type_id
159: AND name = 'Pay Value'
160: AND actls.effective_date between effective_start_date and effective_end_date)
161: ,cmnts.input_value_id )