APPS.PO_POXSERPR_XMLP_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 7: l_inv_org_id FINANCIALS_SYSTEM_PARAMETERS.inventory_organization_id%TYPE;

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);
11: l_creation_date_where_h VARCHAR2(400);

Line 119: FROM financials_system_parameters fsp)

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
121: papf.effective_start_date and papf.effective_end_date
122: AND decode(hr_general.get_xbg_profile,'Y', papf.business_group_id
123: , hr_general.get_business_group_id) = papf.business_group_id

Line 137: FROM financials_system_parameters fsp;

133: THEN
134:
135: SELECT fsp.inventory_organization_id
136: INTO l_inv_org_id
137: FROM financials_system_parameters fsp;
138:
139: IF ((P_ITEM_FROM IS NOT NULL) or (P_ITEM_TO IS NOT NULL))
140: THEN
141: