APPS.AP_WEB_DB_EXPRPT_PKG dependencies on PER_CONT_WORKERS_CURRENT_X

Line 458: FROM per_cont_workers_current_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
460: );
461:
462: SELECT expense_check_address_flag

Line 1558: FROM per_cont_workers_current_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
1560: );
1561:
1562:

Line 1597: FROM per_cont_workers_current_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
1599: );
1600:
1601: IF (l_emp_set_of_books_id IS NOT NULL) THEN