3610: /* Get the Default MOH sub element of the organization*/
3611:
3612: select DEFAULT_MATL_OVHD_COST_ID
3613: into l_default_MOH_subelement
3614: from mtl_parameters
3615: where organization_id= I_ORG_ID;
3616:
3617:
3618: -- Find out if there are any material overhead rows for the layer
4731: -- references enabled. The cost will be updated in CLCD, but not in CICD.
4732:
4733: /* select nvl(project_reference_enabled,0)
4734: into l_proj_enabled
4735: from mtl_parameters
4736: where organization_id = i_org_id;
4737:
4738: if (l_proj_enabled = 2) then
4739: l_mandatory_update := 1;
5203:
5204: /* Get the cost method for the org */
5205: select primary_cost_method
5206: into l_cost_method
5207: from mtl_parameters
5208: where organization_id = I_ORG_ID;
5209:
5210: if (l_cost_method = 5) then
5211: /* Try to return the first positive layer */
5931:
5932: l_stmt_num := 3;
5933: select decode(encumbrance_reversal_flag,1,1,2,0,0)
5934: into l_enc_rev
5935: from mtl_parameters
5936: where organization_id = i_org_id;
5937:
5938: l_stmt_num := 4;
5939:
6002: l_inv_ovhd_acct,
6003: l_inv_osp_acct,
6004: l_avg_cost_var_acct
6005: FROM
6006: MTL_PARAMETERS
6007: WHERE
6008: ORGANIZATION_ID = i_org_id;
6009: END IF;
6010: EXCEPTION