77: ,retro_element_type_id
78: ,business_group_id
79: ,legislation_code
80: from
81: pay_element_span_usages
82: where
83: retro_component_usage_id = p_retro_comp_usage_id
84: ;
85:
196: select
197: element_span_usage_id
198: ,object_version_number
199: from
200: pay_element_span_usages
201: where
202: retro_component_usage_id = p_retro_component_usage_id
203: ;
204:
273: ,x_business_group_id out nocopy number)
274: IS
275: --Bug#4075607
276: --In order to add business group id and legislation code to unique constraint
277: --for pay_element_span_usages and pay_retro_component_usages tables, we need
278: --to check for the both these column values for the above tables to match
279: --with the pay_element_types table values.
280: --
281: Begin