APPS.AP_WEB_DB_EXPRPT_PKG dependencies on PER_EMPLOYEES_X

Line 420: l_exp_check_address_flag per_employees_x.expense_check_address_flag%type;

416: to avoid Merge join cartesians.
417: */
418: l_emp_set_of_books_id gl_sets_of_books.set_of_books_id%type;
419: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
420: l_exp_check_address_flag per_employees_x.expense_check_address_flag%type;
421: l_fin_exp_check_address_flag financials_system_parameters.expense_check_address_flag%type;
422: BEGIN
423: -- 3176205: This query includes all workers except for terminated
424: -- contingent workers and terminated employees who are active contingent

Line 451: FROM per_employees_x emp

447: SELECT expense_check_address_flag
448: INTO l_exp_check_address_flag
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

Line 1539: FROM per_employees_x emp

1535: SELECT default_code_combination_id
1536: INTO p_default_emp_ccid
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

Line 1578: FROM per_employees_x emp

1574: SELECT set_of_books_id
1575: INTO l_emp_set_of_books_id
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