APPS.PAY_PAYSLIP_UTIL SQL Statements

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

Line: 61

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

Line: 102

    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: 112

     select hoi.org_information10
           ,fnd_date.canonical_to_date(hoi.org_information11)
       from hr_organization_information hoi
      where hoi.organization_id = cp_business_group_id
        and hoi.org_information_context like 'HR_SELF_SERVICE_BG_PREFERENCE'
        and hoi.org_information1 = 'PAYSLIP';

Line: 235

    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';