APPS.PO_COMPARE_REVISIONS dependencies on PER_PEOPLE_F

Line 267: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.

263: * PURPOSE
264: * Resolves the buyer name.
265: *
266: * ARGUMENTS
267: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.
268: *
269: * NOTES
270: * Return NULL if no matching records were found.
271: *

Line 279: v_full_name per_people_f.full_name%TYPE;

275: ********************************************************************/
276: FUNCTION get_buyer( p_agent_id IN NUMBER )
277: RETURN VARCHAR2 AS
278:
279: v_full_name per_people_f.full_name%TYPE;
280: v_progress varchar2(3);
281:
282: BEGIN
283:

Line 292: FROM per_people_f

288: -- Bug 2111528 Added condition to get buyers with current effective
289: -- date
290: SELECT distinct full_name
291: INTO v_full_name
292: FROM per_people_f
293: WHERE person_id = p_agent_id
294: and TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE ;
295:
296: RETURN v_full_name;