[Home] [Help]
264: and faic.context = nvl(rtrim(p_prov), faic.context)
265: and faic.context_id = fc.context_id
266: and fc.context_name = 'JURISDICTION_CODE'
267: AND exists ( select 1 /* Selected Assignment Set */
268: from hr_assignment_set_amendments hasa
269: where hasa.assignment_set_id = l_asg_set_id
270: and hasa.assignment_id = paf.assignment_id
271: and upper(hasa.include_or_exclude) = 'I');
272: