APPS.PSB_WS_POS_PVT dependencies on PSB_WS_ACCOUNT_LINES

Line 456: FROM PSB_WS_ACCOUNT_LINES

452: WHERE fte_line_id = p_fte_line_id;
453:
454: CURSOR l_annual_fte_csr IS
455: SELECT annual_fte
456: FROM PSB_WS_ACCOUNT_LINES
457: WHERE l_current_stage_seq BETWEEN start_stage_seq AND current_stage_seq
458: AND stage_set_id = l_stage_set_id
459: AND service_package_id = l_service_package_id
460: AND budget_year_id = l_budget_year_id

Line 1352: -- Delete records from psb_ws_account_lines whose budget group is changed.

1348: p_position_end_date => p_position_end_date);
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

Line 1355: FROM psb_ws_account_lines

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')
1358: LOOP
1359: IF rec_wal.record_count > 0

Line 1363: FROM psb_ws_account_lines

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');
1366:
1367: DELETE FROM psb_ws_account_lines

Line 1367: DELETE FROM psb_ws_account_lines

1363: FROM psb_ws_account_lines
1364: WHERE position_line_id = p_position_line_id
1365: AND budget_group_changed = 'Y');
1366:
1367: DELETE FROM psb_ws_account_lines
1368: WHERE position_line_id = p_position_line_id
1369: AND budget_group_changed = 'Y';
1370:
1371: END IF;