134: l_report_format pay_report_format_mappings_f.report_format%type;
135: -- Variables declared for bug 10399514
136:
137: --
138: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
139: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
141: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
142: l_session_date pay_payroll_actions.effective_date%TYPE;
135: -- Variables declared for bug 10399514
136:
137: --
138: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
139: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
141: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
142: l_session_date pay_payroll_actions.effective_date%TYPE;
143:
137: --
138: l_uid_caeoy_tax_unit_id ff_user_entities.user_entity_id%TYPE;
139: l_uid_caeoy_tax_year ff_user_entities.user_entity_id%TYPE;
140: l_arch_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
141: l_uid_caeoy_gross_earning ff_user_entities.user_entity_id%TYPE;
142: l_session_date pay_payroll_actions.effective_date%TYPE;
143:
144: cursor c_all_gres is
145: SELECT