APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on PER_ALL_ASSIGNMENTS_F

Line 892: from per_all_assignments_f paa

888: and ((p_pl_id is null and pgm_id = nvl(p_pgm_id, pgm_id)) or
889: (p_pgm_id is null and pl_id = nvl(p_pl_id, pl_id)))))
890: and (p_organization_id is null
891: or exists (select null
892: from per_all_assignments_f paa
893: where paa.person_id = ppf.person_id
894: and l_effective_date
895: between paa.effective_start_date
896: and paa.effective_end_date

Line 902: from per_all_assignments_f paa

898: and paa.primary_flag = 'Y'
899: and paa.organization_id = p_organization_id))
900: and (p_location_id is null
901: or exists (select null
902: from per_all_assignments_f paa
903: where paa.person_id = ppf.person_id
904: and l_effective_date
905: between paa.effective_start_date
906: and paa.effective_end_date

Line 935: per_all_assignments_f paf

931: and soft.segment1 = to_char(p_legal_entity_id)))
932: and (p_payroll_id is null
933: or exists (select null
934: from pay_payrolls_f pay,
935: per_all_assignments_f paf
936: where paf.person_id = ppf.person_id
937: and paf.assignment_type <> 'C'
938: and paf.primary_flag = 'Y'
939: and paf.business_group_id = ppf.business_group_id