APPS.PSB_PURGE_DATA_EXTRACT_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 58

    Select entity_set_id
      from psb_entity_set
     where data_extract_id = p_data_extract_id;

Line: 63

    Select entity_id
      from psb_entity
     where data_extract_id = p_data_extract_id;

Line: 68

    Select position_id
      from psb_positions
     where data_extract_id = p_data_extract_id;

Line: 73

    Select default_rule_id,
	   entity_id
      from psb_defaults
     where data_extract_id = p_data_extract_id;

Line: 79

    Select pay_element_id
      from psb_pay_elements
     where data_extract_id = p_data_extract_id;

Line: 84

    Select position_set_group_id
      from psb_element_pos_set_groups
     where pay_element_id = l_pay_element_id;

Line: 89

    Select attribute_id,attribute_value_id
      from psb_attribute_values
     where data_extract_id = p_data_extract_id;

Line: 94

    Select account_position_set_id
      from psb_account_position_sets
     where data_extract_id = p_data_extract_id;

Line: 99

    Select line_sequence_id
      from psb_account_position_set_lines
     where account_position_set_id = l_account_position_set_id;

Line: 104

    Select budget_workflow_rule_id
      from psb_budget_workflow_rules
     where data_extract_id = p_data_extract_id;

Line: 142

     delete psb_positions_i
      where data_extract_id = p_data_extract_id;

Line: 150

     delete psb_salary_i
      where data_extract_id = p_data_extract_id;

Line: 158

     delete psb_employees_i
      where data_extract_id = p_data_extract_id;

Line: 168

     delete psb_cost_distributions_i
      where data_extract_id = p_data_extract_id;

Line: 179

     delete psb_attribute_values_i
      where data_extract_id = p_data_extract_id;

Line: 189

     delete psb_employee_assignments_i
      where data_extract_id = p_data_extract_id;

Line: 199

     delete psb_reentrant_process_status
      where process_uid = p_data_extract_id
	and process_type = 'HR DATA EXTRACT';

Line: 208

    Select count(*)
      into l_worksheet_cnt
      from psb_worksheets
     where data_extract_id = p_data_extract_id;

Line: 214

       FND_MESSAGE.SET_NAME('PSB', 'PSB_DE_CANNOT_BE_DELETED');

Line: 224

      Delete psb_entity_assignment
       where entity_set_id = C_Entity_Set_Rec.entity_set_id;

Line: 232

    Delete psb_entity_set
     where data_extract_id = p_data_extract_id;

Line: 242

      Delete psb_entity_assignment
       where entity_id = C_Entity_Rec.entity_id;

Line: 249

    Delete psb_entity
     where data_extract_id = p_data_extract_id;

Line: 259

       Delete psb_position_assignments
	where position_id = C_Positions_Rec.position_id;

Line: 265

       Delete psb_budget_positions
	where position_id = C_Positions_Rec.position_id;

Line: 271

       Delete psb_position_pay_distributions
	where position_id = C_Positions_Rec.position_id;

Line: 278

    Delete psb_positions
     where data_extract_id = p_data_extract_id;

Line: 286

    Delete psb_employees
     where data_extract_id = p_data_extract_id;

Line: 297

       Delete Psb_Set_Relations
	where default_rule_id = C_Default_Rec.default_rule_id;

Line: 304

       Delete Psb_Default_Account_Distrs
	where default_rule_id = C_Default_Rec.default_rule_id;

Line: 311

       Delete Psb_Default_Assignments
	where default_rule_id = C_Default_Rec.default_rule_id;

Line: 318

       Delete Psb_Entity
	where entity_id = C_Default_Rec.entity_id;

Line: 321

       Delete Psb_allocrule_percents
	where allocation_rule_id = C_Default_Rec.entity_id;

Line: 331

    Delete Psb_Defaults
     where data_extract_id = p_data_extract_id;

Line: 342

      Delete Psb_pay_element_options
       where pay_element_id = C_Element_Rec.pay_element_id;

Line: 349

      Delete Psb_pay_element_rates
       where pay_element_id = C_Element_Rec.pay_element_id;

Line: 358

      Delete Psb_Pay_Element_Distributions
       where position_set_group_id = C_Set_Group_Rec.position_set_group_id;

Line: 365

      Delete Psb_Set_Relations
       where position_set_group_id = C_Set_Group_Rec.position_set_group_id;

Line: 373

      Delete Psb_Element_Pos_Set_Groups
       where pay_element_id = l_pay_element_id;

Line: 381

      Delete Psb_Pay_Elements
       where data_extract_id = p_data_extract_id;

Line: 392

      Delete Psb_Set_Relations
       where account_position_set_id = C_Account_Position_Set_Rec.account_position_set_id;

Line: 400

	Delete Psb_Position_Set_Line_values
	 where line_sequence_id = C_Lines_Rec.line_sequence_id;

Line: 407

      Delete Psb_Account_Position_Set_Lines
       where account_position_set_id = C_Account_Position_Set_Rec.account_position_set_id;

Line: 415

      Delete Psb_Budget_Positions
       where account_position_set_id = C_Account_Position_Set_Rec.account_position_set_id;

Line: 423

      Delete Psb_Account_Position_Sets
       where data_extract_id = p_data_extract_id;

Line: 434

	Delete Psb_Position_Set_Line_Values
	 where attribute_value_id = C_Attribute_Value_Rec.attribute_value_id;

Line: 442

      Delete Psb_Attribute_Values
       where data_extract_id = p_data_extract_id;

Line: 453

	Delete Psb_Set_Relations
	 where budget_workflow_rule_id = C_Review_Group_Rule_Rec.budget_workflow_rule_id;

Line: 463

      Delete Psb_Budget_Workflow_Rules
       where data_extract_id = p_data_extract_id;

Line: 469

    Delete Psb_Data_Extracts
     where data_extract_id = p_data_extract_id;

Line: 561

  Select data_extract_name
    into l_data_extract_name
    from psb_data_extracts
   where data_extract_id = p_data_extract_id;

Line: 581

      message_token('PROCESS', 'Delete Data Extract');