APPS.PAY_IN_RULES SQL Statements

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

Line: 14

    SELECT run_type_id
    FROM pay_run_types_f
    WHERE run_type_name = 'Cumulative Run'
    AND legislation_code='IN'
    AND p_effdate BETWEEN effective_start_date
                         AND effective_end_date;

Line: 67

 SELECT pet.element_name
   FROM pay_element_entries_f pee
       ,pay_element_types_f pet
  WHERE pet.element_type_id = pee.element_type_id
    AND pee.element_entry_id = p_ee_id;

Line: 75

 SELECT hsc.segment2
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 94

 SELECT hsc.segment3
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 113

 SELECT hsc.segment4
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 132

 SELECT nvl(hsc.segment6,hsc.segment5)
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 220

 SELECT pet.element_name
   FROM pay_element_entries_f pee
       ,pay_element_types_f pet
  WHERE pet.element_type_id = pee.element_type_id
    AND pee.element_entry_id = p_ee_id;

Line: 228

 SELECT hsc.segment3
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 247

 SELECT nvl(hsc.segment6,hsc.segment5)
   FROM pay_element_entries_f  target
       ,pay_assignment_actions paa
       ,pay_payroll_actions    ppa
       ,per_assignments_f      paf
       ,hr_soft_coding_keyflex hsc
  WHERE ppa.payroll_action_id = paa.payroll_action_id
    AND target.element_entry_id = p_ee_id
    AND target.assignment_id = paa.assignment_id
    AND paa.assignment_action_id = p_asg_act_id
    AND paf.assignment_id = paa.assignment_id
    AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
    AND ppa.effective_date BETWEEN target.effective_start_date
                               AND target.effective_end_date
    AND ppa.effective_date BETWEEN paf.effective_start_date
                               AND paf.effective_end_date;

Line: 334

      SELECT element_information1
      FROM   pay_element_types pet
            ,pay_element_links pel
            ,pay_element_entries pee
      WHERE  pet.element_type_id = pel.element_type_id
      AND    pel.element_link_id = pee.element_link_id
      AND    pee.element_entry_id = p_ee_id;

Line: 461

PROCEDURE delete_pre_process
          (p_template_id    IN NUMBER)
IS
  l_procedure   VARCHAR(100);

Line: 478

   pay_in_element_template_pkg.delete_pre_process
      (p_template_id => p_template_id);

Line: 487

END delete_pre_process;