APPS.OPI_OPM_COMMON_PKG dependencies on SY_ORGN_MST

Line 19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c

15: WHERE whse_code = l_whse_code;
16: CURSOR CUR_COST_MTHD(l_whse_code IN ic_whse_mst.whse_code%TYPE)
17: IS
18: SELECT b.orgn_code,c.GL_COST_MTHD
19: FROM ic_whse_mst a, sy_orgn_mst b, GL_PLCY_MST c
20: WHERE a.whse_code = l_whse_code
21: AND a.orgn_code = b.orgn_code
22: AND b.co_code = c.co_code;
23:

Line 26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;

22: AND b.co_code = c.co_code;
23:
24: /* Local Variable Declaration */
25: l_whse_code ic_whse_mst.whse_code%TYPE;
26: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
27: l_cmpntcls_ind CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
28: l_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
29: l_total_cost NUMBER;
30: l_no_of_rows NUMBER;

Line 206: FUNCTION OPMCO_GET_RSRC_COST( p_ORGN_CODE IN SY_ORGN_MST.ORGN_CODE%TYPE,

202: END OPI_OPM_GET_CHARGE;
203:
204: /* Function to Find Resource Cost */
205:
206: FUNCTION OPMCO_GET_RSRC_COST( p_ORGN_CODE IN SY_ORGN_MST.ORGN_CODE%TYPE,
207: p_RESOURCE IN CR_RSRC_MST.RESOURCES%TYPE,
208: p_Cost_mthd IN cm_rsrc_dtl.cost_mthd_code%TYPE DEFAULT NULL,
209: p_usage_uom IN cm_rsrc_dtl.USAGE_UM%TYPE,
210: p_Transaction_date IN DATE)

Line 213: CURSOR CUR_COST_MTHD(l_orgn_code IN sy_orgn_mst.orgn_code%TYPE)

209: p_usage_uom IN cm_rsrc_dtl.USAGE_UM%TYPE,
210: p_Transaction_date IN DATE)
211: RETURN NUMBER
212: IS
213: CURSOR CUR_COST_MTHD(l_orgn_code IN sy_orgn_mst.orgn_code%TYPE)
214: IS
215: SELECT b.CO_CODE,c.GL_COST_MTHD
216: FROM sy_orgn_mst b, GL_PLCY_MST c
217: WHERE b.orgn_code = l_orgn_code

Line 216: FROM sy_orgn_mst b, GL_PLCY_MST c

212: IS
213: CURSOR CUR_COST_MTHD(l_orgn_code IN sy_orgn_mst.orgn_code%TYPE)
214: IS
215: SELECT b.CO_CODE,c.GL_COST_MTHD
216: FROM sy_orgn_mst b, GL_PLCY_MST c
217: WHERE b.orgn_code = l_orgn_code
218: AND b.co_code = c.co_code;
219:
220: /* Local Variable Declaration */

Line 221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;

217: WHERE b.orgn_code = l_orgn_code
218: AND b.co_code = c.co_code;
219:
220: /* Local Variable Declaration */
221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
223: l_co_code sy_orgn_mst.orgn_code%TYPE;
224: l_calendar_code cm_rsrc_dtl.CALENDAR_CODE%TYPE;
225: l_period_code cm_rsrc_dtl.PERIOD_CODE%TYPE;

Line 223: l_co_code sy_orgn_mst.orgn_code%TYPE;

219:
220: /* Local Variable Declaration */
221: l_orgn_code sy_orgn_mst.orgn_code%TYPE;
222: l_cost_mthd cm_cmpt_dtl.cost_mthd_code%TYPE;
223: l_co_code sy_orgn_mst.orgn_code%TYPE;
224: l_calendar_code cm_rsrc_dtl.CALENDAR_CODE%TYPE;
225: l_period_code cm_rsrc_dtl.PERIOD_CODE%TYPE;
226: l_rsrc_cost NUMBER;
227: BEGIN

Line 236: FROM SY_ORGN_MST

232:
233: CLOSE CUR_COST_MTHD;
234: ELSE
235: SELECT CO_CODE into l_co_code
236: FROM SY_ORGN_MST
237: WHERE ORGN_CODE=p_ORGN_CODE;
238: END IF;
239: SELECT NOMINAL_COST into l_rsrc_cost
240: FROM CM_RSRC_DTL a,CM_CLDR_DTL b,CM_CLDR_HDR c