DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPRPT_PKG dependencies on AP_WEB_DB_HR_INT_PKG

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

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

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

1537: FROM (
1538: SELECT emp.default_code_combination_id
1539: FROM per_employees_x emp
1540: WHERE emp.employee_id = p_employee_id
1541: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
1542: UNION ALL
1543: SELECT emp.default_code_combination_id
1544: FROM per_cont_workers_current_x emp
1545: WHERE emp.person_id = p_employee_id

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

1576: FROM (
1577: SELECT emp.set_of_books_id
1578: FROM per_employees_x emp
1579: WHERE emp.employee_id = p_employee_id
1580: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
1581: UNION ALL
1582: SELECT emp.set_of_books_id
1583: FROM per_cont_workers_current_x emp
1584: WHERE emp.person_id = p_employee_id