DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on PER_CONT_WORKERS_CURRENT_X

Line 245: FROM per_cont_workers_current_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
245: FROM per_cont_workers_current_x emp
246: WHERE emp.person_id = p_employee_id
247: );
248:
249: IF l_expense_check_address_flag IS NULL THEN -- Bug 6978871(sodash) if not set at emp then get from financial option

Line 704: FROM per_cont_workers_current_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
704: FROM per_cont_workers_current_x emp
705: WHERE emp.person_id = l_employee_id
706: );
707:
708: -- Get the chart_of_account_id from system parameters