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.POR_AME_APPROVAL_LIST dependencies on PER_ALL_ASSIGNMENTS_F

Line 240: SELECT position_id into tmpApprover.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa

236: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'First record is of type Position Hierarchy...' );
237: END IF;
238: end if;
239: tmpApprover.orig_system := ame_util.posOrigSystem;
240: SELECT position_id into tmpApprover.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
241: WHERE pa.person_id = pPersonId and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
242: and pa.position_id is not null and pa.assignment_status_type_id not in (
243: select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
244: and TRUNC ( pa.effective_start_date )

Line 1703: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

1699: end if;
1700:
1701: begin
1702: SELECT person_id into xPersonId FROM (
1703: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1704: WHERE asg.position_id = approvers(i).orig_system_id and trunc(sysdate) between person.effective_start_date
1705: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1706: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1707: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 2059: FROM PER_ALL_ASSIGNMENTS_F

2055: elsif (approversTableIn(i).orig_system = ame_util.posOrigSystem) then
2056:
2057: SELECT POSITION_ID
2058: INTO l_preparer_pos_id
2059: FROM PER_ALL_ASSIGNMENTS_F
2060: WHERE PERSON_ID = l_preparer_id
2061: and primary_flag = 'Y'
2062: and assignment_type in ('E','C')
2063: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

Line 2182: FROM per_all_assignments_f

2178:
2179: -- retrieve the position name. if the position name is null check for the job name.
2180:
2181: SELECT position_id, job_id INTO l_position_id, l_job_id
2182: FROM per_all_assignments_f
2183: WHERE person_id = l_person_id
2184: and primary_flag = 'Y' and assignment_type in ('E','C')
2185: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2186: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)

Line 2560: FROM per_all_assignments_f

2556: end if;
2557:
2558: -- retrieve the position name. if the position name is null check for the job name.
2559: SELECT position_id, job_id INTO l_position_id, l_job_id
2560: FROM per_all_assignments_f
2561: WHERE person_id = p_approver_id
2562: and primary_flag = 'Y' and assignment_type in ('E','C')
2563: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2564: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)

Line 2964: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg

2960: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
2961:
2962: else
2963: SELECT person_id, full_name into l_person_id,l_full_name FROM (
2964: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
2965: WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
2966: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
2967: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
2968: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 3022: FROM per_all_assignments_f

3018:
3019: -- retrieve the position name. if the position name is null check for the job name.
3020:
3021: SELECT position_id, job_id INTO l_position_id, l_job_id
3022: FROM per_all_assignments_f
3023: WHERE person_id = l_person_id
3024: and primary_flag = 'Y' and assignment_type in ('E','C')
3025: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
3026: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)

Line 3312: FROM per_all_people_f person, per_all_assignments_f asg

3308: SELECT person_id, full_name
3309: into x_personId, x_fullName
3310: FROM (
3311: SELECT person.person_id, person.full_name
3312: FROM per_all_people_f person, per_all_assignments_f asg
3313: WHERE asg.position_id = p_origSystemId
3314: and trunc(sysdate) between person.effective_start_date
3315: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3316: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')