DBA Data[Home] [Help]

APPS.PAY_US_DEDN_TEMPLATE_WRAPPER dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 288: from pay_element_type_extra_info

284: --
285: cursor c2 is
286: select element_type_extra_info_id
287: ,object_version_number
288: from pay_element_type_extra_info
289: where element_type_id = p_element_type_id
290: and information_type = 'PQP_US_PRE_TAX_DEDUCTIONS'
291: and eei_information_category = 'PQP_US_PRE_TAX_DEDUCTIONS';
292: --

Line 341: -- from pay_element_type_extra_info table.

337: ,p_ele_name => p_element_name
338: ,p_effective_date => p_eff_start_date
339: );
340: -- Delete entry for Catch-up Processing (if present)
341: -- from pay_element_type_extra_info table.
342: for c2_rec in c2 loop
343: pay_element_extra_info_api.delete_element_extra_info
344: (p_validate => false
345: ,p_element_type_extra_info_id => c2_rec.element_type_extra_info_id