APPS.PAY_RCU_UPD dependencies on PAY_ENTRY_PROCESS_DETAILS

Line 190: p_element_type_id pay_entry_process_details.source_element_type_id%type;

186: ,p_rec in pay_rcu_shd.g_rec_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);

Line 262: select distinct(source_element_type_id) into p_element_type_id from pay_entry_process_details pepd

258: If there are more than one retro-components for an element type, we use the
259: defualt retro_component_id
260: */
261: begin
262: select distinct(source_element_type_id) into p_element_type_id from pay_entry_process_details pepd
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

Line 277: update pay_entry_process_details set RETRO_COMPONENT_ID = l_retro_component_id

273: or
274: (legislation_code is null and business_group_id is null )
275: );
276: -- If there is no default component, we don't update the retro_component_id in PEPD
277: update pay_entry_process_details set RETRO_COMPONENT_ID = l_retro_component_id
278: where RETRO_COMPONENT_ID is null and source_element_type_id = p_rec.creator_id;
279: else
280: update pay_entry_process_details set RETRO_COMPONENT_ID = p_rec.retro_component_id
281: where RETRO_COMPONENT_ID is null and source_element_type_id = p_rec.creator_id;

Line 280: update pay_entry_process_details set RETRO_COMPONENT_ID = p_rec.retro_component_id

276: -- If there is no default component, we don't update the retro_component_id in PEPD
277: update pay_entry_process_details set RETRO_COMPONENT_ID = l_retro_component_id
278: where RETRO_COMPONENT_ID is null and source_element_type_id = p_rec.creator_id;
279: else
280: update pay_entry_process_details set RETRO_COMPONENT_ID = p_rec.retro_component_id
281: where RETRO_COMPONENT_ID is null and source_element_type_id = p_rec.creator_id;
282: end if;
283: end if;
284: exception