APPS.PAY_WAT_UDFS SQL Statements

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

Line: 7

SELECT	nvl(pee.subpriority, 1)
INTO	l_subprio
FROM	pay_element_entries_f            	PEE
WHERE  	PEE.element_entry_id	= p_ele_entry_id
AND	p_date_earned
		BETWEEN PEE.effective_start_date
		    AND PEE.effective_end_date;

Line: 23

SELECT  pet.element_information1
INTO    l_cat
FROM    pay_element_types_f pet,
        pay_element_links_f pel,
        pay_element_entries_f                   PEE
WHERE   PEE.element_entry_id    = p_ele_entry_id
AND     p_date_earned
                BETWEEN PEE.effective_start_date
                    AND PEE.effective_end_date
AND     pel.element_link_id = PEE.element_link_id
AND     PEE.effective_start_date between pel.effective_start_date
        and pel.effective_end_date
ANd     pet.element_type_id = pel.element_type_id
AND     pel.effective_start_date between pet.effective_start_date
        and pet.effective_end_date;

Line: 232

SELECT fnd_date.canonical_to_date(ev.screen_entry_value)
FROM pay_input_values_f iv,
  pay_element_entry_values_f ev
WHERE ev.element_entry_id = p_element_entry_id
AND p_effective_date
             BETWEEN ev.effective_start_date and ev.effective_end_date
AND iv.input_value_id = ev.input_value_id
AND iv.name = 'Date Served';

Line: 264

    SELECT MIN(effective_start_date)
    INTO ld_garn_date
    FROM pay_element_entries_f ee
    WHERE ee.element_entry_id = p_element_entry_id;

Line: 273

  SELECT target.max_withholding_duration_days
  INTO ln_garn_limit_days
  FROM PAY_US_GARN_LIMIT_RULES_F target,
    PAY_ELEMENT_TYPES_F pet
  WHERE target.state_code = SUBSTR(p_jursd_code,1,2)
  AND target.garn_category = pet.element_information1
  AND ld_garn_date BETWEEN target.effective_start_date
                                  AND target.effective_end_date
  AND pet.element_type_id = p_element_type_id;

Line: 283

/* Commenting the section below as per the Update by Nora Daly
   in Bug# 6140374 on 07/16/07 11:16 am

  AND ld_garn_date
          BETWEEN pet.effective_start_date AND pet.effective_end_date;