DBA Data[Home] [Help]

APPS.BEN_TCS_STMT_PROCESS dependencies on PER_ASSIGNMENTS_F

Line 2175: per_assignments_f asgnmt

2171: FROM per_people_f per,
2172: per_person_types ppt,
2173: per_person_type_usages_f usg,
2174: per_all_people_f per_nm,
2175: per_assignments_f asgnmt
2176: WHERE per.business_group_id = v_bg_id
2177: AND ppt.business_group_id = per.business_group_id
2178: AND usg.person_type_id = ppt.person_type_id
2179: AND usg.person_id = per.person_id

Line 2187: per_assignments_f assign

2183: OR ( ppt.system_person_type IN ('EX_EMP')
2184: AND EXISTS (
2185: SELECT 1
2186: FROM per_periods_of_service perd,
2187: per_assignments_f assign
2188: WHERE perd.person_id = per.person_id
2189: AND perd.final_process_date >
2190: v_period_start_date
2191: AND assign.person_id = per.person_id