APPS.PSB_HR_POPULATE_DATA_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 6479: FROM per_all_assignments_f a,

6475: -- fnd_sessions to get req_data_as_of_date.
6476: FOR l_assignment_rec IN
6477: (SELECT a.effective_start_date,
6478: a.effective_end_date
6479: FROM per_all_assignments_f a,
6480: psb_data_extracts b
6481: WHERE a.position_id =l_position_i_cache(i).hr_position_id
6482: AND a.person_id = l_position_i_cache(i).hr_employee_id
6483: AND b.data_extract_id = p_data_extract_id

Line 6975: per_all_assignments_f paf

6971: /*Modified the cursor for Bug#4166493, to take care of date tracked HR data*/
6972: CURSOR C_Terminated_Employees IS
6973: SELECT distinct position_assignment_id,pp.position_id,pe.hr_employee_id
6974: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,
6975: per_all_assignments_f paf
6976: WHERE ppa.position_id=pp.position_id
6977: AND ppa.data_extract_id=p_data_extract_id
6978: AND pp.hr_position_id > l_restart_hr_position_id
6979: AND paf.position_id=pp.hr_position_id

Line 6983: from per_all_assignments_f paf2,fnd_sessions fs

6979: AND paf.position_id=pp.hr_position_id
6980: AND paf.person_id=pe.hr_employee_id
6981: AND paf.person_id not in
6982: (select person_id
6983: from per_all_assignments_f paf2,fnd_sessions fs
6984: where fs.effective_date between paf2.effective_start_date
6985: and paf2.effective_end_date
6986: and assignment_type='E' and position_id=paf.position_id
6987: and fs.session_id=USERENV('sessionid'))

Line 6994: per_all_assignments_f paf

6990: AND ppa.assignment_type='EMPLOYEE';
6991:
6992: /* SELECT distinct position_assignment_id,pp.position_id,pe.hr_employee_id
6993: FROM psb_position_assignments ppa,psb_positions pp,psb_employees pe,
6994: per_all_assignments_f paf
6995: WHERE ppa.position_id=pp.position_id
6996: AND ppa.data_extract_id=p_data_extract_id
6997: AND pp.hr_position_id > l_restart_hr_position_id
6998: AND paf.position_id=pp.hr_position_id