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.PO_EMAIL_GENERATE dependencies on PER_ALL_PEOPLE_F

Line 129: l_phone per_all_people_f.work_telephone%TYPE;

125: l_requestor_name po_distributions_print.requestor_name%TYPE;
126: l_requestor_id po_distributions_print.requestor_id%TYPE;
127:
128: /* Bug 2870932 increased the size */
129: l_phone per_all_people_f.work_telephone%TYPE;
130: l_email_address per_all_people_f.email_address%TYPE;
131: /* End of Bug 2870932 */
132:
133: l_requestor_count NUMBER := 0;

Line 130: l_email_address per_all_people_f.email_address%TYPE;

126: l_requestor_id po_distributions_print.requestor_id%TYPE;
127:
128: /* Bug 2870932 increased the size */
129: l_phone per_all_people_f.work_telephone%TYPE;
130: l_email_address per_all_people_f.email_address%TYPE;
131: /* End of Bug 2870932 */
132:
133: l_requestor_count NUMBER := 0;
134: l_multiple_flag varchar2(1);

Line 1348: from per_all_people_f

1344: begin
1345:
1346: select full_name,work_telephone,email_address
1347: into l_requestor_name,l_phone,l_email_address
1348: from per_all_people_f
1349: where person_id = l_requestor_id
1350: and effective_start_date <= sysdate
1351: and effective_end_date >= sysdate;
1352:

Line 1499: from per_all_people_f

1495: if (l_requestor_id <> 0) then
1496: begin
1497: select full_name,work_telephone,email_address
1498: into l_requestor_name,l_phone,l_email_address
1499: from per_all_people_f
1500: where person_id = l_requestor_id
1501: and effective_start_date <= sysdate
1502: and effective_end_date >= sysdate;
1503: exception

Line 2246: from per_all_people_f

2242: if (l_requestor_id <> 0) then
2243: begin
2244: select full_name,work_telephone,email_address
2245: into l_requestor_name,l_phone,l_email_address
2246: from per_all_people_f
2247: where person_id = l_requestor_id
2248: and effective_start_date <= sysdate
2249: and effective_end_date >= sysdate;
2250: exception

Line 2638: from per_all_people_f

2634: if (l_deliver_to_id <> 0) then
2635: begin
2636: select full_name,work_telephone,email_address
2637: into l_deliver_to_person,l_phone,l_email_address
2638: from per_all_people_f
2639: where person_id = l_deliver_to_id
2640: and effective_start_date <= sysdate
2641: and effective_end_date >= sysdate;
2642: exception

Line 2885: from per_all_people_f

2881: if (l_deliver_to_id <> 0) then
2882: begin
2883: select full_name,work_telephone,email_address
2884: into l_deliver_to_person,l_phone,l_email_address
2885: from per_all_people_f
2886: where person_id = l_deliver_to_id
2887: and effective_start_date <= sysdate
2888: and effective_end_date >= sysdate;
2889: exception

Line 3282: from per_all_people_f --

3278:
3279: if (l_po_revision = 0) then
3280:
3281: select full_name into l_buyer
3282: from per_all_people_f --
3283: where person_id = (select agent_id from po_headers
3284: where po_header_id = to_number(l_po_header_id))
3285: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3286:

Line 3289: from per_all_people_f --

3285: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502
3286:
3287: else
3288: select full_name into l_buyer
3289: from per_all_people_f --
3290: where person_id = (select agent_id from po_headers_archive
3291: where po_header_id = to_number(l_po_header_id) and
3292: revision_num = 0)
3293: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502

Line 3305: from per_all_people_f --

3301:
3302: begin
3303: if (l_po_revision > 0) then
3304: select full_name into l_revision_buyer
3305: from per_all_people_f --
3306: where person_id = (select agent_id from po_headers_archive
3307: where po_header_id = to_number(l_po_header_id) and
3308: revision_num = l_po_revision)
3309: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502

Line 3323: from per_all_people_f --

3319: -- there will be an entry in this table regardless of whether there is a revision
3320: -- or not
3321: begin
3322: select full_name into l_buyer
3323: from per_all_people_f --
3324: where person_id = (select agent_id from po_releases_archive
3325: where po_release_id = to_number(l_document_id) and
3326: revision_num = 0)
3327: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502

Line 3337: from per_all_people_f --

3333:
3334: begin
3335: if (l_po_revision > 0) then
3336: select full_name into l_revision_buyer
3337: from per_all_people_f --
3338: where person_id = (select agent_id from po_releases_archive
3339: where po_release_id = to_number(l_document_id) and
3340: revision_num = l_po_revision)
3341: and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date); --Bug#5161502