APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_EMPLOYEES

Line 1329: from PSB_EMPLOYEES

1325: l_return_status VARCHAR2(1);
1326:
1327: cursor c_emp is
1328: select *
1329: from PSB_EMPLOYEES
1330: where business_group_id = p_local_business_group_id
1331: and data_extract_id = p_local_data_extract_id;
1332:
1333: cursor c_emp_exists (empno NUMBER) is

Line 1335: from psb_employees

1331: and data_extract_id = p_local_data_extract_id;
1332:
1333: cursor c_emp_exists (empno NUMBER) is
1334: select employee_id
1335: from psb_employees
1336: where employee_number = empno
1337: and data_extract_id = g_global_data_extract_id;
1338:
1339: cursor c_emp_seq is

Line 1340: select PSB_EMPLOYEES_S.NEXTVAL seq

1336: where employee_number = empno
1337: and data_extract_id = g_global_data_extract_id;
1338:
1339: cursor c_emp_seq is
1340: select PSB_EMPLOYEES_S.NEXTVAL seq
1341: from dual;
1342:
1343: BEGIN
1344:

Line 1366: --Removed the columns in psb_employees table

1362: end loop;
1363:
1364: /*For Bug No : 2594575 Start*/
1365: --Stop extracting secured data of employee
1366: --Removed the columns in psb_employees table
1367: /*For Bug No : 2594575 End*/
1368:
1369: insert into PSB_EMPLOYEES
1370: (employee_id, data_extract_id, business_group_id,

Line 1369: insert into PSB_EMPLOYEES

1365: --Stop extracting secured data of employee
1366: --Removed the columns in psb_employees table
1367: /*For Bug No : 2594575 End*/
1368:
1369: insert into PSB_EMPLOYEES
1370: (employee_id, data_extract_id, business_group_id,
1371: employee_number, hr_employee_id, first_name,
1372: full_name, known_as, last_name,
1373: middle_names, title,

Line 1508: from PSB_EMPLOYEES a,

1504: and position_id = positionid;
1505:
1506: cursor c_re_emp (empid NUMBER) is
1507: select a.employee_id
1508: from PSB_EMPLOYEES a,
1509: PSB_EMPLOYEES b
1510: where a.employee_number = b.employee_number
1511: and a.data_extract_id = g_global_data_extract_id
1512: and b.employee_id = empid;

Line 1509: PSB_EMPLOYEES b

1505:
1506: cursor c_re_emp (empid NUMBER) is
1507: select a.employee_id
1508: from PSB_EMPLOYEES a,
1509: PSB_EMPLOYEES b
1510: where a.employee_number = b.employee_number
1511: and a.data_extract_id = g_global_data_extract_id
1512: and b.employee_id = empid;
1513: