APPS.PSB_WS_POS_PVT dependencies on PSB_WS_LINES

Line 1353: -- Also delete the mappings for those account lines from psb_ws_lines.

1349:
1350:
1351: /* Start bug #4167811 */
1352: -- Delete records from psb_ws_account_lines whose budget group is changed.
1353: -- Also delete the mappings for those account lines from psb_ws_lines.
1354: FOR rec_wal IN (SELECT count(*) record_count
1355: FROM psb_ws_account_lines
1356: WHERE position_line_id = p_position_line_id
1357: AND budget_group_changed = 'Y')

Line 1361: DELETE FROM psb_ws_lines

1357: AND budget_group_changed = 'Y')
1358: LOOP
1359: IF rec_wal.record_count > 0
1360: THEN
1361: DELETE FROM psb_ws_lines
1362: WHERE account_line_id IN (SELECT account_line_id
1363: FROM psb_ws_account_lines
1364: WHERE position_line_id = p_position_line_id
1365: AND budget_group_changed = 'Y');