DBA Data[Home] [Help]

APPS.PAY_1099R_PKG dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 162: l_report_format pay_report_format_mappings_f.report_format%type;

158: l_effective_date DATE;
159: l_report_type pay_payroll_actions.report_type%type;
160: l_report_category pay_payroll_actions.report_category%type;
161: l_report_qualifier pay_payroll_actions.report_qualifier%type;
162: l_report_format pay_report_format_mappings_f.report_format%type;
163: l_range_person_on BOOLEAN;
164: l_subj_whable ff_user_entities.user_entity_name%TYPE;
165: l_subj_nwhable ff_user_entities.user_entity_name%TYPE;
166: l_tuid_context ff_contexts.context_id%TYPE;

Line 310: from pay_report_format_mappings_f

306:
307: Begin
308: select report_format
309: into l_report_format
310: from pay_report_format_mappings_f
311: where report_type = l_report_type
312: and report_qualifier = l_report_qualifier
313: and report_category = l_report_category
314: and l_effective_date between