APPS.PMI_SALES_PKG dependencies on HR_OPERATING_UNITS

Line 43: Pv_pmisa_tp_om_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;

39:
40:
41: /* Added new variable to support OMSO which are at OU Level for Top N Products */
42:
43: Pv_pmisa_tp_om_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;
44: pv_pmisa_tp_om_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
45: Pv_pmisa_tp_om_Prd_start_dt DATE;
46: Pv_pmisa_tp_om_Prd_end_dt DATE;
47: Pv_pmisa_tp_om_top_n number;

Line 51: Pv_pmisa_tp_om_cust_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;

47: Pv_pmisa_tp_om_top_n number;
48:
49: /* Added new variable to support OMSO which are at OU Level for Top N Customers */
50:
51: Pv_pmisa_tp_om_cust_OU_ID hr_operating_units.ORGANIZATION_ID%TYPE;
52: pv_pmisa_tp_om_cust_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
53: Pv_pmisa_tp_om_cust_Prd_st_dt DATE;
54: Pv_pmisa_tp_om_cust_Prd_end_dt DATE;
55: Pv_pmisa_tp_om_cust_top_n number;

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

80: )
81: RETURN NUMBER;
82:
83:
84: FUNCTION PMISA_GET_TOP_N_BY_OU(p_OU_ID IN hr_operating_units.ORGANIZATION_ID%TYPE,
85: p_cost_mthd IN cm_cmpt_dtl.cost_mthd_code%TYPE,
86: p_Prd_start_date IN DATE,
87: p_Prd_end_date IN DATE,
88: p_item_id IN ic_item_mst.item_id%TYPE DEFAULT NULL,