APPS.PSB_WS_YEAR_TOTAL dependencies on PSB_WS_SERVICE_PKG_PROFILES_V

Line 132: FROM PSB_WS_SERVICE_PKG_PROFILES_V

128: AND sp.name like p_spkg_name))
129: OR (p_spkg_selection_exists = 'Y'
130: AND service_package_id IN
131: (SELECT service_package_id
132: FROM PSB_WS_SERVICE_PKG_PROFILES_V
133: WHERE worksheet_id = p_profile_worksheet_id
134: AND ((user_id = p_user_id) or (p_user_id is null and user_id is null))
135: AND service_package_name like decode(p_spkg_name, '%', service_package_name, p_spkg_name))))
136: /* Bug No 2543015 End */

Line 171: FROM PSB_WS_SERVICE_PKG_PROFILES_V

167: AND sp.name like p_spkg_name))
168: OR (p_spkg_selection_exists = 'Y'
169: AND service_package_id IN
170: (SELECT service_package_id
171: FROM PSB_WS_SERVICE_PKG_PROFILES_V
172: WHERE worksheet_id = p_profile_worksheet_id
173: AND ((user_id = p_user_id) or (p_user_id is null and user_id is null))
174: AND service_package_name like decode(p_spkg_name, '%', service_package_name, p_spkg_name))))
175: /* Bug No 2543015 End */

Line 426: FROM PSB_WS_SERVICE_PKG_PROFILES_V

422: AND sp.name like pspkg_name))
423: OR (pselection_exists = 'Y'
424: AND service_package_id IN
425: (SELECT service_package_id
426: FROM PSB_WS_SERVICE_PKG_PROFILES_V
427: WHERE worksheet_id = pprofile_worksheet_id
428: AND ((user_id = puser_id) or (puser_id is null and user_id is null))
429: AND service_package_name like decode(pspkg_name, '%', service_package_name, pspkg_name))));
430: /* Bug No 2543015 End */

Line 454: FROM PSB_WS_SERVICE_PKG_PROFILES_V

450: AND sp.name like pspkg_name))
451: OR (pselection_exists = 'Y'
452: AND service_package_id IN
453: (SELECT service_package_id
454: FROM PSB_WS_SERVICE_PKG_PROFILES_V
455: WHERE worksheet_id = pprofile_worksheet_id
456: AND ((user_id = puser_id) or (puser_id is null and user_id is null))
457: AND service_package_name like decode(pspkg_name, '%', service_package_name, pspkg_name))))
458: /* Bug No 2543015 End */