APPS.BEN_MAINTAIN_DESIGNEE_ELIG dependencies on PER_ASSIGNMENTS_F

Line 670: from per_assignments_f asg

666: /* bug 2985206 */
667: /* and ( (p_location_id is null and p_organization_id is null
668: and p_legal_entity_id is null and p_payroll_id is null
669: ) or exists (select null
670: from per_assignments_f asg
671: where nvl(asg.location_id,hr_api.g_number) =
672: nvl(p_location_id,hr_api.g_number)
673: and nvl(asg.organization_id,hr_api.g_number) =
674: nvl(p_organization_id,hr_api.g_number)

Line 696: from per_assignments_f asg

692: (p_location_id is null and p_organization_id is null
693: and p_payroll_id is null
694: )
695: or exists (select null
696: from per_assignments_f asg
697: where nvl(asg.location_id,hr_api.g_number) =
698: nvl(p_location_id,nvl(asg.location_id,hr_api.g_number))
699: and nvl(asg.organization_id,hr_api.g_number) =
700: nvl(p_organization_id,nvl(asg.organization_id,hr_api.g_number))

Line 1096: from per_assignments_f paf

1092: ,p_effective_date in date
1093: ) return char is
1094: cursor c1 is
1095: select assignment_id,organization_id
1096: from per_assignments_f paf
1097: where paf.person_id = p_person_id
1098: and paf.assignment_type <> 'C'
1099: and paf.primary_flag = 'Y'
1100: and paf.business_group_id = p_business_group_id

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

1122: begin
1123: l_step := 10;
1124: hr_utility.set_location ('Entering '||l_proc,10);
1125: --
1126: -- Get assignment ID,organization_id form per_assignments_f table.
1127: --
1128: open c1;
1129: fetch c1 into l_assignment_id,l_organization_id;
1130: if c1%notfound then