APPS.PAY_RCU_UPD dependencies on PAY_RETRO_COMPONENT_USAGES

Line 68: -- Update the pay_retro_component_usages Row

64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: --
67: --
68: -- Update the pay_retro_component_usages Row
69: --
70: update pay_retro_component_usages
71: set
72: retro_component_usage_id = p_rec.retro_component_usage_id

Line 70: update pay_retro_component_usages

66: --
67: --
68: -- Update the pay_retro_component_usages Row
69: --
70: update pay_retro_component_usages
71: set
72: retro_component_usage_id = p_rec.retro_component_usage_id
73: ,retro_component_id = p_rec.retro_component_id
74: ,creator_id = p_rec.creator_id

Line 191: l_retro_component_id pay_retro_component_usages.retro_component_id%type;

187: ) is
188: --
189: l_proc varchar2(72) := g_package||'post_update';
190: p_element_type_id pay_entry_process_details.source_element_type_id%type;
191: l_retro_component_id pay_retro_component_usages.retro_component_id%type;
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: begin

Line 248: (p_module_name => 'PAY_RETRO_COMPONENT_USAGES'

244: --
245: when hr_api.cannot_find_prog_unit then
246: --
247: hr_api.cannot_find_prog_unit_error
248: (p_module_name => 'PAY_RETRO_COMPONENT_USAGES'
249: ,p_hook_type => 'AU');
250: --
251: end;
252: --

Line 267: select RETRO_COMPONENT_ID into l_retro_component_id from pay_retro_component_usages where

263: where pepd.RETRO_COMPONENT_ID is null and source_element_type_id = p_rec.creator_id;
264:
265: if p_element_type_id is not null then
266: if p_rec.default_component <> 'Y' then
267: select RETRO_COMPONENT_ID into l_retro_component_id from pay_retro_component_usages where
268: creator_id = p_rec.creator_id and default_component = 'Y' and
269: (( business_group_id = p_rec.business_group_id and
270: legislation_code is null )
271: or