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.IRC_JBI_BUS dependencies on PER_RECRUITMENT_ACTIVITIES

Line 108: -- Cursor to check recruitment_activity_id exists in PER_RECRUITMENT_ACTIVITIES

104: -- |--------------------< chk_recruitment_activity_id >-----------------------|
105: -- ----------------------------------------------------------------------------
106: --
107: Procedure chk_recruitment_activity_id(p_recruitment_activity_id in number) is
108: -- Cursor to check recruitment_activity_id exists in PER_RECRUITMENT_ACTIVITIES
109: cursor csr_recruitment_activity_id(p_recruitment_activity_id number) is
110: select 1
111: from per_recruitment_activities
112: where recruitment_activity_id = p_recruitment_activity_id;

Line 111: from per_recruitment_activities

107: Procedure chk_recruitment_activity_id(p_recruitment_activity_id in number) is
108: -- Cursor to check recruitment_activity_id exists in PER_RECRUITMENT_ACTIVITIES
109: cursor csr_recruitment_activity_id(p_recruitment_activity_id number) is
110: select 1
111: from per_recruitment_activities
112: where recruitment_activity_id = p_recruitment_activity_id;
113: l_proc varchar2(72) := g_package||'chk_recruitment_activity_id';
114: begin
115: --

Line 171: per_recruitment_activities pra

167: --
168: cursor csr_sec_grp is
169: select pbg.security_group_id
170: from per_business_groups pbg,
171: per_recruitment_activities pra
172: where
173: pra.recruitment_activity_id = p_recruitment_activity_id
174: and pra.business_group_id = pbg.business_group_id;
175: --