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

Line 121: from per_assignments_f ASG

117: p_assignment_id number
118: ,p_effective_date date
119: ) is
120: select fnd_number.canonical_to_number(SCL.segment1) tax_unit_id
121: from per_assignments_f ASG
122: ,hr_soft_coding_keyflex SCL
123: where ASG.assignment_id = p_assignment_id
124: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
125: and p_effective_date between ASG.effective_start_date

Line 190: from per_assignments_f ASS

186: select nvl(trunc(p_upload_date -
187: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
188: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
189: END_OF_TIME)
190: from per_assignments_f ASS
191: ,hr_organization_information HOI
192: where ASS.assignment_id = p_assignment_id
193: and p_upload_date between ASS.effective_start_date
194: and ASS.effective_end_date

Line 211: from per_assignments_f ASS

207: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
208: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
209: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
210: END_OF_TIME)
211: from per_assignments_f ASS
212: ,hr_organization_information HOI
213: where ASS.assignment_id = p_assignment_id
214: and p_upload_date between ASS.effective_start_date
215: and ASS.effective_end_date

Line 228: ,per_assignments_f ASS

224: ,p_upload_date date
225: ) is
226: select nvl(PTP.start_date, END_OF_TIME)
227: from per_time_periods PTP
228: ,per_assignments_f ASS
229: where ASS.assignment_id = p_assignment_id
230: and p_upload_date between ASS.effective_start_date
231: and ASS.effective_end_date
232: and PTP.payroll_id = ASS.payroll_id

Line 249: from per_assignments_f ASS

245: ) is
246: select nvl(greatest(p_expiry_date, min(ASS.effective_start_date),
247: min(PTP.start_date)),
248: END_OF_TIME)
249: from per_assignments_f ASS
250: ,hr_soft_coding_Keyflex SCL
251: ,per_time_periods PTP
252: where ASS.assignment_id = p_assignment_id
253: and ASS.effective_start_date <= p_upload_date

Line 280: from per_assignments_f ASG

276: ,p_upload_date date
277: ) is
278: select nvl(greatest (min(ASG.effective_start_date), min(PTP.start_date)),
279: END_OF_TIME)
280: from per_assignments_f ASG
281: ,per_time_periods PTP
282: where ASG.assignment_id = p_assignment_id
283: and ASG.effective_start_date <= p_upload_date
284: and PTP.payroll_id = ASG.payroll_id

Line 308: from per_assignments_f ASS

304: ,p_tax_unit_id number
305: ) is
306: select nvl(greatest(min(ASS.effective_start_date), min(PTP.start_date)),
307: END_OF_TIME)
308: from per_assignments_f ASS
309: ,hr_soft_coding_keyflex SCL
310: ,per_time_periods PTP
311: where ASS.assignment_id = p_assignment_id
312: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id

Line 334: from per_assignments_f ASS

330: ) is
331: select nvl(greatest(min(ASS.effective_start_date),
332: min(PTP.start_date), p_expiry_date),
333: END_OF_TIME)
334: from per_assignments_f ASS
335: ,per_time_periods PTP
336: where ASS.assignment_id = p_assignment_id
337: and ASS.effective_start_date <= p_upload_date
338: and ASS.effective_end_date >= p_expiry_date

Line 355: from per_assignments_f paf

351: cursor csr_business_grp_id
352: (p_assignment_id number) is
353: select distinct
354: paf.business_group_id
355: from per_assignments_f paf
356: where paf.assignment_id = p_assignment_id;
357:
358: -- Cursor to get the Time Definition Start Date
359: cursor c_td_start_date(p_time_definition_id number