APPS.PSB_SUBMIT_WORKSHEET_PVT dependencies on PSB_WS_LINES_POSITIONS

Line 1226: -- selected. This means psb_ws_lines_positions.view_line_flag has got

1222:
1223: --
1224: -- Bug#3124025: The positions are always associated with BASE service
1225: -- package. Now when a worksheet is submitted, the BASE is always
1226: -- selected. This means psb_ws_lines_positions.view_line_flag has got
1227: -- to be always "Y". Using this defensive (fixing) query. We may comment
1228: -- out this query later on.
1229: --
1230: UPDATE psb_ws_lines_positions lines

Line 1230: UPDATE psb_ws_lines_positions lines

1226: -- selected. This means psb_ws_lines_positions.view_line_flag has got
1227: -- to be always "Y". Using this defensive (fixing) query. We may comment
1228: -- out this query later on.
1229: --
1230: UPDATE psb_ws_lines_positions lines
1231: SET lines.view_line_flag = 'Y'
1232: WHERE lines.worksheet_id = l_worksheets_tab(i)
1233: AND ( lines.view_line_flag IS NULL OR lines.view_line_flag = 'N' )
1234: AND EXISTS

Line 1236: FROM psb_ws_lines_positions pwl

1232: WHERE lines.worksheet_id = l_worksheets_tab(i)
1233: AND ( lines.view_line_flag IS NULL OR lines.view_line_flag = 'N' )
1234: AND EXISTS
1235: ( SELECT 1
1236: FROM psb_ws_lines_positions pwl
1237: WHERE pwl.position_line_id = lines.position_line_id
1238: AND pwl.worksheet_id = l_worksheet_id
1239: ) ;
1240:

Line 1243: UPDATE psb_ws_lines_positions lines

1239: ) ;
1240:
1241: /*
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

Line 1265: FROM psb_ws_lines_positions pwl

1261: )
1262: WHERE lines.worksheet_id = l_worksheets_tab(i)
1263: AND EXISTS
1264: ( SELECT 1
1265: FROM psb_ws_lines_positions pwl
1266: WHERE pwl.position_line_id = lines.position_line_id
1267: AND pwl.worksheet_id = l_worksheet_id
1268: ) ;
1269:

Line 1271: UPDATE psb_ws_lines_positions lines

1267: AND pwl.worksheet_id = l_worksheet_id
1268: ) ;
1269:
1270: -- Bug#3124025: Commenting the original query and now using prior query.
1271: UPDATE psb_ws_lines_positions lines
1272: SET view_line_flag = 'N'
1273: WHERE lines.worksheet_id = l_worksheets_tab(i)
1274: AND lines.position_line_id IN
1275: (

Line 2915: FROM psb_ws_lines_positions lines ,

2911: AND relations.account_position_set_id = bp.account_position_set_id
2912: AND EXISTS
2913: (
2914: SELECT 1
2915: FROM psb_ws_lines_positions lines ,
2916: psb_ws_position_lines pos
2917: WHERE lines.worksheet_id = p_worksheet_id
2918: AND lines.position_line_id = pos.position_line_id
2919: AND pos.position_id = bp.position_id

Line 2953: PSB_WS_LINES_POSITIONS lines,

2949: OR( bgrp.effective_end_date >= PSB_WS_Acct1.g_enddate_cy ))
2950: AND EXISTS
2951: (SELECT 1
2952: FROM PSB_POSITIONS ppos,
2953: PSB_WS_LINES_POSITIONS lines,
2954: PSB_WS_POSITION_LINES wspos
2955: WHERE ppos.position_id = wspos.position_id
2956: AND ppos.new_position_flag = 'Y'
2957: AND lines.worksheet_id = p_worksheet_id