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_US_HR_HELPDESK dependencies on PAY_AC_EMP_SUM_ACTION_INFO_V

Line 154: from pay_ac_emp_sum_action_info_v

150: and trunc(effective_date) <= l_eff_date
151: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_PERCENTAGE
152:
153: ,(select gross_earnings
154: from pay_ac_emp_sum_action_info_v
155: where action_context_id = p_asg_action_id
156: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_EARNINGS_CV
157:
158: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))

Line 159: from pay_ac_emp_sum_action_info_v

155: where action_context_id = p_asg_action_id
156: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_EARNINGS_CV
157:
158: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))
159: from pay_ac_emp_sum_action_info_v
160: where action_context_id = p_asg_action_id
161: and action_information_category = 'AC SUMMARY CURRENT') TAXABLE_GROSS_CV
162:
163: ,(select taxes

Line 164: from pay_ac_emp_sum_action_info_v

160: where action_context_id = p_asg_action_id
161: and action_information_category = 'AC SUMMARY CURRENT') TAXABLE_GROSS_CV
162:
163: ,(select taxes
164: from pay_ac_emp_sum_action_info_v
165: where action_context_id = p_asg_action_id
166: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_TAXES_CV
167:
168: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))

Line 169: from pay_ac_emp_sum_action_info_v

165: where action_context_id = p_asg_action_id
166: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_TAXES_CV
167:
168: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))
169: from pay_ac_emp_sum_action_info_v
170: where action_context_id = p_asg_action_id
171: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_DEDUCTIONS_CV
172:
173: ,(select net_pay

Line 174: from pay_ac_emp_sum_action_info_v

170: where action_context_id = p_asg_action_id
171: and action_information_category = 'AC SUMMARY CURRENT') TOTAL_DEDUCTIONS_CV
172:
173: ,(select net_pay
174: from pay_ac_emp_sum_action_info_v
175: where action_context_id = p_asg_action_id
176: and action_information_category = 'AC SUMMARY CURRENT') NET_PAY_CV
177:
178: ,(select gross_earnings

Line 179: from pay_ac_emp_sum_action_info_v

175: where action_context_id = p_asg_action_id
176: and action_information_category = 'AC SUMMARY CURRENT') NET_PAY_CV
177:
178: ,(select gross_earnings
179: from pay_ac_emp_sum_action_info_v
180: where action_context_id = p_asg_action_id
181: and action_information_category = 'AC SUMMARY YTD') TOTAL_EARNINGS_YTD
182:
183: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))

Line 184: from pay_ac_emp_sum_action_info_v

180: where action_context_id = p_asg_action_id
181: and action_information_category = 'AC SUMMARY YTD') TOTAL_EARNINGS_YTD
182:
183: ,(select (nvl(gross_earnings, 0) - nvl(pretax_deductions, 0))
184: from pay_ac_emp_sum_action_info_v
185: where action_context_id = p_asg_action_id
186: and action_information_category = 'AC SUMMARY YTD') TAXABLE_GROSS_YTD
187:
188: ,(select taxes

Line 189: from pay_ac_emp_sum_action_info_v

185: where action_context_id = p_asg_action_id
186: and action_information_category = 'AC SUMMARY YTD') TAXABLE_GROSS_YTD
187:
188: ,(select taxes
189: from pay_ac_emp_sum_action_info_v
190: where action_context_id = p_asg_action_id
191: and action_information_category = 'AC SUMMARY YTD') TOTAL_TAXES_YTD
192:
193: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))

Line 194: from pay_ac_emp_sum_action_info_v

190: where action_context_id = p_asg_action_id
191: and action_information_category = 'AC SUMMARY YTD') TOTAL_TAXES_YTD
192:
193: ,(select (nvl(pretax_deductions, 0) + nvl(after_tax_deductions, 0))
194: from pay_ac_emp_sum_action_info_v
195: where action_context_id = p_asg_action_id
196: and action_information_category = 'AC SUMMARY YTD') TOTAL_DEDUCTIONS_YTD
197:
198: ,(select net_pay

Line 199: from pay_ac_emp_sum_action_info_v

195: where action_context_id = p_asg_action_id
196: and action_information_category = 'AC SUMMARY YTD') TOTAL_DEDUCTIONS_YTD
197:
198: ,(select net_pay
199: from pay_ac_emp_sum_action_info_v
200: where action_context_id = p_asg_action_id
201: and action_information_category = 'AC SUMMARY YTD') NET_PAY_YTD
202:
203: from pay_employee_action_info_v peai