APPS.PO_POXSERPR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 6: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;

2: /* $Header: POXSERPRB.pls 120.1 2007/12/25 12:24:54 krreddy noship $ */
3:
4: function BeforeReport return boolean is
5:
6: l_person_id PER_ALL_PEOPLE_F.person_id%TYPE;
7: l_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE;
8: l_vendor_name_where VARCHAR2(1000);
9: l_buyer_where_h VARCHAR2(400);
10: l_buyer_where_r VARCHAR2(400);

Line 116: FROM per_all_people_f papf

112: IF (P_BUYER IS NOT NULL) THEN
113:
114: SELECT papf.person_id
115: INTO l_person_id
116: FROM per_all_people_f papf
117: WHERE papf.business_group_id = (
118: SELECT nvl(max(fsp.business_group_id),0)
119: FROM financials_system_parameters fsp)
120: AND trunc(sysdate) BETWEEN