APPS.PAY_NO_HOLIDAY_PAY SQL Statements

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

Line: 13

     select to_number(GLOBAL_VALUE)
     into l_g_rate
     from ff_globals_f
     where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
     and LEGISLATION_CODE = 'NO'
     and BUSINESS_GROUP_ID IS NULL
     and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;

Line: 46

  SELECT end_date
  FROM per_time_periods ptp
  WHERE ptp.payroll_id = p_payroll_id
   AND ptp.start_date = p_start_date;

Line: 76

    SELECT MIN(paaf.effective_start_date) effective_start_date
    FROM per_all_assignments_f paaf
    WHERE paaf.business_group_id = p_business_group_id
     AND paaf.assignment_id = p_asg_id
     AND paaf.assignment_status_type_id = 3;

Line: 106

    SELECT hsck.segment15 holiday_entitlement,
      hsck.segment16 holiday_pay_calc_basis
    FROM per_all_assignments_f paaf,
      hr_soft_coding_keyflex hsck
    WHERE paaf.business_group_id = p_business_group_id
     AND paaf.assignment_id = p_asg_id
     AND p_effective_date BETWEEN paaf.effective_start_date
     AND paaf.effective_end_date
     AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line: 117

    SELECT papf.per_information16 holiday_entitlement,
      papf.per_information17 holiday_pay_calc_basis
    FROM per_all_people_f papf,
      per_all_assignments_f paaf
    WHERE paaf.business_group_id = p_business_group_id
     AND paaf.assignment_id = p_asg_id
     AND papf.person_id = paaf.person_id
     AND p_effective_date BETWEEN papf.effective_start_date
     AND papf.effective_end_date;

Line: 129

    SELECT hoi.org_information1 holiday_entitlement,
      hoi.org_information2 holiday_pay_calc_basis
    FROM hr_organization_information hoi
    WHERE hoi.organization_id = p_tax_unit_id
     AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';

Line: 136

    SELECT fgf.global_value
    FROM ff_globals_f fgf
    WHERE fgf.global_name = p_global_name
     AND fgf.legislation_code = 'NO'
     AND p_effective_date BETWEEN fgf.effective_start_date
     AND fgf.effective_end_date;

Line: 235

    SELECT period_num
    FROM per_time_periods
    WHERE payroll_id = p_payroll_id
     AND to_char(start_date,   'YYYY') = to_char(p_start_date,   'YYYY')
     AND prd_information2 = 'Y';

Line: 257

    SELECT paaf.person_id
    FROM per_all_assignments_f paaf
    WHERE paaf.business_group_id = p_business_group_id
     AND paaf.assignment_id = p_assg_id;

Line: 264

    SELECT SUM(to_number(ppe.pem_information2))
    FROM per_previous_employers ppe
    WHERE ppe.business_group_id = p_business_group_id
     AND ppe.person_id = p_person_id
     AND to_char(ppe.end_date,   'YYYY') = to_char(p_emp_hire_date,   'YYYY')
     AND to_char(ppe.end_date,   'YYYY') = to_char(p_asg_start_date,   'YYYY');

Line: 292

    SELECT paaf.hourly_salaried_code hourly_salaried_code,
      hsck.segment15 holiday_entitlement,
      hsck.segment16 holiday_pay_calc_basis,
      hsck.segment17 holiday_pay_in_fixed_period,
      hsck.segment18 hol_pay_over60_in_fix_period,
      hsck.segment19 holiday_pay_to_be_adjusted
    FROM per_all_assignments_f paaf,
      hr_soft_coding_keyflex hsck
    WHERE paaf.business_group_id = p_bus_group_id
     AND paaf.assignment_id = p_assignment_id
     AND p_date_earned BETWEEN paaf.effective_start_date
     AND paaf.effective_end_date
     AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;

Line: 307

    SELECT papf.per_information6 hourly_salaried_code,
      papf.per_information16 holiday_entitlement,
      papf.per_information17 holiday_pay_calc_basis,
      papf.per_information18 holiday_pay_in_fixed_period,
      papf.per_information19 hol_pay_over60_in_fix_period,
      papf.per_information20 holiday_pay_to_be_adjusted,
      papf.per_information21 res_hol_pay_to_6g_for_over60
    FROM per_all_people_f papf,
      per_all_assignments_f paaf
    WHERE paaf.business_group_id = p_bus_group_id
     AND paaf.assignment_id = p_assignment_id
     AND papf.person_id = paaf.person_id
     AND p_date_earned BETWEEN papf.effective_start_date
     AND papf.effective_end_date;

Line: 324

    SELECT hoi.org_information1 holiday_entitlement,
      hoi.org_information2 holiday_pay_calc_basis,
      hoi.org_information3 holiday_pay_in_fixed_period,
      hoi.org_information4 hol_pay_over60_in_fix_period,
      hoi.org_information5 holiday_pay_to_be_adjusted,
      hoi.org_information6 res_hol_pay_to_6g_for_over60
    FROM hr_organization_information hoi
    WHERE hoi.organization_id = p_tax_unit_id
     AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';

Line: 335

    SELECT hoi.org_information5 hourly_salaried_code
    FROM hr_organization_information hoi
    WHERE hoi.organization_id = p_tax_unit_id
     AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';

Line: 441

      SELECT MIN(paaf.effective_start_date)
      FROM per_all_assignments_f paaf
      WHERE paaf.business_group_id = p_business_group_id
       AND paaf.assignment_id = p_assignment_id
       AND paaf.assignment_status_type_id = 1;

Line: 461

	    SELECT
	      papf.per_information13 hol_accrual_entit
	    FROM per_all_people_f papf,
	      per_all_assignments_f paaf
	    WHERE paaf.business_group_id = p_bus_group_id
	     AND paaf.assignment_id = p_assignment_id
	     AND papf.person_id = paaf.person_id
	     AND p_date_earned BETWEEN papf.effective_start_date
	     AND papf.effective_end_date;

Line: 473

	    SELECT hoi.org_information9 hol_accrual_entit
	    FROM hr_organization_information hoi
	    WHERE hoi.organization_id = p_tax_unit_id
	     AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';

Line: 515

      SELECT  creator_id
      FROM    ff_user_entities
      WHERE   user_entity_name = p_entity_name
      AND     (
                      (
                              legislation_code = 'NO'
                      AND     business_group_id IS NULL
                      )
              OR      (
                              legislation_code IS NULL
                      AND     business_group_id = p_business_group_id
                      )
              )
      AND     creator_type = 'B';