APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 618: l_report_format pay_report_format_mappings_f.report_format%type;

614: -- Variables declared for bug 10399514
615: l_person_on boolean ;
616: l_report_cat pay_payroll_actions.report_category%type;
617: l_state pay_payroll_actions.report_qualifier%type;
618: l_report_format pay_report_format_mappings_f.report_format%type;
619: -- Variables declared for bug 10399514
620:
621: l_province pay_payroll_actions.report_qualifier%type;
622: l_value number;

Line 919: from pay_report_format_mappings_f

915:
916: Begin
917: select report_format
918: into l_report_format
919: from pay_report_format_mappings_f
920: where report_type = l_report_type
921: and report_qualifier = l_state
922: and report_category = l_report_cat ;
923: Exception