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_PEOPLE_F

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 2047: l_full_name per_all_people_f.full_name%TYPE;

2043:
2044: l_api_name varchar2(50):= 'serializeApproversTable';
2045: upperLimit integer;
2046:
2047: l_full_name per_all_people_f.full_name%TYPE;
2048: l_person_id per_all_people_f.person_id%TYPE;
2049: l_job_or_position VARCHAR2(2000);
2050: l_orig_system VARCHAR2(30);
2051: l_orig_system_id NUMBER;

Line 2048: l_person_id per_all_people_f.person_id%TYPE;

2044: l_api_name varchar2(50):= 'serializeApproversTable';
2045: upperLimit integer;
2046:
2047: l_full_name per_all_people_f.full_name%TYPE;
2048: l_person_id per_all_people_f.person_id%TYPE;
2049: l_job_or_position VARCHAR2(2000);
2050: l_orig_system VARCHAR2(30);
2051: l_orig_system_id NUMBER;
2052:

Line 2617: SELECT email_address INTO x_email FROM per_all_people_f

2613: x_title := null;
2614: x_email := null;
2615:
2616: -- first get the email id.
2617: SELECT email_address INTO x_email FROM per_all_people_f
2618: WHERE person_id = p_approver_id
2619: AND TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2620: AND rownum = 1;
2621:

Line 2757: l_full_name per_all_people_f.full_name%TYPE;

2753:
2754: approverList ame_util.approversTable2;
2755: l_process_out VARCHAR2(10);
2756:
2757: l_full_name per_all_people_f.full_name%TYPE;
2758: l_person_id per_all_people_f.person_id%TYPE;
2759: l_job_or_position VARCHAR2(2000);
2760: l_orig_system VARCHAR2(30);
2761: l_orig_system_id NUMBER;

Line 2758: l_person_id per_all_people_f.person_id%TYPE;

2754: approverList ame_util.approversTable2;
2755: l_process_out VARCHAR2(10);
2756:
2757: l_full_name per_all_people_f.full_name%TYPE;
2758: l_person_id per_all_people_f.person_id%TYPE;
2759: l_job_or_position VARCHAR2(2000);
2760: l_orig_system VARCHAR2(30);
2761: l_orig_system_id NUMBER;
2762:

Line 3028: FROM per_all_people_f

3024: l_person_id := l_first_approver_id;
3025:
3026: SELECT full_name
3027: INTO l_full_name
3028: FROM per_all_people_f
3029: WHERE person_id = l_first_approver_id
3030: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
3031:
3032: else

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 3379: FROM per_all_people_f

3375: x_personId := l_first_approver_id;
3376:
3377: SELECT full_name
3378: INTO x_fullName
3379: FROM per_all_people_f
3380: WHERE person_id = l_first_approver_id
3381: AND trunc(sysdate) between effective_start_date and effective_end_date;
3382:
3383: else

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')