DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_EMPLOYEES_X

Line 220: FROM per_employees_x emp

216: SELECT expense_check_address_flag, vendor_id
217: INTO l_expense_check_address_flag, l_vendor_id
218: FROM (
219: SELECT emp.expense_check_address_flag, null vendor_id
220: FROM per_employees_x emp
221: WHERE emp.employee_id = p_employee_id
222: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
223: UNION ALL
224: SELECT emp.expense_check_address_flag, vendor_id

Line 676: FROM per_employees_x emp

672: SELECT set_of_books_id, default_code_combination_id
673: INTO l_emp_set_of_books_id, l_default_emp_ccid
674: FROM (
675: SELECT emp.set_of_books_id, emp.default_code_combination_id
676: FROM per_employees_x emp
677: WHERE emp.employee_id = l_employee_id
678: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
679: UNION ALL
680: SELECT emp.set_of_books_id, emp.default_code_combination_id