APPS.PO_AUTOCREATE_DOC dependencies on PER_PEOPLE_F

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

1962:
1963: begin
1964:
1965: /* Bug - 1915033 - Added the effectivity dates condition for
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

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 6058: from per_people_f pr

6054: l_preparer_disp_name);
6055:
6056: select pr.FULL_NAME
6057: into l_agent_name
6058: from per_people_f pr
6059: where pr.person_id = p_agent_id
6060: and trunc(sysdate) between pr.effective_start_date
6061: and pr.effective_end_date;
6062:

Line 6889: per_people_f ppf,

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

Line 7001: per_people_f ppf,

6997: BEGIN
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