APPS.BEN_CONC_REPORTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 914: from per_all_assignments_f paf

910: /* all persons within the specified organization */
911: and (g_parm.organization_id is null
912: or exists ( select '1' from
913: (select assignment_id,assignment_type,organization_id,person_id
914: from per_all_assignments_f paf
915: where business_group_id = g_parm.business_group_id
916: and paf.person_id= nvl(g_parm.person_id,paf.person_id)
917: and g_parm.effective_date
918: between nvl(effective_start_date,g_parm.effective_date )

Line 928: from per_all_assignments_f paf

924: and paf1.person_id=pen.person_id
925: union
926: select '1' from
927: (select assignment_id,assignment_type,organization_id,person_id
928: from per_all_assignments_f paf
929: where business_group_id = g_parm.business_group_id
930: and paf.person_id= nvl(g_parm.person_id,paf.person_id)
931: and g_parm.effective_date
932: between nvl(effective_start_date,g_parm.effective_date )

Line 938: and (paf1.assignment_type='B' and not exists (select 1 from per_all_assignments_f paf2

934: and primary_flag = 'Y'
935: )paf1
936: where paf1.organization_id = g_parm.organization_id
937: and paf1.person_id=pen.person_id
938: and (paf1.assignment_type='B' and not exists (select 1 from per_all_assignments_f paf2
939: where paf2.person_id = paf1.person_id
940: and paf2.business_group_id = g_parm.business_group_id
941: and g_parm.effective_date
942: between nvl(paf2.effective_start_date,g_parm.effective_date )

Line 1106: from per_all_assignments_f per

1102: and (g_parm.lf_evt_ocrd_dt is null or pil.lf_evt_ocrd_dt = g_parm.lf_evt_ocrd_dt )
1103: /* check if the person belongs to the org or location specified */
1104: and (g_parm.organization_id is null
1105: or exists (select '1'
1106: from per_all_assignments_f per
1107: where per.person_id = pil.person_id
1108: and per.primary_flag = 'Y'
1109: and per.assignment_type <> 'C'
1110: and (g_parm.organization_id is null or

Line 1116: from per_all_assignments_f per

1112: and g_parm.effective_date between per.effective_start_date
1113: and per.effective_end_date ))
1114: and (g_parm.location_id is null
1115: or exists (select '1'
1116: from per_all_assignments_f per
1117: where per.person_id = pil.person_id
1118: and per.primary_flag = 'Y'
1119: and per.assignment_type <> 'C'
1120: and (g_parm.location_id is null or