[Home] [Help]
200: from pay_assignment_actions
201: where assignment_action_id = p_assignment_action_id;
202: --
203: cursor csr_get_company is
204: select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
205: from hr_organization_information hoi
206: where hoi.organization_id = g_estab_id
207: AND hoi.org_information_context = 'FR_ESTAB_INFO';
208: --
240: close csr_get_org_info;
241: END cache_tokens;
242: --
243: BEGIN
244: l_gen_org_method_id_chr := fnd_number.number_to_canonical(p_org_meth);
245: --
246: if g_assignment_action_id is null or
247: g_assignment_action_id <> p_assignment_action_id
248: then
263: g_org_meth_map_tbl(l_map_tbl_ind).new_org_paymeth_id := null;
264: g_org_meth_map_tbl(l_map_tbl_ind).err_name := null;
265: -- get replacement org paymeth from estab
266: BEGIN
267: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
268: INTO p_org_method_id
269: FROM hr_organization_information hoi,
270: hr_all_organization_units org
271: WHERE hoi.organization_id = g_estab_id
294: Open csr_get_company;
295: Fetch csr_get_company into l_company_id;
296: Close csr_get_company;
297:
298: SELECT fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)
299: INTO p_org_method_id
300: FROM hr_organization_information hoi,
301: hr_all_organization_units org
302: WHERE hoi.organization_id = l_company_id
443: else
444: close csr_matching_entry;
445: -- Matching entry, only the rate must have changed so replace value
446: open csr_retro_code_by_id(
447: fnd_number.canonical_to_number(rec_matching_entry.cui1));
448: fetch csr_retro_code_by_id into l_retro_code,l_contribution_type;
449: if csr_retro_code_by_id%NOTFOUND then
450: -- retro_contribution_code not different or contribution_code
451: -- not held on pay_fr_contribution_usages