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_UTILITIES_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 898: from HR_ORGANIZATION_INFORMATION

894: and trunc(sysdate) between effective_start_date and effective_end_date;
895: --
896: cursor c_appln_tracking is
897: select nvl(ORG_INFORMATION11,'N')
898: from HR_ORGANIZATION_INFORMATION
899: where organization_id = l_business_grp_id
900: and org_information_context = 'BG Recruitment';
901: --
902: begin

Line 995: cursor c_appln_tracking is select nvl(ORG_INFORMATION11,'N') from HR_ORGANIZATION_INFORMATION where organization_id=l_business_grp_id and org_information_context='BG Recruitment';

991:
992: cursor c_bg_id is select business_group_id from per_all_assignments_f where assignment_id=p_assignment_id and trunc(sysdate) between effective_start_date and effective_end_date;
993: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
994: cursor c_assgn_details is select 1 from irc_assignment_details_f where assignment_id =p_assignment_id and sysdate between effective_start_date and effective_end_Date and latest_details='Y';
995: cursor c_appln_tracking is select nvl(ORG_INFORMATION11,'N') from HR_ORGANIZATION_INFORMATION where organization_id=l_business_grp_id and org_information_context='BG Recruitment';
996:
997: begin
998:
999: open c_bg_id;