APPS.PO_AUTOCREATE_DOC dependencies on PO_AGENTS

Line 1923: po_agents as po_agents is not striped. But if that profile is set to No,

1919: /* Bug - 1895237
1920:
1921: /* Get the buyer from the buyers table.
1922: If the HR profile Cross Business Groups is set to 'Y' , get it from
1923: po_agents as po_agents is not striped. But if that profile is set to No,
1924: then get only buyers for that business group. */
1925:
1926:
1927: If (nvl(hr_general.get_xbg_profile, 'N') = 'Y') then

Line 1932: from po_agents

1928:
1929: begin
1930: select agent_id
1931: into x_agent_id
1932: from po_agents
1933: where category_id = x_category_id
1934: and trunc(sysdate) between start_date_active
1935: and nvl(end_date_active, sysdate+1);
1936:

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 5004: * The agent_id in the po_agents table has the same value as the employee_id

5000: *
5001: * Call po_req_approval_init1.get_user_name which then calls
5002: * wf.GetUserName to get the info.
5003: *
5004: * The agent_id in the po_agents table has the same value as the employee_id
5005: * in the HR_EMPLOYEES view for the corresponding employee so we can pass in
5006: * agent_id
5007: */
5008: