APPS.PAY_CA_EOY_T4A_AMEND_ARCH dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 365: l_report_format pay_report_format_mappings_f.report_format%type;

361: -- Variables declared for bug 10399514
362: l_person_on boolean ;
363: l_report_cat pay_payroll_actions.report_category%type;
364: l_state pay_payroll_actions.report_qualifier%type;
365: l_report_format pay_report_format_mappings_f.report_format%type;
366: -- Variables declared for bug 10399514
367: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
368:
369:

Line 603: from pay_report_format_mappings_f

599:
600: Begin
601: select report_format
602: into l_report_format
603: from pay_report_format_mappings_f
604: where report_type = lv_report_type
605: and report_qualifier = l_state
606: and report_category = l_report_cat ;
607: Exception