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_EXCEL2_PVT dependencies on PSB_POSITION_ASSIGNMENTS

Line 2072: from PSB_POSITION_ASSIGNMENTS

2068: element_value_type,
2069: element_value,
2070: effective_start_date,
2071: effective_end_date
2072: from PSB_POSITION_ASSIGNMENTS
2073: where (worksheet_id is null or worksheet_id = g_global_worksheet_id)
2074: and currency_code = g_currency_code
2075: and assignment_type = 'ELEMENT'
2076: and (((effective_start_date <= l_end_date)

Line 2103: from PSB_POSITION_ASSIGNMENTS c

2099: where (a.worksheet_id is null or a.worksheet_id = g_global_worksheet_id)
2100: and a.currency_code = g_currency_code
2101: and exists
2102: (select 1
2103: from PSB_POSITION_ASSIGNMENTS c
2104: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
2105: and (c.worksheet_id is null or c.worksheet_id = g_global_worksheet_id)
2106: and c.currency_code = g_currency_code
2107: and (((c.effective_start_date <= l_end_date)

Line 2136: from PSB_POSITION_ASSIGNMENTS

2132: effective_end_date,
2133: attribute_id,
2134: -- Fixed Bug # 3683644
2135: FND_NUMBER.canonical_to_number(attribute_value) attribute_value
2136: from PSB_POSITION_ASSIGNMENTS
2137: where attribute_id = PSB_WS_POS1.g_default_wklyhrs_id
2138: and (worksheet_id is null or worksheet_id = g_global_worksheet_id)
2139: and assignment_type = 'ATTRIBUTE'
2140: and (((effective_start_date <= l_end_date)