APPS.AP_WEB_UTILITIES_PKG dependencies on AP_WEB_PREFERENCES

Line 2986: FROM AP_WEB_PREFERENCES

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

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

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