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_SEEKER_VAC_MATCHING_PKG dependencies on IRC_POSTING_CONTENTS_TL

Line 388: FROM irc_posting_contents_tl

384: -- Need to select the CLOB now as it couldn't be used with a distinct
385: -- in the main cursor.
386: SELECT brief_description
387: INTO l_brief_description_clob
388: FROM irc_posting_contents_tl
389: WHERE posting_content_id
390: = p_posting_details_tab(counter).posting_content_id
391: and language = userenv('LANG');
392: -- Convert the CLOB to a varchar2 in order for workflow to accept it

Line 483: FROM irc_posting_contents_tl

479: -- Need to select the CLOB now as it couldn't be used with a distinct
480: -- in the main cursor.
481: SELECT brief_description
482: INTO l_brief_description_clob
483: FROM irc_posting_contents_tl
484: WHERE posting_content_id
485: = p_posting_details_tab(counter).posting_content_id
486: and language = userenv('LANG');
487: -- Convert the CLOB to a varchar2 in order for workflow to accept it

Line 830: , irc_posting_contents_tl ipc_tl

826: , icrit_vac.object_id
827: FROM
828: irc_search_criteria icrit_vac
829: , irc_posting_contents ipc
830: , irc_posting_contents_tl ipc_tl
831: , per_recruitment_activity_for praf
832: , per_recruitment_activities pra
833: , irc_all_recruiting_sites site
834: , per_all_vacancies vac

Line 1398: , irc_posting_contents_tl ipc_tl

1394: , ppf.person_id
1395: FROM
1396: irc_search_criteria icrit
1397: , per_all_people_f ppf
1398: , irc_posting_contents_tl ipc_tl
1399: , hr_locations_all loc
1400: , irc_notification_preferences inp
1401: WHERE icrit.object_type =''WPREF''
1402: AND icrit.object_id = ppf.person_id