APPS.PAY_US_SQWL_ARCHIVE dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

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

737:
738: l_report_type pay_payroll_actions.report_type%type;
739: l_report_cat pay_payroll_actions.report_category%type;
740: l_state pay_payroll_actions.report_qualifier%type;
741: l_report_format pay_report_format_mappings_f.report_format%type; -- Bug# 3843134
742: l_value number;
743: l_value_sit number ; --4310812
744: l_person_on boolean ; --4349864
745: l_effective_date date;

Line 1173: from pay_report_format_mappings_f

1169:
1170: Begin
1171: select report_format
1172: into l_report_format
1173: from pay_report_format_mappings_f
1174: where report_type = l_report_type
1175: and report_qualifier = l_state
1176: and report_category = l_report_cat ;
1177: Exception

Line 1503: l_report_cat pay_report_format_mappings_f.report_category%TYPE;

1499:
1500: procedure archinit(p_payroll_action_id in number) is
1501: jurisdiction_code pay_state_rules.jurisdiction_code%TYPE;
1502: l_state VARCHAR2(30);
1503: l_report_cat pay_report_format_mappings_f.report_category%TYPE;
1504:
1505: /* Bug 773937 */
1506: l_archive boolean:= FALSE;
1507: