APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on HR_ALL_POSITIONS_F

Line 191: hr_all_positions_f pp ,

187: pp.entry_step_id,
188: pp.pay_basis_id,
189: pst.system_type_cd
190: FROM fnd_sessions fs,
191: hr_all_positions_f pp ,
192: per_shared_types pst ,
193: per_all_assignments_f paf ,
194: pay_all_payrolls_f ppay,
195: per_pay_bases ppb,

Line 257: hr_all_positions_f pp ,

253: pp.entry_step_id,
254: pp.pay_basis_id,
255: pst.system_type_cd
256: FROM fnd_sessions fs,
257: hr_all_positions_f pp ,
258: per_shared_types pst
259: WHERE fs.session_id = userenv('sessionid')
260: AND fs.effective_date between pp.effective_start_date
261: and pp.effective_end_date

Line 4417: from fnd_sessions d, per_all_assignments_f b, hr_all_positions_f a , psb_positions_i c, psb_employees_i e

4413: b.effective_start_date,
4414: b.effective_end_date,
4415: a.effective_start_date date_effective,
4416: a.effective_end_date date_end
4417: from fnd_sessions d, per_all_assignments_f b, hr_all_positions_f a , psb_positions_i c, psb_employees_i e
4418: where d.session_id = userenv('sessionid')
4419: and d.effective_date between a.effective_start_date and a.effective_end_date
4420: and d.effective_date between b.effective_start_date and b.effective_end_date
4421: and a.business_group_id = p_business_group_id

Line 4462: from fnd_sessions b , hr_all_positions_f a , psb_positions_i c

4458: to_date(NULL),
4459: to_date(NULL),
4460: a.effective_start_date date_effective,
4461: a.effective_end_date date_end
4462: from fnd_sessions b , hr_all_positions_f a , psb_positions_i c
4463: where b.session_id = userenv('sessionid')
4464: and b.effective_date between a.effective_start_date and a.effective_end_date
4465: and a.business_group_id = p_business_group_id
4466: and a.position_id = c.hr_position_id