DBA Data[Home] [Help]

APPS.MTL_SAFETY_STOCKS_PKG dependencies on MTL_PARAMETERS

Line 325: /* with MTL_PARAMETERS table. */

321:
322: /********************************************************/
323: /* Select calendar Code and Exception Set Id for future */
324: /* use so that the SQL statements do not have to join */
325: /* with MTL_PARAMETERS table. */
326: /********************************************************/
327:
328: SELECT CALENDAR_CODE, CALENDAR_EXCEPTION_SET_ID
329: INTO cal_code, except_id

Line 330: FROM MTL_PARAMETERS

326: /********************************************************/
327:
328: SELECT CALENDAR_CODE, CALENDAR_EXCEPTION_SET_ID
329: INTO cal_code, except_id
330: FROM MTL_PARAMETERS
331: WHERE ORGANIZATION_ID = org_id;
332:
333: END Init;
334:

Line 573: /* with MTL_PARAMETERS table. */

569:
570: /********************************************************/
571: /* Select calendar Code and Exception Set Id for future */
572: /* use so that the SQL statements do not have to join */
573: /* with MTL_PARAMETERS table. */
574: /********************************************************/
575:
576: SELECT TO_NUMBER(TO_CHAR(effect_date, 'J'))
577: INTO j_effect_date