DBA Data[Home] [Help]

APPS.PSB_WS_YEAR_TOTAL dependencies on GL_CODE_COMBINATIONS

Line 177: (select 1 from gl_code_combinations

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 */
176: AND EXISTS
177: (select 1 from gl_code_combinations
178: where code_combination_id = WYA.code_combination_id
179: and chart_of_accounts_id = p_chart_of_accounts
180: and ( (segment1 is null) or (g_segment_low(1) is null and g_segment_high(1) is null) or (g_segment_low(1) is null and segment1 <= g_segment_high(1)) or (g_segment_high(1) is null and segment1 >= g_segment_low(1)) or
181: (g_segment_low(1) = 'LK' and segment1 like g_segment_high(1)) or (g_segment_low(1) is not null and g_segment_high(1) is not null and g_segment_low(1) <> 'LK' and segment1 between g_segment_low(1) and g_segment_high(1)) )

Line 460: (select 1 from gl_code_combinations

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 */
459: AND EXISTS
460: (select 1 from gl_code_combinations
461: where code_combination_id = WYA.code_combination_id
462: and chart_of_accounts_id = pchart_of_accounts_id
463: and ( (segment1 is null) or (g_segment_low(1) is null and g_segment_high(1) is null) or (g_segment_low(1) is null and segment1 <= g_segment_high(1)) or (g_segment_high(1) is null and segment1 >= g_segment_low(1)) or
464: (g_segment_low(1) = 'LK' and segment1 like g_segment_high(1)) or (g_segment_low(1) is not null and g_segment_high(1) is not null and g_segment_low(1) <> 'LK' and segment1 between g_segment_low(1) and g_segment_high(1)) )