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 4939: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.

4935: * PURPOSE
4936: * Resolves the requestor name.
4937: *
4938: * ARGUMENTS
4939: * p_agent_id Unique identifier for buyer in PER_PEOPLE_F table.
4940: *
4941: * NOTES
4942: * Return NULL if no matching records were found.
4943: *

Line 4950: v_full_name per_people_f.full_name%TYPE;

4946: ********************************************************************/
4947: FUNCTION get_requestor( p_agent_id IN NUMBER )
4948: RETURN VARCHAR2 AS
4949:
4950: v_full_name per_people_f.full_name%TYPE;
4951: v_progress varchar2(3);
4952:
4953: BEGIN
4954:

Line 4959: FROM per_people_f

4955: v_progress := '111';
4956:
4957: SELECT full_name
4958: INTO v_full_name
4959: FROM per_people_f
4960: WHERE person_id = p_agent_id and rownum = 1
4961: order by effective_start_date desc ;
4962:
4963: RETURN v_full_name;

Line 5049: v_full_name per_people_f.full_name%TYPE;

5045: ********************************************************************/
5046: FUNCTION get_owner( p_work_approver_id IN NUMBER )
5047: RETURN VARCHAR2 AS
5048:
5049: v_full_name per_people_f.full_name%TYPE;
5050: v_progress varchar2(3);
5051:
5052: BEGIN
5053:

Line 5058: from PER_PEOPLE_F --hr_employees_current_v

5054: v_progress := '111';
5055:
5056: select hecv.full_name
5057: INTO v_full_name
5058: from PER_PEOPLE_F --hr_employees_current_v
5059: hecv, fnd_user fu
5060: where fu.user_id = p_work_approver_id and
5061: fu.employee_id = hecv.person_id (+) --employee_id (+)
5062: and rownum = 1