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_ASSIGNMENT_STATUS_TYPES

Line 196: per_assignment_status_types past --bug 4020452

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')
198: AND fs.effective_date between pp.effective_start_date
199: and pp.effective_end_date
200: AND pp.business_group_id = p_business_group_id

Line 276: -- bug 3777146 added the join with per_assignment_status_types

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
280: and pafx.effective_end_date

Line 277: per_assignment_status_types past

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
280: and pafx.effective_end_date
281: AND pafx.assignment_status_type_id

Line 297: per_assignment_status_types past

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
301: and paf.effective_end_date

Line 298: -- bug 4020452 added the join with per_assignment_status_types

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
301: and paf.effective_end_date
302: AND paf.assignment_status_type_id

Line 396: from per_assignment_status_types

392: --
393: /* Bug 4929586 commenting out the below cursor
394: Cursor l_assign_stat_csr is
395: Select assignment_status_type_id
396: from per_assignment_status_types
397: where (business_group_id = p_business_group_id
398: or business_group_id is null)
399: and PER_SYSTEM_STATUS = 'TERM_ASSIGN'; */
400: --

Line 1833: from per_assignment_status_types

1829:
1830: /* Bug 4929586 commenting out the below cursor
1831: Cursor l_assign_stat_csr is
1832: Select assignment_status_type_id
1833: from per_assignment_status_types
1834: where (business_group_id = p_business_group_id
1835: or business_group_id is null)
1836: and PER_SYSTEM_STATUS = 'TERM_ASSIGN'; */
1837: --

Line 4672: per_assignment_status_types past

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
4676: AND paf.position_id = l_pos_id

Line 5791: per_assignment_status_types c

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
5794: AND c.per_system_status = 'TERM_ASSIGN'
5795: AND b.effective_date BETWEEN a.effective_start_date

Line 5889: per_assignment_status_types c

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
5892: AND c.per_system_status = 'TERM_ASSIGN'
5893: AND b.effective_date BETWEEN a.effective_start_date