[Home] [Help]
207: l_juri_context ff_contexts.context_id%TYPE;
208:
209: CURSOR c_state_ueid (p_user_entity_name varchar2) is
210: select user_entity_id
211: from ff_user_entities
212: where user_entity_name = p_user_entity_name
213: and legislation_code = 'US';
214:
215: l_subj_whable ff_user_entities.user_entity_id%TYPE;
211: from ff_user_entities
212: where user_entity_name = p_user_entity_name
213: and legislation_code = 'US';
214:
215: l_subj_whable ff_user_entities.user_entity_id%TYPE;
216: l_subj_nwhable ff_user_entities.user_entity_id%TYPE;
217:
218: l_procedure_name VARCHAR2(100);
219:
212: where user_entity_name = p_user_entity_name
213: and legislation_code = 'US';
214:
215: l_subj_whable ff_user_entities.user_entity_id%TYPE;
216: l_subj_nwhable ff_user_entities.user_entity_id%TYPE;
217:
218: l_procedure_name VARCHAR2(100);
219:
220: begin