APPS.BEN_MANAGE_DEFAULT_ENRT dependencies on PER_ALL_ASSIGNMENTS_F

Line 810: from per_all_assignments_f asg

806: and p_organization_id is null
807: and p_legal_entity_id is null
808: and p_payroll_id is null)
809: or exists (select null
810: from per_all_assignments_f asg
811: where nvl(asg.location_id,hr_api.g_number) =
812: nvl(p_location_id,hr_api.g_number)
813: and nvl(asg.organization_id,hr_api.g_number) =
814: nvl(p_organization_id,hr_api.g_number)

Line 828: from per_all_assignments_f asg

824: and asg.effective_end_date))
825: */
826: and ((p_location_id is null )
827: or exists (select null
828: from per_all_assignments_f asg
829: where asg.location_id = p_location_id
830: and asg.person_id = pil.person_id
831: and asg.assignment_type <> 'C'
832: and asg.primary_flag = 'Y'

Line 839: per_all_assignments_f asg

835: between asg.effective_start_date and asg.effective_end_date))
836: and (( p_organization_id is null )
837: or exists (select null
838: from hr_organization_units org,
839: per_all_assignments_f asg
840: where asg.organization_id = org.organization_id
841: and org.organization_id = p_organization_id
842: and l_effective_date
843: between org.date_from and nvl(org.date_to,l_effective_date )

Line 853: per_all_assignments_f asg

849: between asg.effective_start_date and asg.effective_end_date))
850: and (( p_legal_entity_id is null )
851: or exists (select null
852: from hr_soft_coding_keyflex hsc,
853: per_all_assignments_f asg
854: where asg.person_id = pil.person_id
855: and asg.assignment_type <> 'C'
856: and asg.primary_flag = 'Y'
857: and asg.business_group_id = pil.business_group_id

Line 865: per_all_assignments_f asg

861: and hsc.segment1 = to_char(p_legal_entity_id)))
862: and (( p_payroll_id is null)
863: or exists (select null
864: from pay_payrolls_f pay,
865: per_all_assignments_f asg
866: where asg.person_id = pil.person_id
867: and asg.assignment_type <> 'C'
868: and asg.primary_flag = 'Y'
869: and asg.business_group_id = pil.business_group_id