25:
26:
27:
28: ----------------------------------------------------------------------
29: FUNCTION GetRestorableReportsCursor(P_WebUserID IN AK_WEB_USER_SEC_ATTR_VALUES.web_user_id%TYPE,
30: p_cursor OUT NOCOPY RestorableReportsCursor)
31: RETURN BOOLEAN IS
32: ----------------------------------------------------------------------
33: BEGIN
52: PER_PEOPLE_X hr_empcur,
53: FND_LOOKUPS fndl
54: WHERE (ap_erh.EMPLOYEE_ID IN
55: (SELECT NUMBER_VALUE
56: FROM AK_WEB_USER_SEC_ATTR_VALUES
57: WHERE ATTRIBUTE_CODE = C_UserAttributeCode AND
58: WEB_USER_ID = P_WebUserID))
59: AND ap_erh.SOURCE = C_RestorableReportSource
60: AND ap_erh.WORKFLOW_APPROVED_FLAG IN