[Home] [Help]
238: FROM (
239: SELECT emp.expense_check_address_flag, null vendor_id
240: FROM per_employees_x emp
241: WHERE emp.employee_id = p_employee_id
242: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
243: UNION ALL
244: SELECT emp.expense_check_address_flag, vendor_id
245: FROM per_cont_workers_current_x emp
246: WHERE emp.person_id = p_employee_id
650: l_valid VARCHAR2(1) := 'N';
651:
652: l_employee_id number;
653: l_chart_of_accounts_id AP_WEB_DB_AP_INT_PKG.glsob_chartOfAccountsID;
654: l_default_emp_ccid AP_WEB_DB_HR_INT_PKG.empCurrent_defaultCodeCombID;
655:
656: /*Bug 2690715 : variable declarations */
657:
658:
682: */
683:
684: BEGIN
685:
686: l_employee_id := nvl(p_employee_id, AP_WEB_DB_HR_INT_PKG.getemployeeid);
687:
688: /* Bug 3916349/4042775 - comment
689: for i in c1(l_employee_id) loop
690: l_chart_of_accounts_id := i.chart_of_accounts_id;
697: FROM (
698: SELECT emp.set_of_books_id, emp.default_code_combination_id
699: FROM per_employees_x emp
700: WHERE emp.employee_id = l_employee_id
701: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
702: UNION ALL
703: SELECT emp.set_of_books_id, emp.default_code_combination_id
704: FROM per_cont_workers_current_x emp
705: WHERE emp.person_id = l_employee_id
1461: INTO l_default_exchange_rates, l_exchange_rate_allowance
1462: FROM ap_pol_exrate_options WHERE enabled = 'Y';
1463:
1464: IF l_default_exchange_rates = 'U' THEN
1465: l_employee_id := AP_WEB_DB_HR_INT_PKG.getEmployeeID;
1466:
1467: SELECT default_exchange_rate_flag INTO l_default_exchange_rate_flag
1468: FROM ap_web_preferences WHERE employee_id = l_employee_id;
1469: