DBA Data[Home] [Help]

APPS.PAY_MX_ISR_FORMAT37 dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 206: l_report_format pay_report_format_mappings_f.report_format%type;

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;

Line 231: from pay_report_format_mappings_f

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