APPS.PSB_EXCEL_PVT dependencies on PSB_POSITION_ASSIGNMENTS

Line 1330: from PSB_POSITION_ASSIGNMENTS

1326: element_value_type,
1327: element_value,
1328: effective_start_date,
1329: effective_end_date
1330: from PSB_POSITION_ASSIGNMENTS
1331: where (worksheet_id is null or worksheet_id = g_global_worksheet_id)
1332: and element_value_type = 'PS'
1333: and currency_code = g_currency_code
1334: and assignment_type = 'ELEMENT'

Line 1363: from PSB_POSITION_ASSIGNMENTS c

1359: and a.currency_code = g_currency_code
1360: and a.element_value_type = 'PS'
1361: and exists
1362: (select 1
1363: from PSB_POSITION_ASSIGNMENTS c
1364: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
1365: and (c.worksheet_id is null or c.worksheet_id = g_global_worksheet_id)
1366: and c.currency_code = g_currency_code
1367: and (((c.effective_start_date <= l_end_date)

Line 1744: psb_employees emp, psb_position_assignments pavb

1740: emp.employee_id,
1741: emp.employee_number,
1742: emp.full_name
1743: FROM
1744: psb_employees emp, psb_position_assignments pavb
1745: WHERE pavb.assignment_type = 'EMPLOYEE'
1746: AND pavb.position_id = l_position_id
1747: AND emp.employee_id = pavb.employee_id
1748: AND (pavb.worksheet_id = g_worksheet_id

Line 1764: FROM psb_attribute_values patv, psb_position_assignments pava

1760: (
1761: SELECT
1762: pava.attribute_id,
1763: patv.attribute_value
1764: FROM psb_attribute_values patv, psb_position_assignments pava
1765: WHERE patv.attribute_value_id = pava.attribute_value_id
1766: AND pava.position_id = l_position_id
1767: AND EXISTS (SELECT 1 FROM psb_attributes pat
1768: WHERE pat.attribute_id = pava.attribute_id