APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 810: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134

806:
807: l_report_type pay_payroll_actions.report_type%type;
808: l_report_cat pay_payroll_actions.report_category%type;
809: l_state pay_payroll_actions.report_qualifier%type;
810: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
811: l_value number;
812: l_value_sit number ; --4310812
813: l_person_on boolean ; --4349864
814: l_effective_date date;

Line 1243: from pay_report_format_mappings_f

1239:
1240: Begin
1241: select report_format
1242: into l_report_format
1243: from pay_report_format_mappings_f
1244: where report_type = l_report_type
1245: and report_qualifier = l_state
1246: and report_category = l_report_cat ;
1247: Exception

Line 1602: l_report_cat pay_report_format_mappings_f.report_category%TYPE;

1598:
1599: procedure archinit(p_payroll_action_id in number) is
1600: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
1601: l_state VARCHAR2(30);
1602: l_report_cat pay_report_format_mappings_f.report_category%TYPE;
1603:
1604: /* Bug 773937 */
1605: l_archive boolean:= FALSE;
1606: