APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_EMPLOYEES

Line 2051: --Removed the columns in psb_employees table

2047: l_title Char_tbl_type;
2048:
2049: /*For Bug No : 2594575 Start*/
2050: --Stop extracting secured data of employee
2051: --Removed the columns in psb_employees table
2052: /*For Bug No : 2594575 End*/
2053:
2054: CURSOR C_Emp_All IS
2055: SELECT EMPLOYEE_NUMBER ,

Line 2063: FROM PSB_EMPLOYEES emp

2059: KNOWN_AS ,
2060: LAST_NAME ,
2061: MIDDLE_NAMES ,
2062: TITLE
2063: FROM PSB_EMPLOYEES emp
2064: WHERE emp.data_extract_id = p_source_data_extract_id
2065: AND emp.business_group_id = p_source_business_group_id
2066: AND NOT EXISTS (
2067: SELECT 1

Line 2068: FROM PSB_EMPLOYEES

2064: WHERE emp.data_extract_id = p_source_data_extract_id
2065: AND emp.business_group_id = p_source_business_group_id
2066: AND NOT EXISTS (
2067: SELECT 1
2068: FROM PSB_EMPLOYEES
2069: WHERE hr_employee_id = emp.hr_employee_id
2070: AND data_extract_id = p_target_data_extract_id
2071: );
2072:

Line 2084: insert into PSB_EMPLOYEES

2080: l_known_as,l_last_name,l_middle_names,l_title
2081: LIMIT g_limit_bulk_numrows;
2082:
2083: FORALL i IN 1..l_emp_num.count
2084: insert into PSB_EMPLOYEES
2085: (employee_id,
2086: data_extract_id,
2087: business_group_id,
2088: employee_number,

Line 2101: values (PSB_EMPLOYEES_S.NEXTVAL,

2097: created_by,
2098: last_update_date,
2099: last_updated_by,
2100: last_update_login)
2101: values (PSB_EMPLOYEES_S.NEXTVAL,
2102: p_target_data_extract_id,
2103: p_source_business_group_id,
2104: l_emp_num(i),
2105: l_hremp_id(i),

Line 3197: from PSB_EMPLOYEES a,

3193: and c.worksheet_id = p_worksheet_id)));
3194:
3195: cursor c_re_emp (empid NUMBER) is
3196: select a.employee_id
3197: from PSB_EMPLOYEES a,
3198: PSB_EMPLOYEES b
3199: /*For Bug No : 2434152 Start*/
3200: --where a.employee_number = b.employee_number
3201: where a.hr_employee_id = b.hr_employee_id

Line 3198: PSB_EMPLOYEES b

3194:
3195: cursor c_re_emp (empid NUMBER) is
3196: select a.employee_id
3197: from PSB_EMPLOYEES a,
3198: PSB_EMPLOYEES b
3199: /*For Bug No : 2434152 Start*/
3200: --where a.employee_number = b.employee_number
3201: where a.hr_employee_id = b.hr_employee_id
3202: /*For Bug No : 2434152 End*/