APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PSB_POSITIONS_I

Line 752: INSERT INTO PSB_POSITIONS_I

748: end if;
749:
750: End Loop;
751:
752: INSERT INTO PSB_POSITIONS_I
753: (
754: DATA_EXTRACT_ID ,
755: BUSINESS_GROUP_ID ,
756: HR_POSITION_ID ,

Line 1698: psb_positions_i pp,

1694: ppb.rate_id
1695: FROM fnd_sessions fs,
1696: /* Start bug #4128475 */
1697: -- psb_positions,
1698: psb_positions_i pp,
1699: /* End bug #4128475 */
1700: per_all_assignments_f paf,
1701: per_all_people_f ppf,
1702: pay_all_payrolls_f ppay,

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