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.HR_UTIL_MISC_SS dependencies on PER_ASSIGNMENTS_F

Line 521: FROM per_assignments_f2 paf, per_assignment_status_types past

517:
518:
519: cursor fetch_asg (l_person_id NUMBER, l_effective_date DATE) is
520: SELECT 'T'
521: FROM per_assignments_f2 paf, per_assignment_status_types past
522: WHERE paf.person_id = l_person_id
523: AND l_effective_date between paf.effective_start_date and paf.effective_end_date
524: AND paf.primary_flag = 'Y'
525: AND paf.assignment_type IN ('E', 'C')

Line 1329: from per_people_f ppf, per_assignments_f paf

1325: hr_utility.set_location('Entering: '|| l_proc,5);
1326:
1327: select assignment_id
1328: into assi_id
1329: from per_people_f ppf, per_assignments_f paf
1330: where paf.person_id = ppf.person_id
1331: and trunc(sysdate) between paf.effective_start_date(+) and paf.effective_end_date(+)
1332: and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+)
1333: and ppf.person_id = p_person_id

Line 1950: l_entity_name := 'PER_ASSIGNMENTS_F';

1946: l_api_name = 'HR_PAY_RATE_SS.PROCESS_API' OR
1947: l_api_name = 'PER_SSHR_CHANGE_PAY.PROCESS_API' OR --fix for bug 11065050
1948: l_api_name = 'BEN_PROCESS_COMPENSATION_W.PROCESS_API') then --fix for bug 14277455
1949:
1950: l_entity_name := 'PER_ASSIGNMENTS_F';
1951: l_pk_value := trans_row.assignment_id;
1952:
1953: elsif(l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API' OR
1954: l_api_name = 'HR_PROCESS_SIT_SS.PROCESS_API' OR