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.

APPS.PER_ASG_BUS2 dependencies on PER_APPLICATIONS

Line 5126: l_application_id per_applications.application_id%type;

5122: )
5123: is
5124: --
5125: l_proc varchar2(72) := g_package||'chk_dup_apl_vacancy';
5126: l_application_id per_applications.application_id%type;
5127: --
5128: cursor csr_dup_apl_vacancy is
5129: select pa.application_id
5130: from

Line 5131: per_applications pa,

5127: --
5128: cursor csr_dup_apl_vacancy is
5129: select pa.application_id
5130: from
5131: per_applications pa,
5132: per_all_assignments_f paf,
5133: per_vacancies pv
5134: where
5135: paf.person_id = p_person_id