APPS.CSTPACIN dependencies on MTL_PARAMETERS

Line 91: FROM mtl_parameters mp

87: | 0 for discrete/discrete xfer
88: +------------------------------------------------------------*/
89: SELECT MOD(SUM(DECODE(mp.process_enabled_flag,'Y',1,2)), 2)
90: INTO l_pd_txfr_ind
91: FROM mtl_parameters mp
92: WHERE organization_id = i_txn_org_id
93: OR organization_id = i_txfr_org_id;
94:
95:

Line 117: FROM MTL_PARAMETERS

113: (i_txn_action_id = 22 ) ) then
114:
115: SELECT count(*)
116: INTO l_avg_org
117: FROM MTL_PARAMETERS
118: WHERE ORGANIZATION_ID = i_txn_org_id
119: AND PRIMARY_COST_METHOD = 2;
120:
121: if (l_avg_org > 0) then

Line 158: FROM MTL_PARAMETERS

154:
155: if (l_pd_txfr_ind = 0) then
156: SELECT count(*)
157: INTO l_avg_org
158: FROM MTL_PARAMETERS
159: WHERE ORGANIZATION_ID = i_txfr_org_id
160: AND PRIMARY_COST_METHOD = 2;
161:
162:

Line 199: FROM MTL_PARAMETERS

195: elsif (i_txfr_cost_group_id <> -1) then
196:
197: SELECT count(*)
198: INTO l_avg_org
199: FROM MTL_PARAMETERS
200: WHERE ORGANIZATION_ID = i_txn_org_id
201: AND PRIMARY_COST_METHOD = 2;
202:
203: if (l_avg_org > 0) then

Line 256: FROM MTL_PARAMETERS

252: +------------------------------------------------------------*/
253: else
254: SELECT count(*)
255: INTO l_avg_org
256: FROM MTL_PARAMETERS
257: WHERE ORGANIZATION_ID = i_txn_org_id
258: AND PRIMARY_COST_METHOD = 2;
259:
260: if (l_avg_org > 0) then

Line 404: FROM MTL_PARAMETERS

400: IF ( I_TXN_ACTION_ID in (12, 21) ) THEN
401: BEGIN
402: SELECT 'Y'
403: INTO l_std_txfr_flag
404: FROM MTL_PARAMETERS
405: WHERE ORGANIZATION_ID IN ( i_txn_org_id, i_txfr_org_id )
406: AND PRIMARY_COST_METHOD = 1;
407: EXCEPTION
408: WHEN OTHERS THEN

Line 440: MTL_PARAMETERS

436: encumbrance_reversal_flag
437: INTO
438: l_enc_reversal_flag
439: FROM
440: MTL_PARAMETERS
441: WHERE
442: organization_id = i_txn_org_id;
443:
444: