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.PER_APP_ASG_PKG dependencies on IRC_ASSIGNMENT_STATUSES

Line 630: select min(assignment_status_id) from irc_assignment_statuses

626: l_irc_asg_type number;
627: l_irc_asg_ovn number;
628:
629: cursor csr_asg_data is
630: select min(assignment_status_id) from irc_assignment_statuses
631: where assignment_id = p_assignment_id
632: and STATUS_CHANGE_DATE > p_effective_end_date;
633: --- Fix For Bug # 9183199 ---
634:

Line 1507: -- insert into irc_assignment_statuses if the assignment status has changed

1503: p_assignment_id => p_assignment_id);
1504: hr_utility.set_location ('per_app_asg_pkg.update_row', 16);
1505: -- End of fix 3634447
1506:
1507: -- insert into irc_assignment_statuses if the assignment status has changed
1508: --
1509: if l_previous_asg_status <> p_assignment_status_type_id then
1510: --
1511: -- 3652025: if terminated, client already performed this step