DBA Data[Home] [Help]

APPS.EAM_CONSTRUCTION_EST_PVT dependencies on MTL_PARAMETERS

Line 839: FROM MTL_PARAMETERS MP

835: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
836: MP.PRIMARY_COST_METHOD
837: INTO l_cost_group_id, l_cost_type_id,
838: l_primary_cost_method
839: FROM MTL_PARAMETERS MP
840: WHERE ORGANIZATION_ID = p_org_id;
841:
842: SELECT EXTENDED_PRECISION
843: INTO l_ext_precision

Line 1042: FROM MTL_PARAMETERS MP

1038: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
1039: MP.PRIMARY_COST_METHOD
1040: INTO l_cost_group_id, l_cost_type_id,
1041: l_primary_cost_method
1042: FROM MTL_PARAMETERS MP
1043: WHERE ORGANIZATION_ID = l_org_id;
1044:
1045: SELECT EXTENDED_PRECISION
1046: INTO l_ext_precision

Line 1610: FROM MTL_PARAMETERS MP

1606: DECODE (MP.PRIMARY_COST_METHOD, 1, MP.PRIMARY_COST_METHOD, NVL(MP.AVG_RATES_COST_TYPE_ID,-1)),
1607: MP.PRIMARY_COST_METHOD
1608: INTO l_cost_group_id, l_cost_type_id,
1609: l_primary_cost_method
1610: FROM MTL_PARAMETERS MP
1611: WHERE ORGANIZATION_ID = p_ce_associatin_rec.ORGANIZATION_ID;
1612:
1613: SELECT EXTENDED_PRECISION
1614: INTO l_ext_precision