178: l_report_format pay_report_format_mappings_f.report_format%type;
179: l_range_person_on BOOLEAN;
180: l_subj_whable ff_user_entities.user_entity_name%TYPE;
181: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
182: l_tuid_context ff_contexts.context_id%TYPE;
183: l_juri_context ff_contexts.context_id%TYPE;
184:
185: l_procedure_name VARCHAR2(100);
186: l_session_date date;
179: l_range_person_on BOOLEAN;
180: l_subj_whable ff_user_entities.user_entity_name%TYPE;
181: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
182: l_tuid_context ff_contexts.context_id%TYPE;
183: l_juri_context ff_contexts.context_id%TYPE;
184:
185: l_procedure_name VARCHAR2(100);
186: l_session_date date;
187: l_year number ;
261: AND paf.assignment_type = 'E'
262: AND paf.person_id between stperson and endperson;
263:
264: CURSOR c_state_context (p_context_name varchar2) is
265: select context_id from ff_contexts
266: where context_name = p_context_name;
267:
268:
269: