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 13252: FROM ap_web_employee_info_all

13248: BEGIN
13249:
13250: SELECT count(*)
13251: INTO l_count
13252: FROM ap_web_employee_info_all
13253: WHERE value_type = 'CUM_REIMB_DISTANCE'
13254: AND period_id = p_period_id
13255: AND employee_id = p_employee_id;
13256:

Line 13258: UPDATE ap_web_employee_info_all

13254: AND period_id = p_period_id
13255: AND employee_id = p_employee_id;
13256:
13257: IF (l_count > 0 ) THEN
13258: UPDATE ap_web_employee_info_all
13259: SET numeric_value = p_cumulative_mileage,
13260: last_update_date = sysdate,
13261: last_updated_by = p_employee_id
13262: WHERE value_type = 'CUM_REIMB_DISTANCE'

Line 13266: INSERT INTO ap_web_employee_info_all

13262: WHERE value_type = 'CUM_REIMB_DISTANCE'
13263: AND period_id = p_period_id
13264: AND employee_id = p_employee_id;
13265: ELSE
13266: INSERT INTO ap_web_employee_info_all
13267: (EMPLOYEE_ID,
13268: VALUE_TYPE,
13269: NUMERIC_VALUE,
13270: PERIOD_ID,