APPS.PAY_CN_RULES SQL Statements

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

Line: 69

      SELECT pet.element_name, pee.creator_type
      FROM   pay_element_entries_f pee
            ,pay_element_links_f pel
            ,pay_element_types_f pet
      WHERE pee.element_link_id  = pel.element_link_id
      AND   pel.element_type_id  = pet.element_type_id
      AND   pee.element_entry_id = p_ee_id
      AND   p_effective_date BETWEEN pel.effective_start_date
                             AND     pel.effective_end_date
      AND   p_effective_date BETWEEN pet.effective_start_date
                             AND     pet.effective_end_date
      ORDER BY pee.effective_start_date desc;

Line: 83

      SELECT element_name, 'F'
      FROM   pay_element_types_f
      WHERE  element_type_id = p_element_type_id
      AND    p_effective_date BETWEEN effective_start_date
                              AND     effective_end_date;

Line: 90

      SELECT hsck.segment20, pa.business_group_id
      FROM   pay_element_entries_f pee
            ,per_assignments_f pa
            ,hr_soft_coding_keyflex hsck
      WHERE pee.assignment_id         = pa.assignment_id
      AND   pa.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
      AND   pee.element_entry_id = p_ee_id
      AND   p_effective_date BETWEEN pa.effective_start_date
                             AND     pa.effective_end_date
      ORDER BY pee.effective_start_date desc;

Line: 103

      SELECT org_information2
      FROM   hr_organization_information
      WHERE  organization_id = p_bg_id
      AND    org_information_context = 'PER_CONT_AREA_RETRO_USAGE_CN'
      AND    org_information1        = p_tax_area
      AND    p_effective_date BETWEEN TO_DATE(org_information3,'YYYY/MM/DD HH24:MI:SS')
                              AND     TO_DATE(NVL(org_information4,'4712/12/31 00:00:00'),'YYYY/MM/DD HH24:MI:SS');