APPS.HRI_EDW_FCT_WRK_ACTVTY dependencies on HR_LOOKUPS

Line 20: FROM hr_lookups

16: l_reason_code VARCHAR2(30); -- Reason code
17:
18: CURSOR reason_cur IS
19: SELECT lookup_code
20: FROM hr_lookups
21: WHERE lookup_code = p_change_reason
22: AND lookup_type = 'EMP_ASSIGN_REASON';
23:
24: BEGIN