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 1768: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg

1764: end if;
1765:
1766: begin
1767: SELECT person_id into xPersonId FROM (
1768: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1769: WHERE asg.position_id = approvers(i).orig_system_id and trunc(sysdate) between person.effective_start_date
1770: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1771: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1772: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 2128: FROM PER_ALL_ASSIGNMENTS_F

2124: elsif (approversTableIn(i).orig_system = ame_util.posOrigSystem) then
2125:
2126: SELECT POSITION_ID
2127: INTO l_preparer_pos_id
2128: FROM PER_ALL_ASSIGNMENTS_F
2129: WHERE PERSON_ID = l_preparer_id
2130: and primary_flag = 'Y'
2131: and assignment_type in ('E','C')
2132: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

Line 2252: FROM per_all_assignments_f

2248:
2249: -- retrieve the position name. if the position name is null check for the job name.
2250:
2251: SELECT position_id, job_id INTO l_position_id, l_job_id
2252: FROM per_all_assignments_f
2253: WHERE person_id = l_person_id
2254: and primary_flag = 'Y' and assignment_type in ('E','C')
2255: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2256: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)

Line 2630: FROM per_all_assignments_f

2626: end if;
2627:
2628: -- retrieve the position name. if the position name is null check for the job name.
2629: SELECT position_id, job_id INTO l_position_id, l_job_id
2630: FROM per_all_assignments_f
2631: WHERE person_id = p_approver_id
2632: and primary_flag = 'Y' and assignment_type in ('E','C')
2633: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')
2634: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)

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

3030: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
3031:
3032: else
3033: SELECT person_id, full_name into l_person_id,l_full_name FROM (
3034: SELECT person.person_id, person.full_name FROM per_all_people_f person, per_all_assignments_f asg
3035: WHERE asg.position_id = l_orig_system_id and trunc(sysdate) between person.effective_start_date
3036: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3037: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
3038: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )

Line 3095: FROM per_all_assignments_f

3091: -- bug #15883770 relax the condition on employee assignment, that is
3092: -- to allow user to view the approval list regardless the current
3093: -- employee status (Employee, Ex-employee , etc..) for approved requisition
3094: SELECT position_id, job_id INTO l_position_id, l_job_id
3095: FROM per_all_assignments_f
3096: WHERE person_id = l_person_id
3097: and (l_authorizationStatus = 'APPROVED'
3098: or (primary_flag = 'Y' and assignment_type in ('E','C')
3099: and assignment_status_type_id not in ( select assignment_status_type_id from per_assignment_status_types where per_system_status = 'TERM_ASSIGN')

Line 3388: FROM per_all_people_f person, per_all_assignments_f asg

3384: SELECT person_id, full_name
3385: into x_personId, x_fullName
3386: FROM (
3387: SELECT person.person_id, person.full_name
3388: FROM per_all_people_f person, per_all_assignments_f asg
3389: WHERE asg.position_id = p_origSystemId
3390: and trunc(sysdate) between person.effective_start_date
3391: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
3392: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')