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.PA_RESOURCE_PVT dependencies on PER_JOB_EXTRA_INFO

Line 939: FROM per_job_extra_info

935:
936:
937: SELECT jei_information2, jei_information3,jei_information6
938: INTO l_billable_flag, l_utilization_flag, l_schedulable_flag
939: FROM per_job_extra_info
940: WHERE job_id = p_job_id
941: AND information_type = l_job_info_type;
942:
943: IF l_billable_flag IS NULL THEN

Line 1068: from table per_job_extra_info in three different hits, wrote a procedure to directly query

1064: /* Start of commented code for bug#6875286
1065: Reason to do so:
1066: =================
1067: Instead of deriving billable_flag, utilization_flag and schedulable_flag
1068: from table per_job_extra_info in three different hits, wrote a procedure to directly query
1069: these 3 flags. This would reduce the hits to the table from 3 to 1 and thus improve the performance.
1070:
1071: -- get the resource's billable flag
1072: l_billable_flag := PA_HR_UPDATE_API.check_job_billability(