APPS.BEN_TCS_STMT_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 170: FROM per_jobs_tl jobs , per_all_assignments_f assign,

166:
167: IF ( p_assignment_id IS NOT NULL) THEN
168: SELECT jobs.name
169: INTO p_job
170: FROM per_jobs_tl jobs , per_all_assignments_f assign,
171: ( SELECT assignment.assignment_id , max(assignment.effective_end_date)end_date
172: FROM per_all_assignments_f assignment
173: WHERE assignment.assignment_id = p_assignment_id GROUP BY assignment_id) b
174: WHERE

Line 172: FROM per_all_assignments_f assignment

168: SELECT jobs.name
169: INTO p_job
170: FROM per_jobs_tl jobs , per_all_assignments_f assign,
171: ( SELECT assignment.assignment_id , max(assignment.effective_end_date)end_date
172: FROM per_all_assignments_f assignment
173: WHERE assignment.assignment_id = p_assignment_id GROUP BY assignment_id) b
174: WHERE
175: assign.effective_end_date = b.end_date
176: AND assign.assignment_id = b.assignment_id

Line 894: per_all_assignments_f assign ,

890: v_period_start_date IN DATE,
891: v_period_end_date IN DATE)
892: IS
893: SELECT DISTINCT(assignment_id) , assignment_number FROM
894: per_all_assignments_f assign ,
895: PER_ASSIGNMENT_STATUS_TYPES status
896: WHERE assignment_type IN ('B','C','E')
897: AND assign.person_id = v_person_id
898: AND nvl(status.business_group_id,assign.business_group_id) = assign.business_group_id

Line 2270: select 1 from per_periods_of_service perd ,per_all_assignments_f assign where perd.person_id =

2266: and usg.effective_end_date >= ppl.effective_end_date
2267: AND (ppt.SYSTEM_PERSON_TYPE in ('EMP' ,'CWK') OR
2268: ( ppt.SYSTEM_PERSON_TYPE in ('EX_EMP' ) and
2269: exists (
2270: select 1 from per_periods_of_service perd ,per_all_assignments_f assign where perd.person_id =
2271: v_person_id
2272: AND perd.final_process_date > v_period_st_dt
2273: AND assign.person_id = ppl.person_id
2274: AND assign.effective_end_date > v_period_st_dt