APPS.PSB_WS_YEAR_TOTAL dependencies on PSB_WORKSHEETS

Line 125: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w

121: AND (p_spkg_flag = 'A'
122: OR (p_spkg_selection_exists = 'N'
123: AND service_package_id IN
124: (SELECT sp.service_package_id
125: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w
126: WHERE sp.global_worksheet_id = nvl(w.global_worksheet_id, w.worksheet_id)
127: AND w.worksheet_id = p_worksheet_id
128: AND sp.name like p_spkg_name))
129: OR (p_spkg_selection_exists = 'Y'

Line 164: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w

160: AND (p_spkg_flag = 'A'
161: OR (p_spkg_selection_exists = 'N'
162: AND service_package_id IN
163: (SELECT sp.service_package_id
164: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w
165: WHERE sp.global_worksheet_id = nvl(w.global_worksheet_id, w.worksheet_id)
166: AND w.worksheet_id = p_worksheet_id
167: AND sp.name like p_spkg_name))
168: OR (p_spkg_selection_exists = 'Y'

Line 419: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w

415: AND (pservice_package_flag = 'A'
416: OR (pselection_exists = 'N'
417: AND service_package_id IN
418: (SELECT sp.service_package_id
419: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w
420: WHERE sp.global_worksheet_id = nvl(w.global_worksheet_id, w.worksheet_id)
421: AND w.worksheet_id = pworksheet_id
422: AND sp.name like pspkg_name))
423: OR (pselection_exists = 'Y'

Line 447: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w

443: AND (pservice_package_flag = 'A'
444: OR (pselection_exists = 'N'
445: AND service_package_id IN
446: (SELECT sp.service_package_id
447: FROM PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w
448: WHERE sp.global_worksheet_id = nvl(w.global_worksheet_id, w.worksheet_id)
449: AND w.worksheet_id = pworksheet_id
450: AND sp.name like pspkg_name))
451: OR (pselection_exists = 'Y'