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 IRC_ASSIGNMENT_DETAILS_F

Line 894: l_assgn_details_row irc_assignment_details_f%ROWTYPE;

890: l_effective_end_date date;
891: l_object_version_number number;
892: l_return_status varchar2(30);
893: l_update_mode varchar2(30) := p_update_mode;
894: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
895: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
896: l_appln_tracking varchar2(1);
897: --
898: cursor c_assgn_details_row is

Line 900: from irc_assignment_details_f

896: l_appln_tracking varchar2(1);
897: --
898: cursor c_assgn_details_row is
899: select *
900: from irc_assignment_details_f
901: where assignment_id =p_assignment_id
902: and sysdate between effective_start_date and effective_end_Date
903: and latest_details='Y';
904: --

Line 1003: l_assgn_details_row irc_assignment_details_f%ROWTYPE;

999: l_object_version_number number;
1000: l_row number;
1001: l_return_status varchar2(30);
1002: l_update_mode varchar2(30);
1003: l_assgn_details_row irc_assignment_details_f%ROWTYPE;
1004: l_appl_tracking varchar2(1);
1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
1006:
1007: 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;

Line 1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';

1004: l_appl_tracking varchar2(1);
1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
1006:
1007: 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;
1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
1009: 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';
1010: 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';
1011:
1012: begin

Line 1009: 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';

1005: l_business_grp_id per_all_assignments_f.business_group_id%TYPE;
1006:
1007: 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;
1008: cursor c_assgn_details_row is select * from irc_assignment_details_f where assignment_id =p_assignment_id and latest_details='Y';
1009: 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';
1010: 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';
1011:
1012: begin
1013: