APPS.PMI_SALES_PKG dependencies on HR_OPERATING_UNITS

Line 183: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,

179: END IF;
180: END IF;
181: END PMISA_GET_TOP_N;
182:
183: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
184: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
185: p_Prd_start_date IN DATE,
186: p_Prd_end_date IN DATE,
187: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,

Line 195: Cursor cur_item ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,

191: RETURN NUMBER
192: IS
193: /* cursor to Fetch Top products with respect to margin */
194:
195: Cursor cur_item ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
196: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
197: p_Prd_start_date IN DATE,
198: p_Prd_end_date IN DATE
199: )

Line 262: HR_OPERATING_UNITS ou,

258: OE_ORDER_LINES_ALL orderdetail,
259: OE_SYSTEM_PARAMETERS_ALL masterorg,
260: MTL_SYSTEM_ITEMS msi,
261: IC_ITEM_MST itemmst,
262: HR_OPERATING_UNITS ou,
263: GL_SETS_OF_BOOKS sob,
264: IC_WHSE_MST fromwhse
265: WHERE
266: orderhdr.header_id = orderdetail.header_id

Line 281: Cursor cur_customer ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,

277: GROUP BY item_id
278: ORDER BY Margin desc;
279:
280: /* Cursor to get Top N customers with respect to Margin */
281: Cursor cur_customer ( p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
282: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
283: p_Prd_start_date IN DATE,
284: p_Prd_end_date IN DATE
285: )

Line 348: HR_OPERATING_UNITS ou,

344: OE_ORDER_LINES_ALL orderdetail,
345: OE_SYSTEM_PARAMETERS_ALL masterorg,
346: MTL_SYSTEM_ITEMS msi,
347: IC_ITEM_MST itemmst,
348: HR_OPERATING_UNITS ou,
349: GL_SETS_OF_BOOKS sob,
350: IC_WHSE_MST fromwhse,
351: PMI_HZ_PARTY_V billingcustomer
352: WHERE