DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on PER_WORKFORCE_X

Line 2019: -- replaced the view per_employees_x with per_workforce_x so

2015: -- Modification History
2016: -- Date Name Desc
2017: -- -------- -------- -----------------------------------------------------------
2018: -- 12/12/05 smisra Contingent worker support project
2019: -- replaced the view per_employees_x with per_workforce_x so
2020: -- that emaployee and temp worker could be SR contact
2021: -- -----------------------------------------------------------------------------
2022: PROCEDURE Validate_Employee
2023: ( p_api_name IN VARCHAR2,

Line 2038: FROM per_workforce_x hr

2034: l_api_name_full CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_api_name;
2035:
2036: CURSOR employee IS
2037: SELECT 'x'
2038: FROM per_workforce_x hr
2039: WHERE hr.person_id = p_employee_id
2040: AND NVL(hr.termination_date,SYSDATE) >= SYSDATE;
2041:
2042: BEGIN