APPS.PAY_IP_ELE_INFO_CAT_UPG SQL Statements

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

Line: 67

        SELECT 'Y'
          FROM pay_element_types_f pet,
               per_business_groups pbg,
               hr_legislation_installations hli
         WHERE pet.element_type_id = p_object_id
		   AND pbg.business_group_id = pet.business_group_id
		   AND pbg.legislation_code = hli.legislation_code;

Line: 76

      SELECT 'Y'
        FROM pay_element_types_f pet,
             pay_element_classifications pec
       WHERE pet.element_type_id = p_object_id
         AND pec.classification_id = pet.classification_id
         AND pec.classification_name IN ('Earnings',
		                                 'Supplemental Earnings',
                                         'Taxable Benefits',
                                         'Voluntary Deductions',
                                         'Tax Deductions',
                                         'Direct Payment',
                                         'Employer Charges',
                                         'Involuntary Deductions',
                                         'Pre-Tax Deductions');

Line: 92

	    SELECT 'N'
		    FROM dual
       WHERE EXISTS (SELECT pet.element_information_category
                       FROM pay_element_types_f pet
                      WHERE pet.element_type_id = p_object_id
                        AND pet.element_information_category IS NOT NULL);

Line: 151

	    SELECT upper(pbg.legislation_code),
		       upper(pec.classification_name)
		  FROM pay_element_types_f pet,
		       pay_element_classifications pec,
		       per_business_groups pbg
		 WHERE pet.element_type_id = p_object_id
		   AND pbg.business_group_id = pet.business_group_id
		   AND pec.classification_id = pet.classification_id
		   AND rownum = 1;

Line: 162

        SELECT pet.object_version_number,
		       pet.effective_start_date
          FROM pay_element_types_f pet
         WHERE pet.element_type_id = p_object_id;

Line: 199

            pay_element_types_api.update_element_type
               (p_effective_date          => ld_eff_start_date,
                p_datetrack_update_mode   => 'CORRECTION',
                p_element_type_id         => p_object_id,
                p_object_version_number   => ln_object_version_number,
				p_element_information_category => lv_information_category,
				p_effective_start_date    => ld_out_start_date,
				p_effective_end_date      => ld_out_end_date,
				p_comment_id              => ln_comment_id,
				p_processing_priority_warning => lb_proc_pri_warn,
				p_element_name_warning    => lb_ele_name_warn,
				p_element_name_change_warning => lb_ele_name_chng_warn);