DBA Data[Home] [Help]

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_SHARED_TYPES

Line 192: per_shared_types pst ,

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,
196: per_assignment_status_types past --bug 4020452

Line 258: per_shared_types pst

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
262: AND pp.business_group_id = p_business_group_id

Line 472: from per_shared_types

468: -- End bug no 3902996
469:
470: -- Process all the positions (filled and vacant both).
471: SELECT count(*) into l_status_count
472: from per_shared_types
473: where business_group_id = p_business_group_id
474: and system_type_cd in ('PROPOSED','ACTIVE', 'FROZEN');
475:
476: /* Bug 4929586