DBA Data[Home] [Help]

APPS.PAY_RETRO_COMP_USAGE_INTERNAL dependencies on PAY_ELEMENT_SPAN_USAGES

Line 81: pay_element_span_usages

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:

Line 200: pay_element_span_usages

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:

Line 277: --for pay_element_span_usages and pay_retro_component_usages tables, we need

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