eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_DADS_F_PKG dependencies on HR_LOOKUPS

Line 107: l_cre_estab_text hr_lookups.meaning%type;

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: --

Line 109: l_s10_heading_text hr_lookups.meaning%type;

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;

Line 110: l_issuing_estab_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;

Line 112: l_s20_heading_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);

Line 113: l_comp_text hr_lookups.meaning%type;

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);

Line 114: l_hq_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);
118: l_fisc_name varchar2(100);

Line 115: l_fisc_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);
119: l_s20_cre_estab varchar2(50);

Line 121: l_s30_heading_text hr_lookups.meaning%type;

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);

Line 126: l_emp_name_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);
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;

Line 127: l_emp_number_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;

Line 129: l_s41_heading_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);

Line 130: l_emp_estab_text hr_lookups.meaning%type;

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);

Line 131: l_start_date_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);
135: l_header_end_period varchar2(50);

Line 132: l_end_date_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);
136: --

Line 137: l_s80_heading_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: --
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;

Line 139: l_s80_estab_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

Line 141: l_s90_heading_text hr_lookups.meaning%type;

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

Line 861: l_cre_estab_text hr_lookups.meaning%type;

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: --

Line 863: l_s10_heading_text hr_lookups.meaning%type;

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;

Line 864: l_issuing_estab_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;

Line 866: l_s20_heading_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);

Line 867: l_comp_text hr_lookups.meaning%type;

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);

Line 868: l_hq_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);
872: l_fisc_name varchar2(100);

Line 869: l_fisc_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);
873: l_s20_cre_estab varchar2(50);

Line 875: l_s30_heading_text hr_lookups.meaning%type;

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);

Line 880: l_emp_name_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);
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;

Line 881: l_emp_number_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;

Line 883: l_s41_heading_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);

Line 884: l_emp_estab_text hr_lookups.meaning%type;

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);

Line 885: l_start_date_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);
889: l_header_end_period varchar2(50);

Line 886: l_end_date_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);
890: --

Line 891: l_s80_heading_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: --
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;

Line 893: l_s80_estab_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

Line 895: l_s90_heading_text hr_lookups.meaning%type;

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;