DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_DB_HR_INT_PKG

Line 455: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

451: FROM (
452: SELECT emp.expense_check_address_flag
453: FROM per_employees_x emp
454: WHERE emp.employee_id = p_employee_id
455: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
456: UNION ALL
457: SELECT emp.expense_check_address_flag
458: FROM per_cont_workers_current_x emp
459: WHERE emp.person_id = p_employee_id

Line 1555: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

1551: FROM (
1552: SELECT emp.default_code_combination_id
1553: FROM per_employees_x emp
1554: WHERE emp.employee_id = p_employee_id
1555: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
1556: UNION ALL
1557: SELECT emp.default_code_combination_id
1558: FROM per_cont_workers_current_x emp
1559: WHERE emp.person_id = p_employee_id

Line 1594: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'

1590: FROM (
1591: SELECT emp.set_of_books_id
1592: FROM per_employees_x emp
1593: WHERE emp.employee_id = p_employee_id
1594: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
1595: UNION ALL
1596: SELECT emp.set_of_books_id
1597: FROM per_cont_workers_current_x emp
1598: WHERE emp.person_id = p_employee_id