APPS.BEN_PREMIUM_CONCURRENT dependencies on PER_ASSIGNMENTS_F

Line 124: From per_assignments_f paf

120: ,p_err_message in out nocopy varchar2 ) as
121:
122: Cursor c1 is
123: Select assignment_id
124: From per_assignments_f paf
125: Where paf.person_id = p_person_id
126: and paf.assignment_type <> 'C'
127: And paf.primary_flag = 'Y'
128: And paf.business_group_id = p_business_group_id

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

137: value_exception exception ;
138: Begin
139: hr_utility.set_location ('Entering '||l_proc,10);
140: --
141: -- Get assignment ID form per_assignments_f table.
142: --
143: l_actn := 'Opening C1 Assignment cursor...';
144: open c1;
145: fetch c1 into l_assignment_id;

Line 588: from per_assignments_f paf,

584: and primary_flag = 'Y'
585: and organization_id = p_organization_id ) )
586: and ( p_legal_entity_id is null
587: or exists (select null
588: from per_assignments_f paf,
589: hr_soft_coding_keyflex soft
590: where paf.person_id = pen.person_id
591: and p_effective_date
592: between paf.effective_start_date