APPS.PSB_EXCEL2_PVT dependencies on PSB_WORKSHEETS

Line 370: FROM psb_worksheets_i

366: CURSOR exp_ws_cur IS
367: SELECT worksheet_id, account_export_status, position_export_status,
368: currency_flag, stage_id, budget_by_position, selected_stage_id,
369: selected_template_id
370: FROM psb_worksheets_i
371: WHERE export_id = p_export_id;
372: Recinfo exp_ws_cur%ROWTYPE;
373:
374: BEGIN

Line 919: FROM psb_worksheets

915:
916:
917: FOR ws_gl_cutoff_cur IN
918: (SELECT gl_cutoff_period
919: FROM psb_worksheets
920: WHERE worksheet_id = g_worksheet_id)
921: LOOP
922:
923: l_gl_cutoff_period := ws_gl_cutoff_cur.gl_cutoff_period;

Line 3975: update psb_worksheets_i

3971: where export_id = g_export_id
3972: and export_worksheet_type = p_export_worksheet_type;
3973:
3974: IF p_export_worksheet_type = 'A' THEN
3975: update psb_worksheets_i
3976: set account_export_status = 'DELETE'
3977: where export_id = g_export_id;
3978: g_account_export_status := 'DELETE';
3979:

Line 3981: update psb_worksheets_i

3977: where export_id = g_export_id;
3978: g_account_export_status := 'DELETE';
3979:
3980: ELSE
3981: update psb_worksheets_i
3982: set position_export_status = 'DELETE'
3983: where export_id = g_export_id;
3984: g_position_export_status := 'DELETE';
3985: END IF;

Line 3997: delete from psb_worksheets_i

3993: IS
3994: BEGIN
3995: IF nvl(g_account_export_status,'DELETE') = 'DELETE'
3996: and nvl(g_position_export_status,'DELETE') = 'DELETE' THEN
3997: delete from psb_worksheets_i
3998: where export_id = g_export_id;
3999: END IF;
4000:
4001: EXCEPTION