APPS.PSB_WORKSHEET dependencies on PSB_WS_LINES

Line 2666: from PSB_WS_LINES_POSITIONS

2662:
2663: delete from PSB_WS_POSITION_LINES
2664: where position_line_id in
2665: (select position_line_id
2666: from PSB_WS_LINES_POSITIONS
2667: where worksheet_id = p_worksheet_id);
2668:
2669: delete from PSB_WS_FTE_LINES
2670: where position_line_id in

Line 2672: from PSB_WS_LINES_POSITIONS

2668:
2669: delete from PSB_WS_FTE_LINES
2670: where position_line_id in
2671: (select position_line_id
2672: from PSB_WS_LINES_POSITIONS
2673: where worksheet_id = p_worksheet_id);
2674:
2675: delete from PSB_WS_ELEMENT_LINES
2676: where position_line_id in

Line 2678: from PSB_WS_LINES_POSITIONS

2674:
2675: delete from PSB_WS_ELEMENT_LINES
2676: where position_line_id in
2677: (select position_line_id
2678: from PSB_WS_LINES_POSITIONS
2679: where worksheet_id = p_worksheet_id);
2680:
2681: end;
2682: end if;

Line 2684: delete from PSB_WS_LINES_POSITIONS

2680:
2681: end;
2682: end if;
2683:
2684: delete from PSB_WS_LINES_POSITIONS
2685: where worksheet_id = p_worksheet_id;
2686:
2687: if FND_API.to_Boolean(p_global_worksheet) then
2688: begin

Line 2693: from PSB_WS_LINES

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);
2695:
2696: end;
2697: end if;

Line 2699: delete from PSB_WS_LINES

2695:
2696: end;
2697: end if;
2698:
2699: delete from PSB_WS_LINES
2700: where worksheet_id = p_worksheet_id;
2701:
2702: delete from PSB_REENTRANT_PROCESS_STATUS
2703: where process_type = 'WORKSHEET_CREATION'

Line 3271: --delete from PSB_WS_LINES a

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
3273: -- (select 1
3274: -- from PSB_WS_ACCOUNT_LINES b
3275: -- where b.copy_of_account_line_id = p_account_line_id

Line 3281: delete from PSB_WS_LINES

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;
3283:
3284:
3285: -- Initialize API return status to success

Line 3342: delete from PSB_WS_LINES

3338:
3339: delete from PSB_WS_ELEMENT_LINES
3340: where position_line_id = p_position_line_id;
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

Line 3352: delete from PSB_WS_LINES_POSITIONS

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;
3354:
3355: delete from PSB_POSITION_ASSIGNMENTS
3356: where position_id =

Line 3530: from PSB_WS_LINES

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
3531: where worksheet_id = p_worksheet_id);
3532:
3533: delete from PSB_WS_LINES a
3534: where a.worksheet_id = p_worksheet_id

Line 3533: delete from PSB_WS_LINES a

3529: (select account_line_id
3530: from PSB_WS_LINES
3531: where worksheet_id = p_worksheet_id);
3532:
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