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_DB_PER_ADDITIONAL dependencies on PER_POSITIONS

Line 1044: , per_positions pos

1040: , l_job_id
1041: , l_organization_id
1042: , l_location_id
1043: FROM per_organization_units org
1044: , per_positions pos
1045: WHERE pos.name = p_position
1046: AND pos.business_group_id + 0 = l_business_group_id
1047: AND pos.organization_id = org.organization_id
1048: AND l_effective_start_date BETWEEN pos.date_effective

Line 1441: , per_positions pos

1437: , l_job_id
1438: , l_organization_id
1439: , l_location_id
1440: FROM per_organization_units org
1441: , per_positions pos
1442: WHERE pos.name = p_position
1443: AND pos.business_group_id + 0 = l_business_group_id
1444: AND pos.organization_id = org.organization_id
1445: AND l_effective_start_date BETWEEN pos.date_effective

Line 1866: , per_positions pos

1862: , l_job_id
1863: , l_organization_id
1864: , l_location_id
1865: FROM per_organization_units org
1866: , per_positions pos
1867: WHERE pos.name = p_position
1868: AND pos.business_group_id + 0 = l_business_group_id
1869: AND pos.organization_id = org.organization_id
1870: AND l_effective_start_date BETWEEN pos.date_effective

Line 2007: , per_positions pos

2003: , l_job_id
2004: , l_organization_id
2005: , l_location_id
2006: FROM per_organization_units org
2007: , per_positions pos
2008: WHERE pos.name = p_position
2009: AND pos.business_group_id + 0 = l_business_group_id
2010: AND pos.organization_id = org.organization_id
2011: AND l_effective_start_date BETWEEN pos.date_effective