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_CA_T4A_REG dependencies on PER_ASSIGNMENTS_F

Line 148: per_assignments_f paf,

144: paf.assignment_id assignment_id,
145: paa.assignment_action_id,
146: paa.payroll_action_id
147: from
148: per_assignments_f paf,
149: pay_assignment_actions paa
150: where
151: paf.person_id >= stperson and
152: paf.person_id <= endperson and

Line 157: from per_assignments_f paf2

153: paf.primary_flag = 'Y' and
154: paf.assignment_type = 'E' and
155: paf.business_group_id = l_bus_group_id and
156: paf.effective_start_date = (select max(paf2.effective_start_date)
157: from per_assignments_f paf2
158: where paf2.assignment_id= paf.assignment_id
159: and paf2.primary_flag = 'Y'
160: and paf2.effective_start_date
161: <= l_session_date) and --l_year_end

Line 172: from per_assignments_f paf,

168: ,p_per_id varchar2 ) is
169: select paf.assignment_id assignment_id,
170: paa.assignment_action_id,
171: paa.payroll_action_id
172: from per_assignments_f paf,
173: pay_assignment_actions paa
174: where paf.person_id between stperson
175: and endperson
176: and paf.primary_flag = 'Y'

Line 180: from per_assignments_f paf2

176: and paf.primary_flag = 'Y'
177: and paf.assignment_type = 'E'
178: and paf.business_group_id = l_bus_group_id
179: and paf.effective_start_date = (select max(paf2.effective_start_date)
180: from per_assignments_f paf2
181: where paf2.assignment_id= paf.assignment_id
182: and paf2.primary_flag = 'Y'
183: and paf2.effective_start_date
184: <= l_session_date)

Line 199: per_assignments_f paf,

195: paf.assignment_id assignment_id,
196: paa.assignment_action_id,
197: paa.payroll_action_id
198: from
199: per_assignments_f paf,
200: pay_assignment_actions paa
201: where
202: paf.person_id >= stperson and
203: paf.person_id <= endperson and

Line 208: from per_assignments_f paf2

204: paf.primary_flag = 'Y' and
205: paf.assignment_type = 'E' and
206: paf.business_group_id = l_bus_group_id and
207: paf.effective_start_date = (select max(paf2.effective_start_date)
208: from per_assignments_f paf2
209: where paf2.assignment_id= paf.assignment_id
210: and paf2.primary_flag = 'Y'
211: and paf2.effective_start_date
212: <= l_session_date) and --l_year_end