APPS.PA_ADJUSTMENTS dependencies on PER_ASSIGNMENTS_F

Line 9566: FROM PER_ASSIGNMENTS_F

9562:
9563: /* this cursor gets the CCID of the employee for ehich the ER was entered */
9564: CURSOR C_EMP_CCID_CUR(p_emp_id NUMBER, p_sob_id NUMBER) IS
9565: SELECT DEFAULT_CODE_COMB_ID
9566: FROM PER_ASSIGNMENTS_F
9567: WHERE PERSON_ID = p_emp_id
9568: AND SET_OF_BOOKS_ID = p_sob_id
9569: AND TRUNC(SYSDATE) BETWEEN TRUNC(EFFECTIVE_START_DATE)
9570: AND NVL(TRUNC(EFFECTIVE_END_DATE), TRUNC(SYSDATE));