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

Line 76: from per_assignments_f ASG

72: p_assignment_id number
73: ,p_effective_date date
74: ) is
75: select to_number(SCL.segment1) tax_unit_id
76: from per_assignments_f ASG
77: ,hr_soft_coding_keyflex SCL
78: where ASG.assignment_id = p_assignment_id
79: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
80: and p_effective_date between ASG.effective_start_date

Line 145: from per_assignments_f ASS

141: select nvl(trunc(p_upload_date -
142: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD') +1,'Y')
143: - 1 + to_char(fnd_date.canonical_to_date(HOI.org_information11),'DDD'),
144: END_OF_TIME)
145: from per_assignments_f ASS
146: ,hr_organization_information HOI
147: where ASS.assignment_id = p_assignment_id
148: and p_upload_date between ASS.effective_start_date
149: and ASS.effective_end_date

Line 166: from per_assignments_f ASS

162: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') + 1, 'Q'),
163: to_char(fnd_date.canonical_to_date(HOI.org_informatioN11),'MM') - 1) +
164: to_char(fnd_date.canonical_to_date(HOI.org_information11),'DD') - 1,
165: END_OF_TIME)
166: from per_assignments_f ASS
167: ,hr_organization_information HOI
168: where ASS.assignment_id = p_assignment_id
169: and p_upload_date between ASS.effective_start_date
170: and ASS.effective_end_date

Line 183: ,per_assignments_f ASS

179: ,p_upload_date date
180: ) is
181: select nvl(PTP.start_date, END_OF_TIME)
182: from per_time_periods PTP
183: ,per_assignments_f ASS
184: where ASS.assignment_id = p_assignment_id
185: and p_upload_date between ASS.effective_start_date
186: and ASS.effective_end_date
187: and PTP.payroll_id = ASS.payroll_id

Line 203: from per_assignments_f ASS

199: ,p_tax_unit_id number
200: ) is
201: select nvl(greatest(p_expiry_date, min(ASS.effective_start_date)),
202: END_OF_TIME)
203: from per_assignments_f ASS
204: ,hr_soft_coding_Keyflex SCL
205: where ASS.assignment_id = p_assignment_id
206: and ASS.effective_start_date <= p_upload_date
207: and ASS.effective_end_date >= p_expiry_date

Line 219: from per_assignments_f ASG

215: p_assignment_id number
216: ,p_upload_date date
217: ) is
218: select nvl(min(ASG.effective_start_date), END_OF_TIME)
219: from per_assignments_f ASG
220: where ASG.assignment_id = p_assignment_id
221: and ASG.effective_start_date <= p_upload_date;
222: --
223: -- Returns the earliest date on which the assignment exists and the

Line 235: from per_assignments_f ASS

231: ,p_tax_unit_id number
232: ) is
233: select nvl(min(ASS.effective_start_date),
234: END_OF_TIME)
235: from per_assignments_f ASS
236: ,hr_soft_coding_keyflex SCL
237: where ASS.assignment_id = p_assignment_id
238: and SCL.soft_coding_keyflex_id = ASS.soft_coding_keyflex_id
239: and ASS.effective_start_date <= p_upload_date

Line 249: from per_assignments_f ASS

245: ,p_expiry_date date
246: ) is
247: select nvl(greatest(min(ASS.effective_start_date), p_expiry_date),
248: END_OF_TIME)
249: from per_assignments_f ASS
250: where ASS.assignment_id = p_assignment_id
251: and ASS.effective_start_date <= p_upload_date
252: and ASS.effective_end_date >= p_expiry_date;
253: --