eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_APL_BUS dependencies on PER_PEOPLE_F

Line 425: cursor csr_valid_person_per_people_f is

421: -- Cursor to check that person_id exists, in addition obtain
422: -- the system_person_type and the business_group_id for the
423: -- other validation checks
424: --
425: cursor csr_valid_person_per_people_f is
426: select per.business_group_id,
427: typ.system_person_type
428: from per_all_people_f per,
429: per_person_types typ

Line 482: open csr_valid_person_per_people_f;

478: hr_utility.set_location(l_proc,21);
479: --
480: -- Check the person_id exist date_effectively
481: --
482: open csr_valid_person_per_people_f;
483: fetch csr_valid_person_per_people_f
484: into l_business_group_id, l_system_person_type;
485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;

Line 483: fetch csr_valid_person_per_people_f

479: --
480: -- Check the person_id exist date_effectively
481: --
482: open csr_valid_person_per_people_f;
483: fetch csr_valid_person_per_people_f
484: into l_business_group_id, l_system_person_type;
485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');

Line 485: if (csr_valid_person_per_people_f%notfound) then

481: --
482: open csr_valid_person_per_people_f;
483: fetch csr_valid_person_per_people_f
484: into l_business_group_id, l_system_person_type;
485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');
488: hr_multi_message.add
489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'

Line 486: close csr_valid_person_per_people_f;

482: open csr_valid_person_per_people_f;
483: fetch csr_valid_person_per_people_f
484: into l_business_group_id, l_system_person_type;
485: if (csr_valid_person_per_people_f%notfound) then
486: close csr_valid_person_per_people_f;
487: hr_utility.set_message(801,'HR_51194_APL_INV_DT_PERSON');
488: hr_multi_message.add
489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'

Line 493: close csr_valid_person_per_people_f;

489: (p_associated_column1 => 'PER_APPLICATIONS.PERSON_ID'
490: ,p_associated_column2 => 'PER_APPLICATIONS.DATE_RECEIVED'
491: );
492: else
493: close csr_valid_person_per_people_f;
494: --
495: hr_utility.set_location(l_proc,31);
496: --
497: -- The following person checks only need to be performed on an

Line 669: from per_people_f ppf,

665:
666: --
667: cursor csr_chk_apl_future_changes is
668: select ppf.person_id
669: from per_people_f ppf,
670: per_applications pa
671: where pa.application_id = p_application_id
672: and pa.person_id = ppf.person_id
673: and ppf.effective_start_date > p_date_end