DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_UTIL dependencies on PER_WORKFORCE_X

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

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

Line 2036: FROM per_workforce_x hr

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