DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_DOC dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 2189: financials_system_parameters fsp

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
2193: and nvl(ppf.effective_end_date, sysdate+1)

Line 7342: financials_system_parameters fsp

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
7346: AND NVL (ppf.effective_end_date, SYSDATE + 1)

Line 7455: financials_system_parameters fsp

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
7459: AND NVL(ppf.effective_end_date, SYSDATE + 1)