APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on PER_ALL_ASSIGNMENTS_F

Line 824: from per_all_assignments_f asg

820: and p_organization_id is null
821: and p_legal_entity_id is null
822: and p_payroll_id is null)
823: or exists (select null
824: from per_all_assignments_f asg
825: where nvl(asg.location_id,hr_api.g_number) =
826: nvl(p_location_id,hr_api.g_number)
827: and nvl(asg.organization_id,hr_api.g_number) =
828: nvl(p_organization_id,hr_api.g_number)

Line 842: from per_all_assignments_f asg

838: and asg.effective_end_date))
839: */
840: and ((p_location_id is null )
841: or exists (select null
842: from per_all_assignments_f asg
843: where asg.location_id = p_location_id
844: and asg.person_id = pil.person_id
845: and asg.assignment_type <> 'C'
846: and asg.primary_flag = 'Y'

Line 853: per_all_assignments_f asg

849: between asg.effective_start_date and asg.effective_end_date))
850: and (( p_organization_id is null )
851: or exists (select null
852: from hr_organization_units org,
853: per_all_assignments_f asg
854: where asg.organization_id = org.organization_id
855: and org.organization_id = p_organization_id
856: and l_effective_date
857: between org.date_from and nvl(org.date_to,l_effective_date )

Line 867: per_all_assignments_f asg

863: between asg.effective_start_date and asg.effective_end_date))
864: and (( p_legal_entity_id is null )
865: or exists (select null
866: from hr_soft_coding_keyflex hsc,
867: per_all_assignments_f asg
868: where asg.person_id = pil.person_id
869: and asg.assignment_type <> 'C'
870: and asg.primary_flag = 'Y'
871: and asg.business_group_id = pil.business_group_id

Line 879: per_all_assignments_f asg

875: and hsc.segment1 = to_char(p_legal_entity_id)))
876: and (( p_payroll_id is null)
877: or exists (select null
878: from pay_payrolls_f pay,
879: per_all_assignments_f asg
880: where asg.person_id = pil.person_id
881: and asg.assignment_type <> 'C'
882: and asg.primary_flag = 'Y'
883: and asg.business_group_id = pil.business_group_id