eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 193: per_all_assignments_f paf ,

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
197: WHERE fs.session_id = userenv('sessionid')

Line 275: FROM per_all_assignments_f pafx,

271: -- AND pst.system_type_cd in ('PROPOSED','ACTIVE','FROZEN')
272: AND pst.system_type_cd in ('PROPOSED','ACTIVE')
273: AND ( (NOT EXISTS
274: ( SELECT 1
275: FROM per_all_assignments_f pafx,
276: -- bug 3777146 added the join with per_assignment_status_types
277: per_assignment_status_types past
278: WHERE fs.session_id = userenv('sessionid')
279: AND fs.effective_date between pafx.effective_start_date

Line 296: per_all_assignments_f paf,

292: AND
293: ( nvl(pp.fte,1) >
294: ( SELECT sum(nvl(value,1))
295: FROM per_assignment_budget_values_f pab,
296: per_all_assignments_f paf,
297: per_assignment_status_types past
298: -- bug 4020452 added the join with per_assignment_status_types
299: WHERE fs.session_id = userenv('sessionid')
300: AND fs.effective_date between paf.effective_start_date

Line 1700: per_all_assignments_f paf,

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,
1703: per_pay_bases ppb
1704: WHERE fs.session_id = userenv('sessionid')

Line 2312: from fnd_sessions fs, per_all_assignments_f paf,

2308: paf.pay_basis_id,
2309: pcaf.cost_allocation_keyflex_id,
2310: pcaf.effective_start_date,
2311: pcaf.effective_end_date
2312: from fnd_sessions fs, per_all_assignments_f paf,
2313: pay_cost_allocations_f pcaf,
2314: pay_cost_allocation_keyflex pcak
2315: where fs.session_id = userenv('sessionid')
2316: and fs.effective_date between paf.effective_start_date and paf.effective_end_date

Line 2341: from fnd_sessions fs, per_all_assignments_f paf

2337: paf.pay_basis_id,
2338: to_number(null),
2339: to_date(null),
2340: to_date(null)
2341: from fnd_sessions fs, per_all_assignments_f paf
2342: where fs.session_id = userenv('sessionid')
2343: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2344: and paf.business_group_id = p_business_group_id
2345: and paf.payroll_id > l_restart_payroll_id

Line 2855: per_all_assignments_f paf

2851: Cursor C_Element_Type is
2852: Select element_type_id
2853: from fnd_sessions fs, pay_input_values piv,
2854: per_pay_bases ppb,
2855: per_all_assignments_f paf
2856: where fs.session_id = userenv('sessionid')
2857: and fs.effective_date between paf.effective_start_date and paf.effective_end_date
2858: and paf.assignment_id = p_assignment_id
2859: and ppb.pay_basis_id = paf.pay_basis_id

Line 4399: --replaced per_all_assignments with per_all_assignments_f and added datetrack logic

4395: /*For Bug No : 2370607 Start*/
4396: --changed the a.working_hours, a.frequency to
4397: -- decode statements
4398: /*For Bug No : 2642012 Start*/
4399: --replaced per_all_assignments with per_all_assignments_f and added datetrack logic
4400: --and also added c.hr_position_name into the cursor select part
4401:
4402: Cursor C_Employees is
4403: Select b.person_id,b.assignment_id,a.position_id,

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 4671: per_all_assignments_f paf,

4667: CURSOR C_check_FTE(l_pos_id NUMBER) IS
4668: SELECT sum(nvl(value,1)) sum_fte
4669: FROM fnd_sessions fs,
4670: per_assignment_budget_values pab,
4671: per_all_assignments_f paf,
4672: per_assignment_status_types past
4673: WHERE fs.session_id = userenv('sessionid')
4674: AND fs.effective_date between paf.effective_start_date
4675: and paf.effective_end_date

Line 5789: FROM per_all_assignments_f a,

5785: FOR l_date_rec IN (
5786: SELECT effective_start_date
5787: FROM (
5788: SELECT a.effective_start_date
5789: FROM per_all_assignments_f a,
5790: fnd_sessions b,
5791: per_assignment_status_types c
5792: WHERE a.position_id = Employee_rec.position_id
5793: AND a.assignment_status_type_id = c.assignment_status_type_id

Line 5887: FROM per_all_assignments_f a,

5883:
5884: FOR l_date_rec IN ( SELECT effective_start_date
5885: FROM (
5886: SELECT a.effective_start_date
5887: FROM per_all_assignments_f a,
5888: fnd_sessions b,
5889: per_assignment_status_types c
5890: WHERE a.position_id = Employee_rec.position_id
5891: AND a.assignment_status_type_id = c.assignment_status_type_id