DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_EMPLOYEES_X

Line 240: FROM per_employees_x emp

236: SELECT expense_check_address_flag, vendor_id
237: INTO l_expense_check_address_flag, l_vendor_id
238: FROM (
239: SELECT emp.expense_check_address_flag, null vendor_id
240: FROM per_employees_x emp
241: WHERE emp.employee_id = p_employee_id
242: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
243: UNION ALL
244: SELECT emp.expense_check_address_flag, vendor_id

Line 699: FROM per_employees_x emp

695: SELECT set_of_books_id, default_code_combination_id
696: INTO l_emp_set_of_books_id, l_default_emp_ccid
697: FROM (
698: SELECT emp.set_of_books_id, emp.default_code_combination_id
699: FROM per_employees_x emp
700: WHERE emp.employee_id = l_employee_id
701: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
702: UNION ALL
703: SELECT emp.set_of_books_id, emp.default_code_combination_id