[Home] [Help]
272: l_si_prov_count NUMBER := 0;
273:
274: BEGIN
275: select count(distinct(context_value)) into l_si_prov_count
276: from pay_action_contexts
277: where context_id IN (select context_id from ff_contexts
278: where context_name = 'SOURCE_TEXT2')
279: and assignment_action_id in (select paa.assignment_action_id from
280: per_all_assignments_f paaf,