DBA Data[Home] [Help]

APPS.HR_H2PI_MAIN_UPLOAD SQL Statements

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

Line: 10

  DELETE FROM hr_h2pi_employees
  WHERE  client_id = p_from_client_id;
Line: 13

  DELETE FROM hr_h2pi_addresses
  WHERE  client_id = p_from_client_id;
Line: 16

  DELETE FROM hr_h2pi_assignments
  WHERE  client_id = p_from_client_id;
Line: 19

  DELETE FROM hr_h2pi_periods_of_service
  WHERE  client_id = p_from_client_id;
Line: 22

  DELETE FROM hr_h2pi_locations
  WHERE  client_id = p_from_client_id;
Line: 25

  DELETE FROM hr_h2pi_pay_bases
  WHERE  client_id = p_from_client_id;
Line: 28

  DELETE FROM hr_h2pi_hr_organizations
  WHERE  client_id = p_from_client_id;
Line: 31

  DELETE FROM hr_h2pi_organization_class
  WHERE  client_id = p_from_client_id;
Line: 34

  DELETE FROM hr_h2pi_organization_info
  WHERE  client_id = p_from_client_id;
Line: 37

  DELETE FROM hr_h2pi_payrolls
  WHERE  client_id = p_from_client_id;
Line: 40

  DELETE FROM hr_h2pi_element_types
  WHERE  client_id = p_from_client_id;
Line: 43

  DELETE FROM hr_h2pi_input_values
  WHERE  client_id = p_from_client_id;
Line: 46

  DELETE FROM hr_h2pi_element_links
  WHERE  client_id = p_from_client_id;
Line: 49

  DELETE FROM hr_h2pi_bg_and_gre
  WHERE  client_id = p_from_client_id;
Line: 52

  DELETE FROM hr_h2pi_org_payment_methods
  WHERE  client_id = p_from_client_id;
Line: 55

  DELETE FROM hr_h2pi_patch_status
  WHERE  client_id = p_from_client_id;
Line: 58

  DELETE FROM hr_h2pi_federal_tax_rules
  WHERE  client_id = p_from_client_id;
Line: 61

  DELETE FROM hr_h2pi_state_tax_rules
  WHERE  client_id = p_from_client_id;
Line: 64

  DELETE FROM hr_h2pi_county_tax_rules
  WHERE  client_id = p_from_client_id;
Line: 67

  DELETE FROM hr_h2pi_city_tax_rules
  WHERE  client_id = p_from_client_id;
Line: 70

  DELETE FROM hr_h2pi_salaries
  WHERE  client_id = p_from_client_id;
Line: 73

  DELETE FROM hr_h2pi_cost_allocations
  WHERE  client_id = p_from_client_id;
Line: 76

  DELETE FROM hr_h2pi_payment_methods
  WHERE  client_id = p_from_client_id;
Line: 79

  DELETE FROM hr_h2pi_element_names
  WHERE  client_id = p_from_client_id;
Line: 82

  DELETE FROM hr_h2pi_element_entries
  WHERE  client_id = p_from_client_id;
Line: 85

  DELETE FROM hr_h2pi_element_entry_values
  WHERE  client_id = p_from_client_id;
Line: 89

  DELETE FROM hr_h2pi_bg_and_gre
  WHERE  client_id = p_from_client_id;
Line: 92

  DELETE FROM hr_h2pi_payrolls
  WHERE  client_id = p_from_client_id;
Line: 95

  DELETE FROM hr_h2pi_pay_bases
  WHERE  client_id = p_from_client_id;
Line: 98

  DELETE FROM hr_h2pi_org_payment_methods
  WHERE  client_id = p_from_client_id;
Line: 101

  DELETE FROM hr_h2pi_element_types
  WHERE  client_id = p_from_client_id;
Line: 104

  DELETE FROM hr_h2pi_input_values
  WHERE  client_id = p_from_client_id;
Line: 107

  DELETE FROM hr_h2pi_element_links
  WHERE  client_id = p_from_client_id;
Line: 110

  DELETE FROM hr_h2pi_us_city_names
  WHERE  client_id = p_from_client_id;
Line: 113

  DELETE FROM hr_h2pi_us_modified_geocodes
  WHERE  client_id = p_from_client_id;
Line: 129

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_addresses
    where  client_id = l_from_client_id;
Line: 133

    select l_stage_rec_count + count(*)

    into   l_stage_rec_count
    from   hr_h2pi_assignments
    where  client_id = l_from_client_id;
Line: 139

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_bg_and_gre
    where  client_id = l_from_client_id;
Line: 144

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_city_tax_rules
    where  client_id = l_from_client_id;
Line: 149

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_cost_allocations
    where  client_id = l_from_client_id;
Line: 154

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_county_tax_rules
    where  client_id = l_from_client_id;
Line: 159

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_element_entries
    where  client_id = l_from_client_id;
Line: 164

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_element_entry_values
    where  client_id = l_from_client_id;
Line: 169

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_element_links
    where  client_id = l_from_client_id;
Line: 174

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_element_names
    where  client_id = l_from_client_id;
Line: 179

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_element_types
    where  client_id = l_from_client_id;
Line: 184

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_employees
    where  client_id = l_from_client_id;
Line: 189

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_federal_tax_rules
    where  client_id = l_from_client_id;
Line: 194

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_hr_organizations
    where  client_id = l_from_client_id;
Line: 199

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_input_values
    where  client_id = l_from_client_id;
Line: 204

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_locations
    where  client_id = l_from_client_id;
Line: 209

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_organization_class
    where  client_id = l_from_client_id;
Line: 214

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_organization_info
    where  client_id = l_from_client_id;
Line: 219

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_org_payment_methods
    where  client_id = l_from_client_id;
Line: 224

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_patch_status
    where  client_id = l_from_client_id;
Line: 229

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_payment_methods
    where  client_id = l_from_client_id;
Line: 234

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_payrolls
    where  client_id = l_from_client_id;
Line: 239

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_pay_bases
    where  client_id = l_from_client_id;
Line: 244

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_periods_of_service
    where  client_id = l_from_client_id;
Line: 249

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_salaries
    where  client_id = l_from_client_id;
Line: 254

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_state_tax_rules
    where  client_id = l_from_client_id;
Line: 259

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_us_city_names
    where  client_id = l_from_client_id;
Line: 264

    select l_stage_rec_count + count(*)
    into   l_stage_rec_count
    from   hr_h2pi_us_modified_geocodes
    where  client_id = l_from_client_id;
Line: 369

    DELETE FROM hr_h2pi_message_lines
    WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id;