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: 39

  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: 72

	/* 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_information3), fnd_number.canonical_to_number(org_information4), org_information5, org_information1
	 FROM hr_organization_information
	 WHERE organization_id = p_org_id
	 and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';

Line: 100

  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: 156

   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_start_date >= p_period_start_date
     AND  eev.effective_start_date <= p_period_end_date;

Line: 180

	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: 193

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

Line: 361

SELECT value FROM nls_database_parameters
WHERE  parameter = 'NLS_TERRITORY';

Line: 549

        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: 556

        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;