APPS.BEN_PURGE_BCKDT_VOIDED dependencies on PER_ASSIGNMENTS_F

Line 50: From per_assignments_f paf

46: ,p_err_message in out nocopy varchar2 ) as
47:
48: Cursor c1 is
49: Select assignment_id
50: From per_assignments_f paf
51: Where paf.person_id = p_person_id
52: and paf.assignment_type <> 'C'
53: And paf.primary_flag = 'Y'
54: And paf.business_group_id = p_business_group_id

Line 66: -- Get assignment ID form per_assignments_f table.

62: value_exception exception ;
63: Begin
64: hr_utility.set_location ('Entering '||l_proc,10);
65: --
66: -- Get assignment ID form per_assignments_f table.
67: --
68: l_actn := 'Opening C1 Assignment cursor...';
69: open c1;
70: fetch c1 into l_assignment_id;

Line 340: from per_assignments_f paf,

336: and pap.effective_end_date
337: and pap.benefit_group_id = p_benfts_grp_id))
338: and (p_legal_entity_id is null
339: or exists (select null
340: from per_assignments_f paf,
341: hr_soft_coding_keyflex soft
342: where paf.person_id = ppf.person_id
343: and paf.assignment_type <> 'C'
344: and l_effective_date