202: p_report_qualifier in varchar2 )
203: is
204:
205: l_procedure_name VARCHAR2(100);
206: l_report_format pay_report_format_mappings_f.report_format%type;
207: l_range_person_on BOOLEAN;
208:
209: lockingactid number;
210: lockedactid number;
227:
228: Begin
229: select report_format
230: into l_report_format
231: from pay_report_format_mappings_f
232: where report_type = p_report_type
233: and report_qualifier = p_report_qualifier
234: and report_category = p_report_category
235: and p_effective_date between