DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PER_ASSIGNMENTS_F

Line 213: from per_assignments_f perasg,

209: and hroinf.org_information1 = 'HR_LEGAL'
210: and hroinf.org_information2 = 'Y'
211: and EXISTS
212: ( select 1
213: from per_assignments_f perasg,
214: pay_assignment_actions pyaact
215: where pyaact.payroll_action_id = p_payroll_action_id
216: and pyaact.tax_unit_id = hrorgu.organization_id
217: and perasg.assignment_id = pyaact.assignment_id

Line 250: from per_assignments_f paf,

246: order by ppp.rowid;
247: -- Commented for performance improvement Bug 3587226
248: /* and exists
249: ( select 'x'
250: from per_assignments_f paf,
251: hr_soft_coding_keyflex hsck
252: where paf.assignment_id = paa.assignment_id
253: and g_effective_date between paf.effective_start_date
254: and paf.effective_end_date

Line 287: from per_assignments_f paf,

283: -- Commented for performance improvement Bug 3587226
284: /*
285: and exists
286: ( select 'x'
287: from per_assignments_f paf,
288: hr_soft_coding_keyflex hsck
289: where paf.assignment_id = paa.assignment_id
290: and g_effective_date between paf.effective_start_date
291: and paf.effective_end_date