APPS.PAY_DK_HOLIDAY_PAY_PKG SQL Statements

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

Line: 13

  SELECT nvl(PRD_INFORMATION1 ,0)
  FROM PER_TIME_PERIODS ptp
  WHERE PAYROLL_ID = p_payroll_id
  AND p_date_earned BETWEEN ptp.START_DATE AND ptp.END_DATE;

Line: 38

	 SELECT org_information10, fnd_number.canonical_to_number(org_information12),fnd_number.canonical_to_number(org_information13)
	 FROM hr_organization_information
	 WHERE organization_id = p_org_id
	 and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 64

  SELECT pdb.defined_balance_id
  FROM   pay_defined_balances  pdb
	,pay_balance_types  pbt
	,pay_balance_dimensions  pbd
  WHERE  pbt.legislation_code='DK'
  AND    pbt.balance_name = p_balance_name
  AND    pbd.legislation_code = 'DK'
  AND    pbd.database_item_suffix = p_balance_dim
  AND    pdb.balance_type_id = pbt.balance_type_id
  AND    pdb.balance_dimension_id = pbd.balance_dimension_id;

Line: 109

	/* Bug fix 4950983 added org_information1 in select clause */
       /* Change the to_number to fnd_number.canonical_to_number */
	 CURSOR csr_get_hol_rates(p_org_id NUMBER) is
	 SELECT fnd_number.canonical_to_number(org_information4), fnd_number.canonical_to_number(org_information3), org_information5, org_information1, org_information8 --9559824 abraghun - swapped first two columns.
	 FROM hr_organization_information
	 WHERE organization_id = p_org_id
	 and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 137

  SELECT   hoi.org_information3
	 , hoi.org_information4
  FROM     hr_organization_information  hoi
  WHERE    hoi.org_information_context='DK_EMPLOYMENT_DEFAULTS'
  AND      hoi.organization_id =  p_org_id ;

Line: 193

   SELECT  distinct eev.effective_start_date,eev.effective_end_date,eev.screen_entry_value
   FROM   per_all_assignments_f      asg
	 ,per_all_people_f           per
	 ,pay_element_links_f        el
	 ,pay_element_types_f        et
	 ,pay_input_values_f         iv
	 ,pay_element_entries_f      ee
	 ,pay_element_entry_values_f eev
   WHERE  asg.assignment_id        = p_assignment_id
     AND  per.person_id            = asg.person_id
     AND  et.element_name          = 'Holiday Accrual'
     AND  et.legislation_code      = 'DK'
     AND  iv.element_type_id       = et.element_type_id
     AND  iv.name                  = p_input_value
     AND  el.business_group_id     = per.business_group_id
     AND  el.element_type_id       = et.element_type_id
     AND  ee.assignment_id         = asg.assignment_id
     AND  ee.element_link_id       = el.element_link_id
     AND  eev.element_entry_id     = ee.element_entry_id
     AND  eev.input_value_id       = iv.input_value_id
     AND  eev.effective_end_date >= p_period_start_date /* knadhan */
     AND  eev.effective_start_date <= p_period_end_date;

Line: 220

	SELECT  effective_start_date, effective_end_date, segment10
	FROM    per_all_assignments_f  paa,
		hr_soft_coding_keyflex kf
	WHERE  assignment_id = p_assignment_id
	AND  paa.SOFT_CODING_KEYFLEX_ID = kf.SOFT_CODING_KEYFLEX_ID
	AND  ((p_period_start_date BETWEEN paa.effective_start_date AND paa.effective_end_date)
	   OR
	   (p_period_end_date BETWEEN paa.effective_start_date AND paa.effective_end_date)
	   OR
	   (p_period_start_date < paa.effective_start_date AND p_period_end_date > paa.effective_end_date));

Line: 233

	 SELECT org_information1
	 FROM hr_organization_information
	 WHERE organization_id = p_org_id
	 and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 401

SELECT value FROM nls_database_parameters
WHERE  parameter = 'NLS_TERRITORY';

Line: 589

        SELECT hoi.org_information6,
               hoi.org_information7
        FROM hr_organization_information hoi
        WHERE organization_id = csr_organization_id
        AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 596

        SELECT scl.segment19
              ,scl.segment20
        FROM hr_soft_coding_keyflex scl,
             per_all_assignments_f paaf
        WHERE scl.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
        AND paaf.assignment_id = p_assignment_id
        AND p_effective_date between paaf.effective_start_date and effective_end_date;

Line: 640

  SELECT
    aei_information1 asg_max_carryover
  FROM
    per_assignment_extra_info
  WHERE assignment_id = c_assignment_id
    AND aei_information_category = 'DK_HOLIDAY_ENTITLEMENT';

Line: 649

  SELECT
    org_information9 org_max_carryover
  FROM
    hr_organization_information
  WHERE organization_id = c_organization_id
    AND org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 658

  SELECT
    global_value gbl_max_carryover
  FROM
    ff_globals_f
  WHERE global_name = 'DK_HOLIDAY_MAX_CARRYOVER_DAYS'
    AND legislation_code = 'DK'
    AND c_effective_date BETWEEN effective_start_date AND effective_end_date;