APPS.PAY_PAYSLIP_UTIL SQL Statements

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

Line: 52

      select org_information9
       from  hr_organization_information
      where  organization_id         = cp_business_group_id
        and  org_information_context = 'Business Group Information';

Line: 90

    select rule_mode
      from pay_legislative_field_info
     where legislation_code = cp_legislation_code
       and field_name       = 'CHOOSE_PAYSLIP'
       and validation_name  = 'ITEM_PROPERTY'
       and validation_type  = 'DISPLAY'
       and target_location  = 'PAY_PAYSLIP'
       and rule_type        = 'PAYSLIP_EMPLYR_ADDR';

Line: 134

    select rule_mode
      from pay_legislative_field_info
     where legislation_code = gv_legislation_code
       and field_name       = 'ACTION_INFO_STATE'
       and validation_name  = 'ITEM_PROPERTY'
       and validation_type  = 'DISPLAY'
       and target_location  = 'PAY_PAYSLIP'
       and rule_type        = 'ACTION_INFO_STATE';