APPS.PSB_WS_PERIOD_TOTAL dependencies on PSB_WORKSHEETS

Line 228: ' from PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w ' ||

224: /* Bug No 2543015 Start */
225: ' AND ( :b_spkg_flag = ''A'' ' ||
226: ' OR (:b_spkg_selection_exists = ''N'' ' ||
227: ' AND service_package_id in ( select sp.service_package_id ' ||
228: ' from PSB_SERVICE_PACKAGES sp, PSB_WORKSHEETS w ' ||
229: ' where sp.global_worksheet_id = nvl(w.global_worksheet_id, w.worksheet_id) ' ||
230: ' and w.worksheet_id = :b_profile_worksheet_id ' ||
231: ' and sp.name like :b_spkg_name) ' ||
232: ' ) ' ||

Line 343: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE;

339: )
340: IS
341:
342: l_global_worksheet_flag varchar2(1):= NULL;
343: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE;
344: l_local_copy_flag varchar2(1):= NULL;
345: l_parent_worksheet_id psb_worksheets.copy_of_worksheet_id%TYPE;
346: l_dummy varchar2(1) := '0';
347: /* for bug no 3564160 */

Line 345: l_parent_worksheet_id psb_worksheets.copy_of_worksheet_id%TYPE;

341:
342: l_global_worksheet_flag varchar2(1):= NULL;
343: l_global_worksheet_id psb_worksheets.global_worksheet_id%TYPE;
344: l_local_copy_flag varchar2(1):= NULL;
345: l_parent_worksheet_id psb_worksheets.copy_of_worksheet_id%TYPE;
346: l_dummy varchar2(1) := '0';
347: /* for bug no 3564160 */
348: l_profile_flag VARCHAR2(1) := '0';
349: l_inherit_profile varchar2(3) := NULL;

Line 368: FROM psb_worksheets

364: SELECT global_worksheet_flag,
365: global_worksheet_id,
366: local_copy_flag,
367: copy_of_worksheet_id
368: FROM psb_worksheets
369: WHERE worksheet_id = p_current_worksheet_id;
370:
371: BEGIN
372: l_inherit_profile := FND_PROFILE.VALUE('PSB_INHERIT_DATA_SELECTION_PROFILE');