APPS.PAY_US_CTGY_FEEDS_PKG SQL Statements

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

Line: 213

SELECT  et.business_group_id, et.effective_start_date,
        UPPER(ec.classification_name), et.element_information1
INTO    l_bg_id, l_ele_date, l_ele_classn, l_ele_catgry
FROM    pay_element_types_f et,
        pay_element_classifications ec
WHERE   et.element_type_id = p_element_type_id
AND     p_date between et.effective_start_date
                   and et.effective_end_date
AND     et.classification_id = ec.classification_id;

Line: 233

    SELECT  inp.input_value_id
    INTO    l_payval_id
    FROM    pay_input_values_f inp,
            hr_lookups hl
    WHERE   inp.element_type_id = p_element_type_id
    AND     inp.name            = hl.meaning
    AND     hl.lookup_code      = 'PAY VALUE'
    AND     hl.lookup_type      = 'NAME_TRANSLATIONS';

Line: 249

      SELECT	BT.balance_type_id
      INTO	l_bal_type_id
      FROM	pay_balance_types	BT
      WHERE	UPPER(BT.balance_name) 	= l_balance(i)
      AND       BT.business_group_id	IS NULL
      AND       BT.legislation_code	= 'US';

Line: 256

      SELECT    count(0)
      INTO      l_feed_exists
      FROM      pay_balance_feeds_f bf
      WHERE     l_ele_date between effective_start_date and
                                   effective_end_date
      AND       balance_type_id = l_bal_type_id
      AND       input_value_id = l_payval_id;