DBA Data[Home] [Help]

APPS.PSB_WORKSHEET dependencies on PSB_POSITION_ASSIGNMENTS

Line 325: from PSB_POSITION_ASSIGNMENTS

321:
322: cursor c_assign is
323: select count(*) count_assign,
324: Max(last_update_date) lud_assign
325: from PSB_POSITION_ASSIGNMENTS
326: where data_extract_id = p_data_extract_id;
327:
328: cursor c_rates is
329: select count(*) count_rates,

Line 2657: delete from PSB_POSITION_ASSIGNMENTS

2653:
2654: if FND_API.to_Boolean(p_global_worksheet) then
2655: begin
2656:
2657: delete from PSB_POSITION_ASSIGNMENTS
2658: where worksheet_id = p_worksheet_id;
2659:
2660: delete from PSB_PAY_ELEMENT_RATES
2661: where worksheet_id = p_worksheet_id;

Line 3355: delete from PSB_POSITION_ASSIGNMENTS

3351:
3352: delete from PSB_WS_LINES_POSITIONS
3353: where position_line_id = p_position_line_id;
3354:
3355: delete from PSB_POSITION_ASSIGNMENTS
3356: where position_id =
3357: (select position_id
3358: from PSB_WS_POSITION_LINES
3359: where position_line_id = p_position_line_id)