APPS.PO_AUTOCREATE_DOC dependencies on PO_AGENTS

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

2136: /* Bug - 1895237
2137:
2138: /* Get the buyer from the buyers table.
2139: If the HR profile Cross Business Groups is set to 'Y' , get it from
2140: po_agents as po_agents is not striped. But if that profile is set to No,
2141: then get only buyers for that business group. */
2142:
2143:
2144: If (nvl(hr_general.get_xbg_profile, 'N') = 'Y') then

Line 2149: from po_agents

2145:
2146: begin
2147: select agent_id
2148: into x_agent_id
2149: from po_agents
2150: where category_id = x_category_id
2151: and trunc(sysdate) between start_date_active
2152: and nvl(end_date_active, sysdate+1);
2153:

Line 2187: from po_agents poa,

2183: per_people_f also and also introduced TRUNC function */
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

Line 5342: * The agent_id in the po_agents table has the same value as the employee_id

5338: *
5339: * Call po_req_approval_init1.get_user_name which then calls
5340: * wf.GetUserName to get the info.
5341: *
5342: * The agent_id in the po_agents table has the same value as the employee_id
5343: * in the HR_EMPLOYEES view for the corresponding employee so we can pass in
5344: * agent_id
5345: */
5346: