DBA Data[Home] [Help]

APPS.PAY_US_NACHA_TAPE dependencies on PER_ASSIGNMENTS_F

Line 218: from per_assignments_f perasg,

214: and hroinf.org_information1 = 'HR_LEGAL'
215: and hroinf.org_information2 = 'Y'
216: and EXISTS
217: ( select 1
218: from per_assignments_f perasg,
219: pay_assignment_actions pyaact
220: where pyaact.payroll_action_id = p_payroll_action_id
221: and pyaact.tax_unit_id = hrorgu.organization_id
222: and perasg.assignment_id = pyaact.assignment_id

Line 255: from per_assignments_f paf,

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

Line 292: from per_assignments_f paf,

288: -- Commented for performance improvement Bug 3587226
289: /*
290: and exists
291: ( select 'x'
292: from per_assignments_f paf,
293: hr_soft_coding_keyflex hsck
294: where paf.assignment_id = paa.assignment_id
295: and g_effective_date between paf.effective_start_date
296: and paf.effective_end_date