DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on PER_ALL_PEOPLE_F

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