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_US_EMP_W4DTL_ACTION_INFO_V

Line 99: ,(select status from pay_us_emp_w4dtl_action_info_v

95: ,payroll_name
96: ,'USD'
97: ,to_char(ending_date,'YYYY-MM-DD')
98: ,'Federal'
99: ,(select status from pay_us_emp_w4dtl_action_info_v
100: where action_context_id = p_asg_action_id
101: and tax_jurisdiction = 'Federal'
102: and trunc(effective_date) <= l_eff_date) STATUS
103:

Line 104: ,(select exemptions from pay_us_emp_w4dtl_action_info_v

100: where action_context_id = p_asg_action_id
101: and tax_jurisdiction = 'Federal'
102: and trunc(effective_date) <= l_eff_date) STATUS
103:
104: ,(select exemptions from pay_us_emp_w4dtl_action_info_v
105: where action_context_id = p_asg_action_id
106: and assignment_id = p_asg_id
107: and trunc(effective_date) <= l_eff_date
108: and tax_jurisdiction = 'Federal') EXEMPTIONS

Line 110: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v

106: and assignment_id = p_asg_id
107: and trunc(effective_date) <= l_eff_date
108: and tax_jurisdiction = 'Federal') EXEMPTIONS
109:
110: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v
111: where action_context_id = p_asg_action_id
112: and assignment_id = p_asg_id
113: and trunc(effective_date) <= l_eff_date
114: and tax_jurisdiction = 'Federal') ADDNL_TAX_AMOUNT

Line 116: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v

112: and assignment_id = p_asg_id
113: and trunc(effective_date) <= l_eff_date
114: and tax_jurisdiction = 'Federal') ADDNL_TAX_AMOUNT
115:
116: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v
117: where action_context_id = p_asg_action_id
118: and assignment_id = p_asg_id
119: and trunc(effective_date) <= l_eff_date
120: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_AMOUNT

Line 122: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v

118: and assignment_id = p_asg_id
119: and trunc(effective_date) <= l_eff_date
120: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_AMOUNT
121:
122: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v
123: where action_context_id = p_asg_action_id
124: and assignment_id = p_asg_id
125: and trunc(effective_date) <= l_eff_date
126: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_PERCENTAGE

Line 129: ,(select exemptions from pay_us_emp_w4dtl_action_info_v

125: and trunc(effective_date) <= l_eff_date
126: and tax_jurisdiction = 'Federal') OVERRIDE_TAX_PERCENTAGE
127: ,p_state_code
128:
129: ,(select exemptions from pay_us_emp_w4dtl_action_info_v
130: where action_context_id = p_asg_action_id
131: and assignment_id = p_asg_id
132: and trunc(effective_date) <= l_eff_date
133: and tax_jurisdiction = p_state_desc) STEXEMPTIONS

Line 135: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v

131: and assignment_id = p_asg_id
132: and trunc(effective_date) <= l_eff_date
133: and tax_jurisdiction = p_state_desc) STEXEMPTIONS
134:
135: ,(select additional_tax_amount from pay_us_emp_w4dtl_action_info_v
136: where action_context_id = p_asg_action_id
137: and assignment_id = p_asg_id
138: and trunc(effective_date) <= l_eff_date
139: and tax_jurisdiction = p_state_desc) STADDNL_TAX_AMOUNT

Line 141: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v

137: and assignment_id = p_asg_id
138: and trunc(effective_date) <= l_eff_date
139: and tax_jurisdiction = p_state_desc) STADDNL_TAX_AMOUNT
140:
141: ,(select override_tax_amount from pay_us_emp_w4dtl_action_info_v
142: where action_context_id = p_asg_action_id
143: and assignment_id = p_asg_id
144: and trunc(effective_date) <= l_eff_date
145: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_AMOUNT

Line 147: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v

143: and assignment_id = p_asg_id
144: and trunc(effective_date) <= l_eff_date
145: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_AMOUNT
146:
147: ,(select override_tax_percentage from pay_us_emp_w4dtl_action_info_v
148: where action_context_id = p_asg_action_id
149: and assignment_id = p_asg_id
150: and trunc(effective_date) <= l_eff_date
151: and tax_jurisdiction = p_state_desc) STOVERRIDE_TAX_PERCENTAGE