APPS.POS_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;

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

316: * PURPOSE
317: * Resolves the buyer name.
318: *
319: * ARGUMENTS
320: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.
321: *
322: * NOTES
323: * Return NULL if no matching records were found.
324: *

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

4941: * PURPOSE
4942: * Resolves the requestor name.
4943: *
4944: * ARGUMENTS
4945: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.
4946: *
4947: * NOTES
4948: * Return NULL if no matching records were found.
4949: *

Line 4956: v_full_name per_people_f.full_name%TYPE;

4952: ********************************************************************/
4953: FUNCTION get_requestor( p_agent_id IN NUMBER )
4954: RETURN VARCHAR2 AS
4955:
4956: v_full_name per_people_f.full_name%TYPE;
4957: v_progress varchar2(3);
4958:
4959: BEGIN
4960:

Line 4965: FROM per_people_f

4961: v_progress := '111';
4962:
4963: SELECT full_name
4964: INTO v_full_name
4965: FROM per_people_f
4966: WHERE person_id = p_agent_id and rownum = 1
4967: order by effective_start_date desc ;
4968:
4969: RETURN v_full_name;

Line 5055: v_full_name per_people_f.full_name%TYPE;

5051: ********************************************************************/
5052: FUNCTION get_owner( p_work_approver_id IN NUMBER )
5053: RETURN VARCHAR2 AS
5054:
5055: v_full_name per_people_f.full_name%TYPE;
5056: v_progress varchar2(3);
5057:
5058: BEGIN
5059:

Line 5064: from PER_PEOPLE_F --hr_employees_current_v

5060: v_progress := '111';
5061:
5062: select hecv.full_name
5063: INTO v_full_name
5064: from PER_PEOPLE_F --hr_employees_current_v
5065: hecv, fnd_user fu
5066: where fu.user_id = p_work_approver_id and
5067: fu.employee_id = hecv.person_id (+) --employee_id (+)
5068: and rownum = 1