eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on AP_WEB_EMPLOYEE_INFO_ALL

Line 12470: FROM ap_web_employee_info_all

12466: BEGIN
12467:
12468: SELECT count(*)
12469: INTO l_count
12470: FROM ap_web_employee_info_all
12471: WHERE value_type = 'CUM_REIMB_DISTANCE'
12472: AND period_id = p_period_id
12473: AND employee_id = p_employee_id;
12474:

Line 12476: UPDATE ap_web_employee_info_all

12472: AND period_id = p_period_id
12473: AND employee_id = p_employee_id;
12474:
12475: IF (l_count > 0 ) THEN
12476: UPDATE ap_web_employee_info_all
12477: SET numeric_value = p_cumulative_mileage,
12478: last_update_date = sysdate,
12479: last_updated_by = p_employee_id
12480: WHERE value_type = 'CUM_REIMB_DISTANCE'

Line 12484: INSERT INTO ap_web_employee_info_all

12480: WHERE value_type = 'CUM_REIMB_DISTANCE'
12481: AND period_id = p_period_id
12482: AND employee_id = p_employee_id;
12483: ELSE
12484: INSERT INTO ap_web_employee_info_all
12485: (EMPLOYEE_ID,
12486: VALUE_TYPE,
12487: NUMERIC_VALUE,
12488: PERIOD_ID,