Line 1767: AND EXISTS (SELECT 1 FROM psb_attributes pat
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
1769: AND pat.system_attribute_type = 'JOB_CLASS')
1770: AND (pava.worksheet_id = g_worksheet_id
1771: OR pava.worksheet_id IS NULL)