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: l_default_exch_rate_type apSetUp_defaultExchRateType;
423: BEGIN
424: -- 3176205: This query includes all workers except for terminated

Line 453: FROM per_employees_x emp

449: SELECT expense_check_address_flag
450: INTO l_exp_check_address_flag
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

Line 1553: FROM per_employees_x emp

1549: SELECT default_code_combination_id
1550: INTO p_default_emp_ccid
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

Line 1592: FROM per_employees_x emp

1588: SELECT set_of_books_id
1589: INTO l_emp_set_of_books_id
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