APPS.PSB_WORKSHEET dependencies on PSB_WS_ACCOUNT_LINES

Line 2690: delete from PSB_WS_ACCOUNT_LINES

2686:
2687: if FND_API.to_Boolean(p_global_worksheet) then
2688: begin
2689:
2690: delete from PSB_WS_ACCOUNT_LINES
2691: where account_line_id in
2692: (select account_line_id
2693: from PSB_WS_LINES
2694: where worksheet_id = p_worksheet_id);

Line 3268: delete from PSB_WS_ACCOUNT_LINES

3264: then
3265: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3266: end if;
3267:
3268: delete from PSB_WS_ACCOUNT_LINES
3269: where account_line_id = p_account_line_id;
3270:
3271: --delete from PSB_WS_LINES a
3272: -- where exists

Line 3274: -- from PSB_WS_ACCOUNT_LINES b

3270:
3271: --delete from PSB_WS_LINES a
3272: -- where exists
3273: -- (select 1
3274: -- from PSB_WS_ACCOUNT_LINES b
3275: -- where b.copy_of_account_line_id = p_account_line_id
3276: -- and b.account_line_id = a.account_line_id);
3277:
3278: --delete from PSB_WS_ACCOUNT_LINES

Line 3278: --delete from PSB_WS_ACCOUNT_LINES

3274: -- from PSB_WS_ACCOUNT_LINES b
3275: -- where b.copy_of_account_line_id = p_account_line_id
3276: -- and b.account_line_id = a.account_line_id);
3277:
3278: --delete from PSB_WS_ACCOUNT_LINES
3279: -- where copy_of_account_line_id = p_account_line_id;
3280:
3281: delete from PSB_WS_LINES
3282: where account_line_id = p_account_line_id;

Line 3345: from PSB_WS_ACCOUNT_LINES

3341:
3342: delete from PSB_WS_LINES
3343: where account_line_id in
3344: (select account_line_id
3345: from PSB_WS_ACCOUNT_LINES
3346: where element_set_id is not null
3347: and position_line_id = p_position_line_id);
3348:
3349: delete from PSB_WS_ACCOUNT_LINES

Line 3349: delete from PSB_WS_ACCOUNT_LINES

3345: from PSB_WS_ACCOUNT_LINES
3346: where element_set_id is not null
3347: and position_line_id = p_position_line_id);
3348:
3349: delete from PSB_WS_ACCOUNT_LINES
3350: where position_line_id = p_position_line_id;
3351:
3352: delete from PSB_WS_LINES_POSITIONS
3353: where position_line_id = p_position_line_id;

Line 3526: delete from PSB_WS_ACCOUNT_LINES

3522: then
3523: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3524: end if;
3525:
3526: delete from PSB_WS_ACCOUNT_LINES
3527: where template_id is not null
3528: and account_line_id in
3529: (select account_line_id
3530: from PSB_WS_LINES

Line 3537: from PSB_WS_ACCOUNT_LINES b

3533: delete from PSB_WS_LINES a
3534: where a.worksheet_id = p_worksheet_id
3535: and not exists
3536: (select 1
3537: from PSB_WS_ACCOUNT_LINES b
3538: where b.account_line_id = a.account_line_id);
3539:
3540:
3541: -- Initialize API return status to success