2: /* $Header: apwdbhrs.pls 120.21.12010000.2 2008/08/06 07:49:08 rveliche ship $ */
3:
4: /*HR Employees */
5: ---------------------------------------------------------------------------------------------------
6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
3:
4: /*HR Employees */
5: ---------------------------------------------------------------------------------------------------
6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11: SUBTYPE empCurrent_orgID IS
4: /*HR Employees */
5: ---------------------------------------------------------------------------------------------------
6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11: SUBTYPE empCurrent_orgID IS
12: HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
5: ---------------------------------------------------------------------------------------------------
6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11: SUBTYPE empCurrent_orgID IS
12: HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
13: ---------------------------------------------------------------------------------------------------
6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;
7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%TYPE;
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11: SUBTYPE empCurrent_orgID IS
12: HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
13: ---------------------------------------------------------------------------------------------------
14:
8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;
9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%TYPE;
10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;
11: SUBTYPE empCurrent_orgID IS
12: HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%TYPE;
13: ---------------------------------------------------------------------------------------------------
14:
15: /*PER Employees */
16: ---------------------------------------------------------------------------------------------------