DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on PER_ALL_ASSIGNMENTS_F

Line 311: from per_all_assignments_f paa

307: and l_effective_date between ppf.effective_start_date
308: and ppf.effective_end_date
309: and (p_organization_id is null
310: or exists (select null
311: from per_all_assignments_f paa
312: where paa.person_id = ppf.person_id
313: and l_effective_date
314: between paa.effective_start_date
315: and paa.effective_end_date

Line 321: from per_all_assignments_f paa

317: and paa.primary_flag = 'Y'
318: and paa.organization_id = p_organization_id))
319: and (p_location_id is null
320: or exists (select null
321: from per_all_assignments_f paa
322: where paa.person_id = ppf.person_id
323: and l_effective_date
324: between paa.effective_start_date
325: and paa.effective_end_date

Line 353: from per_all_assignments_f paf,

349: and soft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
350: and soft.segment1 = to_char(p_legal_entity_id)))
351: and (p_payroll_id is null
352: or exists (select null
353: from per_all_assignments_f paf,
354: pay_payrolls_f pay
355: where paf.person_id = ppf.person_id
356: and pay.payroll_id = paf.payroll_id
357: and paf.payroll_id = p_payroll_id