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_AUTOCREATE_DOC dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 1970: from po_agents poa, per_people_f ppf, financials_system_parameters fsp

1966: per_people_f also and also introduced TRUNC function */
1967:
1968: select agent_id
1969: into x_agent_id
1970: from po_agents poa, per_people_f ppf, financials_system_parameters fsp
1971: where poa.agent_id = ppf.person_id
1972: and ppf.business_group_id = fsp.business_group_id
1973: and trunc(sysdate) between ppf.effective_start_date
1974: and nvl(ppf.effective_end_date, sysdate+1)

Line 6890: financials_system_parameters fsp

6886: SELECT 'Y'
6887: INTO l_return_status
6888: FROM po_headers_all poh,
6889: per_people_f ppf,
6890: financials_system_parameters fsp
6891: WHERE poh.agent_id = ppf.person_id
6892: AND ppf.business_group_id = fsp.business_group_id
6893: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date
6894: AND NVL (ppf.effective_end_date, SYSDATE + 1)

Line 7002: financials_system_parameters fsp

6998: SELECT 'Y'
6999: INTO l_return_status
7000: FROM po_headers_all poh,
7001: per_people_f ppf,
7002: financials_system_parameters fsp
7003: WHERE poh.agent_id = ppf.person_id
7004: AND ppf.business_group_id = fsp.business_group_id
7005: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date
7006: AND NVL(ppf.effective_end_date, SYSDATE + 1)