APPS.PAY_IN_FORM_24Q_WEB_ADI dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 88: FROM pay_element_entry_values_f val

84: IS
85: CURSOR c_entry_value
86: IS
87: SELECT val.screen_entry_value
88: FROM pay_element_entry_values_f val
89: ,pay_input_values_f inputs
90: WHERE val.input_value_id = inputs.input_value_id
91: AND val.element_entry_id = p_element_entry_id
92: AND inputs.name = p_input_name

Line 97: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;

93: AND inputs.legislation_code = 'IN'
94: AND p_effective_date between val.effective_start_date AND val.effective_end_date
95: AND p_effective_date between inputs.effective_start_date AND inputs.effective_end_date;
96: --
97: l_screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE := NULL;
98: l_procedure VARCHAR2(250);
99: l_message VARCHAR2(250);
100: BEGIN
101: g_debug := hr_utility.debug_enabled;

Line 1150: UPDATE pay_element_entry_values_f

1146: ,p_object_version_number => l_object_version_number
1147: ,p_create_warning => l_warnings
1148: );
1149:
1150: UPDATE pay_element_entry_values_f
1151: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)
1152: WHERE input_value_id = l_input_values_rec(9).input_value_id
1153: AND element_entry_id = l_element_entry_id;
1154:

Line 1186: UPDATE pay_element_entry_values_f

1182: ,p_effective_end_date => l_effective_end_date
1183: ,p_update_warning => l_warnings
1184: );
1185:
1186: UPDATE pay_element_entry_values_f
1187: SET screen_entry_value = fnd_date.date_to_canonical(sysdate)
1188: WHERE input_value_id = l_input_values_rec(9).input_value_id
1189: AND element_entry_id = p_element_entry_id;
1190: