APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_WS_ACCOUNT_LINES

Line 1178: FROM psb_ws_account_lines accts

1174: -- is fine as it will always return either 0 or 1.
1175: UPDATE psb_ws_lines lines
1176: SET lines.view_line_flag =
1177: ( SELECT DECODE( COUNT(*), 0, 'N', 'Y' )
1178: FROM psb_ws_account_lines accts
1179: WHERE accts.account_line_id = lines.account_line_id
1180: AND ( l_service_package_count = 0
1181: OR
1182: accts.service_package_id IN

Line 1207: FROM psb_ws_account_lines accts

1203: WHERE lines.worksheet_id = l_worksheets_tab(i)
1204: AND EXISTS
1205: (
1206: SELECT accts.account_line_id
1207: FROM psb_ws_account_lines accts
1208: WHERE accts.account_line_id = lines.account_line_id
1209: AND accts.service_package_id NOT IN
1210: (
1211: SELECT service_package_id

Line 1246: FROM psb_ws_account_lines accts

1242: -- Bug#3124025: Commenting the potential new query and using prior query.
1243: UPDATE psb_ws_lines_positions lines
1244: SET lines.view_line_flag =
1245: ( DECODE ( ( SELECT COUNT(*)
1246: FROM psb_ws_account_lines accts
1247: WHERE accts.position_line_id = lines.position_line_id
1248: AND ( l_service_package_count = 0
1249: OR
1250: accts.service_package_id IN

Line 1278: psb_ws_account_lines accts

1274: AND lines.position_line_id IN
1275: (
1276: SELECT accts.position_line_id
1277: FROM psb_ws_lines lines ,
1278: psb_ws_account_lines accts
1279: WHERE lines.worksheet_id = l_worksheets_tab(i)
1280: AND lines.account_line_id = accts.account_line_id
1281: AND accts.service_package_id NOT IN
1282: (

Line 2867: psb_ws_account_lines accts

2863: AND EXISTS
2864: (
2865: SELECT 1
2866: FROM psb_ws_lines lines ,
2867: psb_ws_account_lines accts
2868: WHERE lines.worksheet_id = p_worksheet_id
2869: AND lines.account_line_id = accts.account_line_id
2870: AND accts.code_combination_id = ba.code_combination_id
2871: AND ROWNUM < 2