APPS.PQP_PROFESSIONAL_BODY_FUNCTION SQL Statements

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

Line: 23

  SELECT TO_NUMBER(eei.eei_information1)
  FROM   pay_element_types_f          ele
        ,pay_element_type_extra_info  eei
        ,fnd_sessions                 fnd
  WHERE ele.element_type_id  = p_element_type_id
    AND eei.element_type_id  = ele.element_type_id
    AND (ele.business_group_id = p_business_group_id OR
         ele.legislation_code IS NOT NULL)
    AND eei.information_type = g_eei_info_type
    AND fnd.effective_date BETWEEN ele.effective_start_date
                               AND ele.effective_end_date
    AND fnd.session_id       = USERENV('sessionid');

Line: 108

  SELECT paa.person_id
  FROM per_all_assignments_f paa
  WHERE paa.assignment_id = p_assignment_id
    AND nvl(paa.business_group_id, p_business_group_id)
                          = p_business_group_id
    AND rownum = 1;

Line: 119

  SELECT hou.name
  FROM hr_all_organization_units hou
      ,hr_organization_information hoi
  WHERE hou.organization_id   = p_organization_id
    AND nvl(hou.business_group_id, p_business_group_id)
                              = p_business_group_id
    AND hoi.organization_id   = hou.organization_id
    AND hoi.org_information1  = 'PB'
    AND hoi.org_information_context = 'CLASS';

Line: 133

  SELECT qua.professional_body_name
        ,qua.membership_category
  FROM per_qualifications qua
  WHERE qua.person_id              = l_person_id
    AND qua.professional_body_name = c_professional_body_nm
    AND nvl(qua.business_group_id, p_business_group_id)
                                   = p_business_group_id
    AND ((trunc(qua.start_date) BETWEEN l_pay_start_dt
                                    AND l_pay_end_dt) OR
         (trunc(qua.end_date) BETWEEN l_pay_start_dt
                                  AND l_pay_end_dt)   OR
         (l_pay_start_dt BETWEEN trunc(qua.start_date)
                             AND trunc(qua.end_date)) OR
         (l_pay_end_dt BETWEEN trunc(qua.start_date)
                           AND trunc(qua.end_date))   OR
         (qua.end_date IS NULL AND nvl(trunc(qua.start_date), l_pay_start_dt)
                                   <= l_pay_end_dt)
        );

Line: 271

  SELECT TO_NUMBER(hoi.org_information1)
  FROM hr_all_organization_units hou
      ,hr_organization_information hoi
  WHERE hou.organization_id         = hoi.organization_id
    AND hou.organization_id         = TO_NUMBER(p_organization_id)
    AND nvl(hou.business_group_id, p_business_group_id)
                                    = p_business_group_id
    AND hoi.org_information_context = 'PROFESSIONAL_BODY_INFORMATION';

Line: 284

  SELECT pur.row_low_range_or_name
        ,put.user_table_name
  FROM pay_user_rows_f pur
      ,pay_user_tables put
      ,fnd_sessions    fnd
  WHERE put.user_table_id     = c_user_table_id
   AND  put.user_table_id     = pur.user_table_id
   AND  put.range_or_match    = 'M'
   AND (put.business_group_id = p_business_group_id
         OR put.legislation_code IS NOT NULL)
   AND  fnd.effective_date BETWEEN pur.effective_start_date
                               AND pur.effective_end_date
   AND  fnd.session_id        = USERENV('sessionid');

Line: 300

  SELECT NULL
  FROM pay_user_columns            puc
      ,pay_user_tables             put
      ,pay_user_column_instances_f puci
      ,fnd_sessions                fnd
  WHERE puc.user_table_id       = put.user_table_id
    AND put.user_table_id       = c_user_table_id
    AND puc.user_column_id      = puci.user_column_id
    AND puc.user_column_name    = p_membership_category
    AND (put.business_group_id  = p_business_group_id
          OR put.legislation_code  IS NOT NULL)
    AND (puci.business_group_id = p_business_group_id
          OR puci.legislation_code IS NOT NULL)
    AND puci.value IS NOT NULL
    AND fnd.effective_date BETWEEN puci.effective_start_date
                               AND puci.effective_end_date
    AND fnd.session_id          = USERENV('sessionid');