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.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_ASSIGNMENT_BUDGET_VALUES

Line 295: FROM per_assignment_budget_values_f pab,

291: ( ( pp.position_type <> 'SINGLE')
292: AND
293: ( nvl(pp.fte,1) >
294: ( SELECT sum(nvl(value,1))
295: FROM per_assignment_budget_values_f pab,
296: per_all_assignments_f paf,
297: per_assignment_status_types past
298: -- bug 4020452 added the join with per_assignment_status_types
299: WHERE fs.session_id = userenv('sessionid')

Line 4644: from per_assignment_budget_values

4640:
4641: /*For Bug No : 2109120 Start*/
4642: Cursor C_Fte is
4643: Select value
4644: from per_assignment_budget_values
4645: where assignment_id = l_assignment_id
4646: --changed the unit value from 'F' to 'FTE'
4647: and unit = 'FTE';
4648: /*For Bug No : 2109120 End*/

Line 4670: per_assignment_budget_values pab,

4666: /*For Bug No : 2109120 Start*/
4667: CURSOR C_check_FTE(l_pos_id NUMBER) IS
4668: SELECT sum(nvl(value,1)) sum_fte
4669: FROM fnd_sessions fs,
4670: per_assignment_budget_values pab,
4671: per_all_assignments_f paf,
4672: per_assignment_status_types past
4673: WHERE fs.session_id = userenv('sessionid')
4674: AND fs.effective_date between paf.effective_start_date