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

1978:
1979: l_api_name varchar2(50):= 'serializeApproversTable';
1980: upperLimit integer;
1981:
1982: l_full_name per_all_people_f.full_name%TYPE;
1983: l_person_id per_all_people_f.person_id%TYPE;
1984: l_job_or_position VARCHAR2(2000);
1985: l_orig_system VARCHAR2(3);
1986: l_orig_system_id NUMBER;

Line 1983: l_person_id per_all_people_f.person_id%TYPE;

1979: l_api_name varchar2(50):= 'serializeApproversTable';
1980: upperLimit integer;
1981:
1982: l_full_name per_all_people_f.full_name%TYPE;
1983: l_person_id per_all_people_f.person_id%TYPE;
1984: l_job_or_position VARCHAR2(2000);
1985: l_orig_system VARCHAR2(3);
1986: l_orig_system_id NUMBER;
1987:

Line 2547: SELECT email_address INTO x_email FROM per_all_people_f

2543: x_title := null;
2544: x_email := null;
2545:
2546: -- first get the email id.
2547: SELECT email_address INTO x_email FROM per_all_people_f
2548: WHERE person_id = p_approver_id
2549: AND TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2550: AND rownum = 1;
2551:

Line 2687: l_full_name per_all_people_f.full_name%TYPE;

2683:
2684: approverList ame_util.approversTable2;
2685: l_process_out VARCHAR2(10);
2686:
2687: l_full_name per_all_people_f.full_name%TYPE;
2688: l_person_id per_all_people_f.person_id%TYPE;
2689: l_job_or_position VARCHAR2(2000);
2690: l_orig_system VARCHAR2(3);
2691: l_orig_system_id NUMBER;

Line 2688: l_person_id per_all_people_f.person_id%TYPE;

2684: approverList ame_util.approversTable2;
2685: l_process_out VARCHAR2(10);
2686:
2687: l_full_name per_all_people_f.full_name%TYPE;
2688: l_person_id per_all_people_f.person_id%TYPE;
2689: l_job_or_position VARCHAR2(2000);
2690: l_orig_system VARCHAR2(3);
2691: l_orig_system_id NUMBER;
2692:

Line 2958: FROM per_all_people_f

2954: l_person_id := l_first_approver_id;
2955:
2956: SELECT full_name
2957: INTO l_full_name
2958: FROM per_all_people_f
2959: WHERE person_id = l_first_approver_id
2960: AND TRUNC(sysdate) between effective_start_date and effective_end_date;
2961:
2962: else

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

3299: x_personId := l_first_approver_id;
3300:
3301: SELECT full_name
3302: INTO x_fullName
3303: FROM per_all_people_f
3304: WHERE person_id = l_first_approver_id
3305: AND trunc(sysdate) between effective_start_date and effective_end_date;
3306:
3307: else

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