APPS.PER_BF_GEN_DATA_PUMP SQL Statements

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

Line: 19

    SELECT input_value_id
    INTO l_input_value_id
    FROM pay_input_values_f iv
       , pay_element_types_f et
     WHERE et.reporting_name = p_reporting_name
     AND et.business_group_id = p_business_group_id
     AND et.element_type_id = iv.element_type_id
     AND iv.display_sequence=1
     AND iv.name <> 'Pay Value'
     AND p_effective_date
	 BETWEEN et.effective_start_date AND et.effective_end_date
     AND p_effective_date
	 BETWEEN iv.effective_start_date AND iv.effective_end_date;

Line: 58

  SELECT balance_type_id
    FROM per_bf_balance_types
   WHERE internal_name  = p_balance_type_name
     AND business_group_id = p_business_group_id
     AND p_effective_date
	 BETWEEN NVL(date_from,to_date('01-01-0001','DD-MM-YYYY'))
             AND NVL(date_to,to_date('31-12-4712','DD-MM-YYYY'));

Line: 111

   SELECT pay.payroll_id
   INTO   l_payroll_id
   FROM   pay_payrolls_f pay
   WHERE  pay.payroll_name          = p_payroll_name
   AND    pay.business_group_id + 0 = p_business_group_id
   AND    p_effective_date BETWEEN
          pay.effective_start_date AND pay.effective_end_date;

Line: 137

 SELECT unique_key_id
 INTO  l_payroll_run_id
 FROM   hr_pump_batch_line_user_keys
 WHERE  user_key_value = p_payroll_run_user_key;

Line: 164

  SELECT pa.assignment_id
  INTO   l_assignment_id
  FROM   per_all_assignments_f pa
      ,  per_all_people_f pp
  WHERE pp.employee_number   = p_employee_number
    AND pp.business_group_id = p_business_group_id
    AND pp.person_id = pa.person_id
    AND pa.primary_flag = 'Y'
    AND pa.assignment_type = 'E'
    AND p_effective_date
	BETWEEN pa.effective_start_date
	    AND pa.effective_end_date
    AND p_effective_date
	BETWEEN pp.effective_start_date
	    AND pp.effective_end_date;

Line: 203

  SELECT personal_payment_method_id
  INTO l_personal_payment_method_id
  FROM PAY_PERSONAL_PAYMENT_METHODS_F ppm
     , PAY_ORG_PAYMENT_METHODS_F_TL opm
     , PER_ALL_PEOPLE_F pp
     , PER_ALL_ASSIGNMENTS_F asg
    WHERE opm.org_payment_method_id = ppm.org_payment_method_id
    AND opm.org_payment_method_name = p_org_payment_method_name
    AND pp.employee_number = p_employee_number
    AND pp.business_group_id = p_business_group_id
    AND pp.person_id = asg.person_id
    AND asg.primary_flag = 'Y'
    AND asg.assignment_id = ppm.assignment_id
    AND p_effective_date
	BETWEEN pp.effective_start_date AND pp.effective_end_date
    AND p_effective_date
	BETWEEN asg.effective_start_date AND asg.effective_end_date
    AND p_effective_date
	BETWEEN ppm.effective_start_date AND ppm.effective_end_date
    AND rownum=1
    ORDER BY priority;