103: l_s30_order_by varchar2(100);
104: l_s30_cond_order_by varchar2(100);
105: --
106: l_header_issue_estab varchar2(50);
107: l_cre_estab_text hr_lookups.meaning%type;
108: l_s10_cre_estab varchar2(50);
109: l_s10_heading_text hr_lookups.meaning%type;
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
105: --
106: l_header_issue_estab varchar2(50);
107: l_cre_estab_text hr_lookups.meaning%type;
108: l_s10_cre_estab varchar2(50);
109: l_s10_heading_text hr_lookups.meaning%type;
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
106: l_header_issue_estab varchar2(50);
107: l_cre_estab_text hr_lookups.meaning%type;
108: l_s10_cre_estab varchar2(50);
109: l_s10_heading_text hr_lookups.meaning%type;
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
114: l_hq_text hr_lookups.meaning%type;
108: l_s10_cre_estab varchar2(50);
109: l_s10_heading_text hr_lookups.meaning%type;
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
114: l_hq_text hr_lookups.meaning%type;
115: l_fisc_text hr_lookups.meaning%type;
116: l_comp_name varchar2(100);
109: l_s10_heading_text hr_lookups.meaning%type;
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
114: l_hq_text hr_lookups.meaning%type;
115: l_fisc_text hr_lookups.meaning%type;
116: l_comp_name varchar2(100);
117: l_hq_name varchar2(100);
110: l_issuing_estab_text hr_lookups.meaning%type;
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
114: l_hq_text hr_lookups.meaning%type;
115: l_fisc_text hr_lookups.meaning%type;
116: l_comp_name varchar2(100);
117: l_hq_name varchar2(100);
118: l_fisc_name varchar2(100);
111: --
112: l_s20_heading_text hr_lookups.meaning%type;
113: l_comp_text hr_lookups.meaning%type;
114: l_hq_text hr_lookups.meaning%type;
115: l_fisc_text hr_lookups.meaning%type;
116: l_comp_name varchar2(100);
117: l_hq_name varchar2(100);
118: l_fisc_name varchar2(100);
119: l_s20_cre_estab varchar2(50);
117: l_hq_name varchar2(100);
118: l_fisc_name varchar2(100);
119: l_s20_cre_estab varchar2(50);
120: --
121: l_s30_heading_text hr_lookups.meaning%type;
122: l_header_emp_number varchar2(50);
123: l_header_emp_title varchar2(50);
124: l_header_first_name varchar2(100);
125: l_header_last_name varchar2(100);
122: l_header_emp_number varchar2(50);
123: l_header_emp_title varchar2(50);
124: l_header_first_name varchar2(100);
125: l_header_last_name varchar2(100);
126: l_emp_name_text hr_lookups.meaning%type;
127: l_emp_number_text hr_lookups.meaning%type;
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
123: l_header_emp_title varchar2(50);
124: l_header_first_name varchar2(100);
125: l_header_last_name varchar2(100);
126: l_emp_name_text hr_lookups.meaning%type;
127: l_emp_number_text hr_lookups.meaning%type;
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
131: l_start_date_text hr_lookups.meaning%type;
125: l_header_last_name varchar2(100);
126: l_emp_name_text hr_lookups.meaning%type;
127: l_emp_number_text hr_lookups.meaning%type;
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
131: l_start_date_text hr_lookups.meaning%type;
132: l_end_date_text hr_lookups.meaning%type;
133: l_emp_header_estab_name varchar2(100);
126: l_emp_name_text hr_lookups.meaning%type;
127: l_emp_number_text hr_lookups.meaning%type;
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
131: l_start_date_text hr_lookups.meaning%type;
132: l_end_date_text hr_lookups.meaning%type;
133: l_emp_header_estab_name varchar2(100);
134: l_header_start_period varchar2(50);
127: l_emp_number_text hr_lookups.meaning%type;
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
131: l_start_date_text hr_lookups.meaning%type;
132: l_end_date_text hr_lookups.meaning%type;
133: l_emp_header_estab_name varchar2(100);
134: l_header_start_period varchar2(50);
135: l_header_end_period varchar2(50);
128: --
129: l_s41_heading_text hr_lookups.meaning%type;
130: l_emp_estab_text hr_lookups.meaning%type;
131: l_start_date_text hr_lookups.meaning%type;
132: l_end_date_text hr_lookups.meaning%type;
133: l_emp_header_estab_name varchar2(100);
134: l_header_start_period varchar2(50);
135: l_header_end_period varchar2(50);
136: --
133: l_emp_header_estab_name varchar2(100);
134: l_header_start_period varchar2(50);
135: l_header_end_period varchar2(50);
136: --
137: l_s80_heading_text hr_lookups.meaning%type;
138: l_s80_header_estab_name varchar2(100);
139: l_s80_estab_text hr_lookups.meaning%type;
140: --
141: l_s90_heading_text hr_lookups.meaning%type;
135: l_header_end_period varchar2(50);
136: --
137: l_s80_heading_text hr_lookups.meaning%type;
138: l_s80_header_estab_name varchar2(100);
139: l_s80_estab_text hr_lookups.meaning%type;
140: --
141: l_s90_heading_text hr_lookups.meaning%type;
142:
143: -- Cursor for fetching the payroll action
137: l_s80_heading_text hr_lookups.meaning%type;
138: l_s80_header_estab_name varchar2(100);
139: l_s80_estab_text hr_lookups.meaning%type;
140: --
141: l_s90_heading_text hr_lookups.meaning%type;
142:
143: -- Cursor for fetching the payroll action
144: Cursor csr_payroll_action is
145: Select action_context_id
857: l_s30_order_by varchar2(100);
858: l_s30_cond_order_by varchar2(100);
859: --
860: l_header_issue_estab varchar2(50);
861: l_cre_estab_text hr_lookups.meaning%type;
862: l_s10_cre_estab varchar2(50);
863: l_s10_heading_text hr_lookups.meaning%type;
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
859: --
860: l_header_issue_estab varchar2(50);
861: l_cre_estab_text hr_lookups.meaning%type;
862: l_s10_cre_estab varchar2(50);
863: l_s10_heading_text hr_lookups.meaning%type;
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
860: l_header_issue_estab varchar2(50);
861: l_cre_estab_text hr_lookups.meaning%type;
862: l_s10_cre_estab varchar2(50);
863: l_s10_heading_text hr_lookups.meaning%type;
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
868: l_hq_text hr_lookups.meaning%type;
862: l_s10_cre_estab varchar2(50);
863: l_s10_heading_text hr_lookups.meaning%type;
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
868: l_hq_text hr_lookups.meaning%type;
869: l_fisc_text hr_lookups.meaning%type;
870: l_comp_name varchar2(100);
863: l_s10_heading_text hr_lookups.meaning%type;
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
868: l_hq_text hr_lookups.meaning%type;
869: l_fisc_text hr_lookups.meaning%type;
870: l_comp_name varchar2(100);
871: l_hq_name varchar2(100);
864: l_issuing_estab_text hr_lookups.meaning%type;
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
868: l_hq_text hr_lookups.meaning%type;
869: l_fisc_text hr_lookups.meaning%type;
870: l_comp_name varchar2(100);
871: l_hq_name varchar2(100);
872: l_fisc_name varchar2(100);
865: --
866: l_s20_heading_text hr_lookups.meaning%type;
867: l_comp_text hr_lookups.meaning%type;
868: l_hq_text hr_lookups.meaning%type;
869: l_fisc_text hr_lookups.meaning%type;
870: l_comp_name varchar2(100);
871: l_hq_name varchar2(100);
872: l_fisc_name varchar2(100);
873: l_s20_cre_estab varchar2(50);
871: l_hq_name varchar2(100);
872: l_fisc_name varchar2(100);
873: l_s20_cre_estab varchar2(50);
874: --
875: l_s30_heading_text hr_lookups.meaning%type;
876: l_header_emp_number varchar2(50);
877: l_header_emp_title varchar2(50);
878: l_header_first_name varchar2(100);
879: l_header_last_name varchar2(100);
876: l_header_emp_number varchar2(50);
877: l_header_emp_title varchar2(50);
878: l_header_first_name varchar2(100);
879: l_header_last_name varchar2(100);
880: l_emp_name_text hr_lookups.meaning%type;
881: l_emp_number_text hr_lookups.meaning%type;
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
877: l_header_emp_title varchar2(50);
878: l_header_first_name varchar2(100);
879: l_header_last_name varchar2(100);
880: l_emp_name_text hr_lookups.meaning%type;
881: l_emp_number_text hr_lookups.meaning%type;
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
885: l_start_date_text hr_lookups.meaning%type;
879: l_header_last_name varchar2(100);
880: l_emp_name_text hr_lookups.meaning%type;
881: l_emp_number_text hr_lookups.meaning%type;
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
885: l_start_date_text hr_lookups.meaning%type;
886: l_end_date_text hr_lookups.meaning%type;
887: l_emp_header_estab_name varchar2(100);
880: l_emp_name_text hr_lookups.meaning%type;
881: l_emp_number_text hr_lookups.meaning%type;
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
885: l_start_date_text hr_lookups.meaning%type;
886: l_end_date_text hr_lookups.meaning%type;
887: l_emp_header_estab_name varchar2(100);
888: l_header_start_period varchar2(50);
881: l_emp_number_text hr_lookups.meaning%type;
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
885: l_start_date_text hr_lookups.meaning%type;
886: l_end_date_text hr_lookups.meaning%type;
887: l_emp_header_estab_name varchar2(100);
888: l_header_start_period varchar2(50);
889: l_header_end_period varchar2(50);
882: --
883: l_s41_heading_text hr_lookups.meaning%type;
884: l_emp_estab_text hr_lookups.meaning%type;
885: l_start_date_text hr_lookups.meaning%type;
886: l_end_date_text hr_lookups.meaning%type;
887: l_emp_header_estab_name varchar2(100);
888: l_header_start_period varchar2(50);
889: l_header_end_period varchar2(50);
890: --
887: l_emp_header_estab_name varchar2(100);
888: l_header_start_period varchar2(50);
889: l_header_end_period varchar2(50);
890: --
891: l_s80_heading_text hr_lookups.meaning%type;
892: l_s80_header_estab_name varchar2(100);
893: l_s80_estab_text hr_lookups.meaning%type;
894: --
895: l_s90_heading_text hr_lookups.meaning%type;
889: l_header_end_period varchar2(50);
890: --
891: l_s80_heading_text hr_lookups.meaning%type;
892: l_s80_header_estab_name varchar2(100);
893: l_s80_estab_text hr_lookups.meaning%type;
894: --
895: l_s90_heading_text hr_lookups.meaning%type;
896: --
897: -- To store the number of employees and companies in an establishment
891: l_s80_heading_text hr_lookups.meaning%type;
892: l_s80_header_estab_name varchar2(100);
893: l_s80_estab_text hr_lookups.meaning%type;
894: --
895: l_s90_heading_text hr_lookups.meaning%type;
896: --
897: -- To store the number of employees and companies in an establishment
898: l_total_employees number;
899: l_total_companies number;