APPS.HR_CN_API SQL Statements

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

Line: 91

      SELECT lookup_code
      FROM   hr_lookups hrl
      WHERE  hrl.lookup_type = p_lookup_type
      AND    hrl.lookup_code = p_argument_value
      AND    enabled_flag    = 'Y';

Line: 415

           SELECT hou.organization_id
           FROM   hr_organization_units hou
           WHERE  hou.business_group_id = p_business_group_id
           AND    hou.organization_id   = p_organization_id
	   AND    p_effective_date   between  date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line: 468

          SELECT hrg.org_information_id
          FROM   hr_organization_information hrg
          WHERE  hrg.organization_id         = p_organization_id
          AND    hrg.org_information_context = p_classIFication;

Line: 519

          SELECT hrg.org_information_id
          FROM   hr_organization_information hrg
          WHERE  hrg.organization_id         = p_organization_id
          AND    hrg.org_information1        = p_type
	  AND    hrg.org_information2        = 'Y';

Line: 705

        SELECT legislation_code
        FROM per_business_groups pbg
        WHERE pbg.business_group_id = p_business_group_id;

Line: 767

      select bgp.legislation_code
      from per_people_f per,
           per_business_groups bgp
      where per.business_group_id = bgp.business_group_id
      and    per.person_id       = c_person_id
      and    c_effective_date  between per.effective_start_date and per.effective_END_date;

Line: 827

    SELECT  style
    FROM    per_addresses
    WHERE   address_id = p_address_id;

Line: 884

    SELECT  pbg.legislation_code
    FROM    per_business_groups pbg,
            per_assignments_f   asg
    WHERE   pbg.business_group_id   = asg.business_group_id
    AND     asg.assignment_id       = p_assignment_id
    AND     p_effective_date BETWEEN asg.effective_start_date AND asg.effective_END_date;

Line: 955

    SELECT  pbg.legislation_code
    FROM    per_business_groups pbg,
            pay_personal_payment_methods_f ppm
    WHERE   pbg.business_group_id           = ppm.business_group_id
    AND     ppm.personal_payment_method_id  = p_personal_payment_method_id
    AND     p_effective_date BETWEEN ppm.effective_start_date AND ppm.effective_END_date;

Line: 1208

select t.form_left_prompt
from fnd_descr_flex_col_usage_tl t,
       fnd_descr_flex_column_usages b
where t.application_id                in (800, 801)
  and b.application_id                = t.application_id
  and t.descriptive_flexfield_name    = b.descriptive_flexfield_name
  and b.descriptive_flexfield_name    = p_dff
  and b.descriptive_flex_context_code = t.descriptive_flex_context_code
  and b.descriptive_flex_context_code = p_dff_context_code
  and b.application_column_name       = t.application_column_name
  and b.end_user_column_name          = p_column_name
  and t.language                      = userenv('LANG');

Line: 1297

SELECT pectl.classification_name
FROM pay_element_classifications_tl pectl,
     pay_element_classifications pec
WHERE pec.classification_id = pectl.classification_id
  AND pectl.language =USERENV('LANG')
  AND pec.classification_name = DECODE(p_classification_name,'Voluntary Dedn','Voluntary Deductions',p_classification_name)
  AND pec.legislation_code='CN';