DBA Data[Home] [Help]

APPS.AP_WEB_DB_HR_INT_PKG dependencies on HR_EMPLOYEES_CURRENT_V

Line 6: SUBTYPE empCurrent_employeeID IS HR_EMPLOYEES_CURRENT_V.employee_id%TYPE;

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;

Line 7: SUBTYPE empCurrent_fullName IS HR_EMPLOYEES_CURRENT_V.full_name%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

Line 8: SUBTYPE empCurrent_empNum IS HR_EMPLOYEES_CURRENT_V.employee_num%TYPE;

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;

Line 9: SUBTYPE empCurrent_checkAddrFlag IS HR_EMPLOYEES_CURRENT_V.expense_check_address_flag%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: ---------------------------------------------------------------------------------------------------

Line 10: SUBTYPE empCurrent_defaultCodeCombID IS HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE;

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:

Line 12: HR_EMPLOYEES_CURRENT_V.ORGANIZATION_ID%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:
15: /*PER Employees */
16: ---------------------------------------------------------------------------------------------------