APPS.PAY_JP_GENERIC_UPGRADE_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 413: from per_previous_employers

409: object_version_number,
410: employer_country,
411: employer_address,
412: end_date
413: from per_previous_employers
414: where person_id = p_person_id
415: and (
416: replace(upper(hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(employer_name))), ' ') =
417: replace(upper(hr_jp_standard_pkg.upper_kana(hr_jp_standard_pkg.to_hankaku(p_employer_name))), ' ')

Line 494: hr_utility.trace('Updating PER_PREVIOUS_EMPLOYERS...');

490: -- 2) Termination Date is not different.
491: -- 3) Country is not different.
492: --
493: if csr_prev_employer%found then
494: hr_utility.trace('Updating PER_PREVIOUS_EMPLOYERS...');
495: --
496: if l_prev_employer.end_date is null then
497: l_prev_employer.end_date := l_prev_job.termination_date;
498: end if;

Line 527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');

523: P_PEM_INFORMATION5 => fnd_number.number_to_canonical(l_prev_job.mutual_aid_prem),
524: P_PEM_INFORMATION6 => fnd_number.number_to_canonical(l_prev_job.withholding_tax),
525: P_OBJECT_VERSION_NUMBER => l_prev_employer.object_version_number);
526: else
527: hr_utility.trace('Inserting PER_PREVIOUS_EMPLOYERS...');
528: --
529: l_prev_employer := null;
530: --
531: if l_prev_job.foreign_flag = 'Y' then