APPS.PA_ADJUSTMENTS dependencies on PER_ASSIGNMENTS_F

Line 9849: FROM PER_ASSIGNMENTS_F

9845:
9846: /* this cursor gets the CCID of the employee for ehich the ER was entered */
9847: CURSOR C_EMP_CCID_CUR(p_emp_id NUMBER, p_sob_id NUMBER) IS
9848: SELECT DEFAULT_CODE_COMB_ID
9849: FROM PER_ASSIGNMENTS_F
9850: WHERE PERSON_ID = p_emp_id
9851: AND SET_OF_BOOKS_ID = p_sob_id
9852: AND TRUNC(SYSDATE) BETWEEN TRUNC(EFFECTIVE_START_DATE)
9853: AND NVL(TRUNC(EFFECTIVE_END_DATE), TRUNC(SYSDATE));