APPS.AP_WEB_UTILITIES_PKG dependencies on AP_WEB_PREFERENCES

Line 2988: FROM AP_WEB_PREFERENCES

2984:
2985: BEGIN
2986:
2987: SELECT DEFAULT_APPROVER_ID, DEFAULT_SOURCE into p_ApproverId, l_DefaultSource
2988: FROM AP_WEB_PREFERENCES
2989: WHERE EMPLOYEE_ID = p_EmpId;
2990:
2991: IF l_DefaultSource = 'PRIORREPORT' THEN
2992:

Line 3080: --If there is no data in the AP_WEB_PREFERENCES

3076:
3077: EXCEPTION
3078: WHEN no_data_found THEN
3079:
3080: --If there is no data in the AP_WEB_PREFERENCES
3081: --then default approver from the HRMS
3082: IF l_DefaultSource IS NULL THEN
3083: IF p_appreq='D' THEN
3084: l_TempBoolean := AP_WEB_DB_HR_INT_PKG.GetSupervisorInfo(p_EmpId,