DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on PER_PEOPLE_F

Line 4073: PER_PEOPLE_F

4069:
4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4076: AND SYSDATE >= EFFECTIVE_START_DATE
4077: AND SYSDATE <= EFFECTIVE_END_DATE;

Line 4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID

4070: CURSOR OWNER_NAME_CSR (p_owner_name VARCHAR2) IS
4071: SELECT FND_USER.USER_ID
4072: FROM FND_USER,
4073: PER_PEOPLE_F
4074: WHERE FND_USER.EMPLOYEE_ID = PER_PEOPLE_F.PERSON_ID
4075: AND UPPER(FND_USER.USER_NAME) = UPPER(p_owner_name)
4076: AND SYSDATE >= EFFECTIVE_START_DATE
4077: AND SYSDATE <= EFFECTIVE_END_DATE;
4078: