APPS.PO_AUTOCREATE_DOC dependencies on PER_PEOPLE_F

Line 2183: per_people_f also and also introduced TRUNC function */

2179:
2180: begin
2181:
2182: /* Bug - 1915033 - Added the effectivity dates condition for
2183: per_people_f also and also introduced TRUNC function */
2184:
2185: select agent_id
2186: into x_agent_id
2187: from po_agents poa,

Line 2188: per_all_people_f ppf, --Bug 16249921. Changed per_people_f to per_all_people_f

2184:
2185: select agent_id
2186: into x_agent_id
2187: from po_agents poa,
2188: per_all_people_f ppf, --Bug 16249921. Changed per_people_f to per_all_people_f
2189: financials_system_parameters fsp
2190: where poa.agent_id = ppf.person_id
2191: and ppf.business_group_id = fsp.business_group_id
2192: and trunc(sysdate) between ppf.effective_start_date

Line 6372: l_approver_disp_name per_people_f.full_name%TYPE;

6368: l_user_id NUMBER;
6369: l_application_id NUMBER;
6370: -- bug 5657496 variable addition
6371: --
6372: l_approver_disp_name per_people_f.full_name%TYPE;
6373: l_approver_user_name fnd_user.user_name%TYPE;
6374: --
6375:
6376: begin

Line 6485: from per_people_f pr

6481: l_preparer_disp_name);
6482: --
6483: /*select pr.FULL_NAME
6484: into l_agent_name
6485: from per_people_f pr
6486: where pr.person_id = p_agent_id
6487: and trunc(sysdate) between pr.effective_start_date
6488: and pr.effective_end_date;*/
6489:

Line 7341: per_all_people_f ppf, --Bug 16249921. Changed per_people_f ppf to per_all_people_f

7337:
7338: SELECT 'Y'
7339: INTO l_return_status
7340: FROM po_headers_all poh,
7341: per_all_people_f ppf, --Bug 16249921. Changed per_people_f ppf to per_all_people_f
7342: financials_system_parameters fsp
7343: WHERE poh.agent_id = ppf.person_id
7344: AND ppf.business_group_id = fsp.business_group_id
7345: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date

Line 7453: per_all_people_f ppf,----Bug16249921 Changed per_people_f to per_all_people_f

7449: BEGIN
7450: SELECT 'Y'
7451: INTO l_return_status
7452: FROM po_headers_all poh,
7453: per_all_people_f ppf,----Bug16249921 Changed per_people_f to per_all_people_f
7454: --as per_people_f is security profile restricted.
7455: financials_system_parameters fsp
7456: WHERE poh.agent_id = ppf.person_id
7457: AND ppf.business_group_id = fsp.business_group_id

Line 7454: --as per_people_f is security profile restricted.

7450: SELECT 'Y'
7451: INTO l_return_status
7452: FROM po_headers_all poh,
7453: per_all_people_f ppf,----Bug16249921 Changed per_people_f to per_all_people_f
7454: --as per_people_f is security profile restricted.
7455: financials_system_parameters fsp
7456: WHERE poh.agent_id = ppf.person_id
7457: AND ppf.business_group_id = fsp.business_group_id
7458: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date