APPS.PSB_PURGE_DATA_EXTRACT_PVT dependencies on PSB_POSITIONS

Line 69: from psb_positions

65: where data_extract_id = p_data_extract_id;
66:
67: Cursor C_Positions is
68: Select position_id
69: from psb_positions
70: where data_extract_id = p_data_extract_id;
71:
72: Cursor C_Defaults is
73: Select default_rule_id,

Line 142: delete psb_positions_i

138:
139: -- API body
140: Begin
141: begin
142: delete psb_positions_i
143: where data_extract_id = p_data_extract_id;
144: commit work;
145: exception
146: when NO_DATA_FOUND then

Line 278: Delete psb_positions

274: null;
275: End;
276: End Loop;
277: Begin
278: Delete psb_positions
279: where data_extract_id = p_data_extract_id;
280: exception When NO_DATA_FOUND then
281: null;
282: End;