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 902: per_all_assignments_f assign ,

898: v_period_start_date IN DATE,
899: v_period_end_date IN DATE)
900: IS
901: SELECT DISTINCT(assignment_id) , assignment_number FROM
902: per_all_assignments_f assign ,
903: PER_ASSIGNMENT_STATUS_TYPES status
904: WHERE assignment_type IN ('B','C','E')
905: AND assign.person_id = v_person_id
906: AND nvl(status.business_group_id,assign.business_group_id) = assign.business_group_id

Line 2172: per_all_assignments_f paaf

2168:
2169: SELECT DISTINCT papf.person_id
2170: --- ,papf.full_name name 9702694
2171: FROM per_all_people_f papf,
2172: per_all_assignments_f paaf
2173: WHERE papf.business_group_id = v_bg_id
2174: AND EXISTS (
2175: SELECT 'x'
2176: FROM per_person_type_usages_f ptu, per_person_types ppt

Line 2263: per_all_assignments_f paaf

2259: )
2260: IS
2261: SELECT DISTINCT papf.person_id ----, papf.full_name NAME 9702694
2262: FROM per_all_people_f papf,
2263: per_all_assignments_f paaf
2264: WHERE papf.person_id = v_person_id
2265: AND EXISTS (
2266: SELECT 'x'
2267: FROM per_person_type_usages_f ptu, per_person_types ppt