APPS.PQP_FEDHR_USPAY_INT_UTILS SQL Statements

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

Line: 68

        SELECT ghr_general.return_NUMBER(pcv.pcv_information2)    element_type_id,
               pcv.pcv_information1               element_old_name,
               NVL(pcv.pcv_information3,'NULL')   pay_basis
        FROM   pqp_configuration_values pcv
        WHERE  pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'
        AND    pcv.business_group_id        = p_business_group_id
        AND    NVL(pcv_information3,'NULL') = NVL(p_pay_basis,'NULL')
        -- picking Ele name based on Sal Basis esp BSR
        ORDER BY pcv.pcv_information1;

Line: 83

        SELECT pet.element_name             element_new_name
        FROM   pay_element_types_f          pet
        WHERE  pet.business_group_id        = p_business_group_id
        AND    pet.element_type_id          = p_element_type_id
        AND    pet.business_group_id        = p_business_group_id
        AND    p_effective_date BETWEEN pet.effective_start_date AND
                                 pet.effective_end_date;

Line: 267

        SELECT element_name
        FROM   per_pay_bases       ppb,
               pay_element_types_f pet,
               pay_input_values_f  piv
        WHERE  ppb.business_group_id = p_business_group_id
        AND    ppb.business_group_id = pet.business_group_id
        AND    ppb.business_group_id = piv.business_group_id
        AND    ppb.name              = p_salary_basis
        AND    ppb.input_value_id    = piv.input_value_id
        AND    piv.element_type_id    = pet.element_type_id
        AND    p_effective_date BETWEEN piv.effective_start_date AND
                                            piv.effective_end_date
        AND    p_effective_date BETWEEN pet.effective_start_date AND
                                            pet.effective_end_date;

Line: 347

        SELECT element_name
        FROM   per_pay_bases       ppb,
               pay_element_types_f pet,
               pay_input_values_f  piv
        WHERE  ppb.business_group_id = p_business_group_id
        AND    ppb.business_group_id = pet.business_group_id
        AND    ppb.business_group_id = piv.business_group_id
        AND    ppb.pay_basis_id      = p_salary_basis_id
        AND    ppb.input_value_id    = piv.input_value_id
        AND    piv.element_type_id   = pet.element_type_id
        AND    p_effective_date BETWEEN piv.effective_start_date AND
                                            piv.effective_end_date
        AND    p_effective_date BETWEEN pet.effective_start_date AND
                                            pet.effective_end_date;

Line: 366

  SELECT pay_basis_id
  FROM   per_all_assignments_f
  WHERE  assignment_id     = p_assignment_id
  AND    business_group_id = p_business_group_id
  AND    p_effective_date BETWEEN effective_start_date
                                        AND effective_end_date;

Line: 443

    SELECT pcv_information_category
    FROM   pqp_configuration_values
    WHERE  pcv_information_category = 'PQP_FEDHR_ELEMENT'
    AND    business_group_id        = p_business_group_id
    AND    pcv_information1         = p_fedhr_element_name
    AND    ROWNUM < 2;

Line: 521

    SELECT DISTINCT eli.element_link_id link_id
    FROM   pay_element_types_f elt,
           pay_element_links_f eli
    WHERE  elt.element_type_id     = eli.element_type_id
    AND    UPPER(elt.element_name) = UPPER(p_ele_name)
    AND    eli.business_group_id   = p_business_group_id
    AND    elt.business_group_id   = p_business_group_id;

Line: 533

    SELECT DISTINCT eli.element_link_id link_id
    FROM   pay_element_types_f elt,
           pay_element_links_f eli
    WHERE  elt.element_type_id     = eli.element_type_id
    AND    UPPER(elt.element_name) = UPPER(p_ele_name)
    AND    elt.business_group_id   IS NULL
    AND    elt.legislation_code    = p_legislation_code
    AND    eli.business_group_id   = p_business_group_id;

Line: 613

     SELECT pcv_information1 pb,
            pcv_information2 sb
     FROM   pqp_configuration_values pcv
     WHERE  pcv_information_category='PQP_PAY_SALARY_BASIS_MAPPING';

Line: 682

        SELECT ele.element_type_id element_type_id
        FROM   pay_element_types_f ele
        WHERE  ele.element_name  = p_agency_element_name
        AND    business_group_id = p_business_group_id
        AND    p_effective_date BETWEEN ele.effective_start_date
                                AND     ele.effective_end_date;

Line: 690

        SELECT ghr_general.return_NUMBER(pcv.pcv_information2)    element_type_id,
               pcv.pcv_information1               element_old_name,
               NVL(pcv.pcv_information3,'NULL')   pay_basis
        FROM   pqp_configuration_values pcv
        WHERE  pcv.pcv_information_category = 'PQP_FEDHR_ELEMENT'
        AND    pcv.business_group_id        = p_business_group_id
        AND    ghr_general.return_number(pcv.pcv_information2) = l_element_type_id
        ORDER BY pcv.pcv_information1;

Line: 705

        SELECT pet.element_name             element_new_name
        FROM   pay_element_types_f          pet
        WHERE  pet.business_group_id        = p_business_group_id
        AND    pet.element_type_id          = p_element_type_id
        AND    pet.business_group_id        = p_business_group_id
        AND    p_effective_date BETWEEN pet.effective_start_date AND
                                 pet.effective_end_date;