APPS.PAY_US_SQWL_UDF SQL Statements

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

Line: 100

     SELECT  hoi.org_information3 wage_plan
       FROM  hr_organization_information hoi
      WHERE  hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
        AND  hoi.organization_id    = p_tax_unit_id
        AND  hoi.org_information1   = p_transfer_state;

Line: 131

     SELECT DISTINCT aei_information3 wage_plan
       FROM per_assignment_extra_info paei
      WHERE paei.assignment_id       = p_assignment_id
        AND paei.aei_information1    = p_transfer_state
        AND paei.information_type    = 'PAY_US_ASG_STATE_WAGE_PLAN_CD';

Line: 186

  SELECT count(*) ct
  FROM   hr_organization_information
  WHERE  organization_id          = p_organization_id
    AND  org_information_context  = p_org_information_context
    AND  org_information1         = p_org_information1
    AND  org_information4         = 'Y';

Line: 194

SELECT count(*) ct
  FROM (select distinct
              a.organization_id,
              a.org_information1,
              a.org_information3
        FROM  hr_organization_information a
       WHERE  org_information_context  = 'PAY_US_STATE_WAGE_PLAN_INFO') b
 WHERE b.organization_id = p_organization_id
   AND 1 < (   SELECT count(*)
                        FROM  hr_organization_information orgi
                       WHERE  organization_id          = p_organization_id
                         AND  org_information_context  = 'PAY_US_STATE_WAGE_PLAN_INFO'
                         AND  org_information1         = b.org_information1
                         AND  org_information3         = b.org_information3);

Line: 311

  SELECT tax_unit_id
  FROM   pay_assignment_actions
  WHERE  assignment_action_id = p_assignment_action_id;

Line: 317

  SELECT target.ORG_INFORMATION8 yes_no
    FROM hr_organization_information           target
   WHERE target.organization_id                = l_tax_unit_id
     AND target.org_information_context        = 'Federal Tax Rules';

Line: 438

  SELECT user_entity_id
    FROM ff_user_entities
   WHERE user_entity_name  = 'A_ASG_GRE_EMPLOYMENT_TYPE_CODE';

Line: 444

  SELECT arch.value
    FROM ff_archive_items arch
   WHERE arch.user_entity_id    = p_user_entity_id
     AND arch.context1          = p_assignment_action_id;