APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_SESSIONS

Line 263: FROM FND_SESSIONS

259:
260:
261: Cursor C_session is
262: SELECT effective_date
263: FROM FND_SESSIONS
264: WHERE session_id = USERENV('sessionid');
265:
266: Cursor C_grade_spine is
267: SELECT grade_spine_id

Line 6475: -- fnd_sessions to get req_data_as_of_date.

6471: l_assignment_rec_no := 0;
6472: l_assignment_exists := FALSE;
6473:
6474: -- Bug # 4886277: Used psb_data_extracts instead of
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,

Line 6500: -- fnd_sessions to get req_data_as_of_date.

6496: END LOOP;
6497:
6498: IF NOT l_assignment_exists THEN
6499: -- Bug # 4886277: Used psb_data_extracts instead of
6500: -- fnd_sessions to get req_data_as_of_date.
6501: FOR l_hr_position_rec IN
6502: (SELECT a.effective_start_date,
6503: a.effective_end_date
6504: FROM hr_all_positions_f a,

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 7000: AND not exists (select fs.session_id from fnd_sessions fs

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
6999: AND paf.person_id=pe.hr_employee_id
7000: AND not exists (select fs.session_id from fnd_sessions fs
7001: where fs.effective_date between paf.effective_start_date
7002: and paf.effective_end_date
7003: and fs.session_id=USERENV('sessionid') )
7004: AND paf.assignment_type='E'