APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ASSIGNMENTS_F

Line 675: from per_assignments_f asg

671: /* bug 2985206 */
672: /* and ( (p_location_id is null and p_organization_id is null
673: and p_legal_entity_id is null and p_payroll_id is null
674: ) or exists (select null
675: from per_assignments_f asg
676: where nvl(asg.location_id,hr_api.g_number) =
677: nvl(p_location_id,hr_api.g_number)
678: and nvl(asg.organization_id,hr_api.g_number) =
679: nvl(p_organization_id,hr_api.g_number)

Line 701: from per_assignments_f asg

697: (p_location_id is null and p_organization_id is null
698: and p_payroll_id is null
699: )
700: or exists (select null
701: from per_assignments_f asg
702: where nvl(asg.location_id,hr_api.g_number) =
703: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
704: and nvl(asg.organization_id,hr_api.g_number) =
705: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))

Line 1101: from per_assignments_f paf

1097: ,p_effective_date in date
1098: ) return char is
1099: cursor c1 is
1100: select assignment_id,organization_id
1101: from per_assignments_f paf
1102: where paf.person_id = p_person_id
1103: and paf.assignment_type <> 'C'
1104: and paf.primary_flag = 'Y'
1105: and paf.business_group_id = p_business_group_id

Line 1131: -- Get assignment ID,organization_id form per_assignments_f table.

1127: begin
1128: l_step := 10;
1129: hr_utility.set_location ('Entering '||l_proc,10);
1130: --
1131: -- Get assignment ID,organization_id form per_assignments_f table.
1132: --
1133: open c1;
1134: fetch c1 into l_assignment_id,l_organization_id;
1135: if c1%notfound then