DBA Data[Home] [Help]

APPS.BEN_CONC_REPORTS dependencies on PER_ADDRESSES

Line 977: from per_addresses addr ,

973: between asg.effective_start_date and asg.effective_end_date))
974: /* person's address has zip code specified in service area */
975: and (g_parm.svc_area_id is null
976: or exists (select null
977: from per_addresses addr ,
978: ben_svc_area_f svc ,
979: ben_svc_area_pstl_zip_rng_f spz ,
980: ben_pstl_zip_rng_f pstl
981: where addr.person_id = pen.person_id

Line 1144: from per_addresses addr ,

1140: between asg.effective_start_date and asg.effective_end_date))
1141: /* person's address has zip code specified in service area */
1142: and (g_parm.svc_area_id is null
1143: or exists (select null
1144: from per_addresses addr ,
1145: ben_svc_area_f svc ,
1146: ben_svc_area_pstl_zip_rng_f spz ,
1147: ben_pstl_zip_rng_f pstl
1148: where addr.person_id = pil.person_id