APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on IRC_POSTING_CONTENTS_TL

Line 441: FROM irc_posting_contents_tl

437: l_job_content := null;
438: l_length := 0;
439: SELECT substr(brief_description,1,500), length(brief_description)
440: INTO l_brief_description_v, l_length
441: FROM irc_posting_contents_tl
442: WHERE posting_content_id = p_posting_details_tab(counter).posting_content_id
443: AND language = userenv('LANG');
444: --
445: IF (l_length > 0) THEN

Line 548: FROM irc_posting_contents_tl

544: l_job_content := null;
545: l_length := 0;
546: SELECT substr(brief_description,1,500), length(brief_description)
547: INTO l_brief_description_v, l_length
548: FROM irc_posting_contents_tl
549: WHERE posting_content_id = p_posting_details_tab(counter).posting_content_id
550: AND language = userenv('LANG');
551: --
552: IF (l_length > 0) THEN

Line 904: , irc_posting_contents_tl ipc_tl

900: , ipc_tl.name
901: , icrit_vac.object_id
902: FROM irc_search_criteria icrit_vac
903: , irc_posting_contents ipc
904: , irc_posting_contents_tl ipc_tl
905: , per_recruitment_activity_for praf
906: , per_recruitment_activities pra
907: , irc_all_recruiting_sites site
908: , per_all_vacancies vac

Line 1578: , irc_posting_contents_tl ipc_tl

1574: ppf.full_name
1575: , ppf.person_id
1576: FROM irc_search_criteria icrit
1577: , per_all_people_f ppf
1578: , irc_posting_contents_tl ipc_tl
1579: --, hr_locations_all loc
1580: , irc_notification_preferences inp
1581: WHERE icrit.object_type = ''WPREF''
1582: AND icrit.object_id = ppf.person_id